Tony Singh
12-12-2013, 09:59 AM
Hi
I have a spreadsheet which I compile every 4weeks which I use for emailing constructed as follows;
column 1 contains name of recipient
column 2 contains the email address
column 3 contains hyperlinks for pdf attachments.
Then I have a code that emails the attachment when it is run.
However, adding the attachments takes a considerable length of time. Is there an easier way or a code that I could run to attach the pdf's then run the email macro?
Any help would be appreciated.
Thanks
Tony
I have a spreadsheet which I compile every 4weeks which I use for emailing constructed as follows;
column 1 contains name of recipient
column 2 contains the email address
column 3 contains hyperlinks for pdf attachments.
Then I have a code that emails the attachment when it is run.
However, adding the attachments takes a considerable length of time. Is there an easier way or a code that I could run to attach the pdf's then run the email macro?
Any help would be appreciated.
Thanks
Tony