Print a daily Outlook email via Excel macro

ArmsJeff · May 6th, 2002, 12:42 PM

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 · May 6th, 2002, 01:31 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 12:42 PM	#1
ArmsJeff New Member Join Date: May 2002 Posts: 14	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?

May 6th, 2002, 01:31 PM	#2
Brian Board Regular Join Date: Apr 2002 Posts: 113	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