| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating an email list | Excel Discussion (Misc queries) | |||
| Creating a macro from an email attachment | Excel Discussion (Misc queries) | |||
| Creating a hyperlink to email the worksheet | Excel Discussion (Misc queries) | |||
| creating hyperlinks to email | Excel Discussion (Misc queries) | |||
| Creating body in email | Excel Programming | |||
Hybrid Mode
