Hello all,

I am pretty new to VB. I have played around with existing codes and edited them to make them work for me but am having no luck with this one.

Basically I have an email list in an excel sheet. I want to be able to click on any one of the email addresses and send a pre-written email with an PDF attachment located on a shared server via Microsoft Outlook.

I have been able to find threads that tell you how to send mail merges with attachments and the like but nothing for this. Any help would be well appreciated.

I am currently using Microsoft Office 2010

Many thanks

Steve