Print a daily Outlook email via Excel macro

[ArmsJeff]

I would like to add the ability to print an Outlook email, that is sent to me each day by the same person, to an existing Excel macro. Once the email prints I would like the rest of my macro to run.

The email does not have attachments and the subject phrase does not change.

Is this possible? If so how?

[Brian]

Yes, you can obtain complete control of outlook from excel and presumably, excel from Outlook. In VBA Editor, Choose References and check all of the Outlook libraries.

Search the MS site & help for more info on the commands.

One of my earlier replies about sending e-mails will give you some links to references that may be relevant.
http://www.mrexcel.com/board/viewtop...c=7311&forum=2

Good luck,

Brian