Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's VBA MAPI support
Hi,
Using VBA, is it possible to compose a mail message (header + body) and store it in Outlook Express' "Outbox" ? My goal is to write a macro that parses a worksheet that contains data such as customers' names, e-mail addresses and other stuff and programmatically compose e-mail messages on the fly and append them to Outlook Express' Outbox for further relaying to an SMTP server. If this is not possible or if Excel provides a better approach to what I want to achieve, please let me know. Thank you, Fernando Ronci E-mail: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's VBA MAPI support
Hi Fernando
Look on my site for examples http://www.rondebruin.nl/sendmail.htm Check out also the CDO page http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Fernando Ronci" wrote in message ... Hi, Using VBA, is it possible to compose a mail message (header + body) and store it in Outlook Express' "Outbox" ? My goal is to write a macro that parses a worksheet that contains data such as customers' names, e-mail addresses and other stuff and programmatically compose e-mail messages on the fly and append them to Outlook Express' Outbox for further relaying to an SMTP server. If this is not possible or if Excel provides a better approach to what I want to achieve, please let me know. Thank you, Fernando Ronci E-mail: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapi Problem | Excel Discussion (Misc queries) | |||
Mapi problem | Excel Discussion (Misc queries) | |||
Excel mail MAPI error | Excel Discussion (Misc queries) | |||
send mail with MAPI problem | Excel Programming | |||
MAPI create object error | Excel Programming |