Thank Ron not me. Correction to my post:
With OutMail
..To = "
..CC = ....
etc.

Greg


"Don" wrote:

Thanks alot!

Don

"Greg Wilson" wrote in message
...
See Ron Debruin's site:

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

Not shown in any of his examples that I am aware is that you can send to
multiple recipients using a semicolon to concatenate the different
addresses,
e.g.:

With OutMail
.To = "
.CC = ....
etc.

Regards,
Greg


"Don" wrote:

I have an excel 2003 workbook in which sheet A contains a report that
needs
to be emailed on a regular basis. I would like to do this in VBA, but am
unfamiliar with the syntax to use. Email needs to show as if it was sent
via
Outlook 2003 (possibly showing up in sent folder of default email addy).
Any
help??

Don