Everything about bulk email, emailing, mass email etc.

Hi,

With help in the past I’ve been able to grow my excel VBA knowledge widely.

I’ve been able to create new workbooks and save them out according to a company name in cell “E2″ and a date in cell “G2″.

So I now have a list of 40+ excel workbooks uniquely named by ‘Company’ and date and saved in the companies folder on a network drive that need to be emailed to each of the unique companies each month.

What I need to do to save me time is to automate the bulk emails and attachments.

I’ve found links and codes for sending an email for one attachment or email for the active workbook, what I can’t seem to find are suggestions for sending out emails according to a list of addresses (from excel) then have a pop up saying:

“ email ready, please select an attachment”
and have a dialogue box for you to get the attachment.

then loop to the next company name and address with a standard body text for each email.

Then Send all the emails out.

Any help would be GREATLY appreciated.

p.s. also, how would one set the ‘from’ part.

I generate documents about 25 pages long, that need to be printed and mailed to my customers. Basically, I would like to outsource the printing and mailng operation.