I have a VBA macro that will e-mail a simple text e-mail to a list of
individuals. This works fine but I'm looking for something a little
more complex. Two special needs a

1) How can I e-mail the contents of a Word doc (not as an attachment)
so as to retain the formatting of the original document but in the body
of the e-mail message?

2) How can set the parameter that delays the delivery of the message
until a specific time and date?

I'm pretty familiar with Excel VBA but not Outlook VBA. I'd like to
run this from an Excel sheet since that is where the list of e-mail
addresses is stored.

Thanks.

- John

Hi John

Which version do you use ?

See
http://word.mvps.org/
http://www.outlookcode.com/d/code/index.htm

And my site for Excel example code
http://www.rondebruin.nl/sendmail.htm



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


"John Michl" wrote in message oups.com...
I have a VBA macro that will e-mail a simple text e-mail to a list of
individuals. This works fine but I'm looking for something a little
more complex. Two special needs a

1) How can I e-mail the contents of a Word doc (not as an attachment)
so as to retain the formatting of the original document but in the body
of the e-mail message?

2) How can set the parameter that delays the delivery of the message
until a specific time and date?

I'm pretty familiar with Excel VBA but not Outlook VBA. I'd like to
run this from an Excel sheet since that is where the list of e-mail
addresses is stored.

Thanks.

- John

Thanks, Ron.

Did some poking around over the weekend and learned all I needed to in
order to complete my project.

Thanks.

- John