Emailing Excel File to Multiple Addresses

[Guest]

I have an excel file that contains payment remittance data from many companies that I want e mailed to each company individually. However the info to be sent can only be the info for that company and not everyone elses.

Also, if the sending of the emails to each company can be automated, that would be great

Can anyone help?

 

[Norman Harker]

Hi DougJoe!

Take a look at:

Ron de Bruin:
http://www.rondebruin.nl/sendmail.htm#sheets

If you put each company's info on a separate sheet or make sure that
no "foreign" data is on the sheet, Ron's code will be very useful.

I use it a lot to send out individual marking breakdowns to students.

For one off sheet sending, and in any event, you might download
SendMail (3.1 for Outlook or 2.1 for Outlook Express). Available free
with user guides from the same website.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.