PDA

View Full Version : Hyperlinking



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

Kenneth Hobs
12-12-2013, 10:22 AM
IF the delay is due to PDF file size as you indicated, I don't see a way around it. You are limited by your computer hardware and internet limitations.

You can post your code if you like but I don't expect to see a problem.

Your best solution would be to send links to the files on a private or public server and place the files there.

If the problem is in the writing of extensive data to an Excel file, a few speed tips are in my article: http://vbaexpress.com/kb/getarticle.php?kb_id=1035