Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Print a daily Outlook email via Excel macro

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •