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

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,

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Traffic Coordinator" <Traffic Coordinator@discussions.microsoft.com> wrote in message
news:297D8213-645B-44E1-A054-3D02994A5B59@microsoft.com...
>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,

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


--

Regards,

Peo Sjoblom


"Traffic Coordinator" <Traffic Coordinator@discussions.microsoft.com> wrote
in message news:297D8213-645B-44E1-A054-3D02994A5B59@microsoft.com...
> 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,