Help with Creating Email
 

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

Help with Creating Email
 

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

Help with Creating Email
 

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

Help with Creating Email
 

Not shown in any of his examples that I am aware
Click on the Tip link on each example page Greg

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



"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

Help with Creating Email
 

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