Excel - Create Email with attachments from hyperlinks

[gidora]

Hi all

Lurked for along time and have always found answers until now.


I have a spreadsheet that has a row per house plot(we are a house building company) with a number of cells each with an hyperlink to a pdf file.

I need to be able, when all the information is complete for the row, to email the pdfs as attachements automatically.

I can do the subject,address and body within excel but don't no how the automate the attaching of the pdfs.


I hope I have explained the problem fuly enough.

Thanks in advance.


Jonathan