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:

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: