HOW TO PUT MORE THAN ONE WORKBOOK ATTACHMENT IN AN EMAIL?

[Traffic Coordinator]

I need to put more than one workbook in my emails as attachments. For my
co-workers as part of my job to give them listings of the product that we are
to recieve from the different forwarders that we use.

Please help,

 

[Ron de Bruin]

Hi

With code ?

If you use Outlook you can repeat this line in the code examples
..Attachments.Add ("C:\test.xls")

http://www.rondebruin.nl/sendmail.htm

 

[Peo Sjoblom]

Use outlook and insert instead of doing it from excel or use Ron's code