Print a daily Outlook email via Excel macro

ArmsJeff

New Member
Joined
May 5, 2002
Messages
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?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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/viewtopic.php?topic=7311&forum=2

Good luck,

Brian
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top