Results 1 to 7 of 7
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Excel controlling Outlook (Excel2000)

    Hi All

    I'm an Excel man so please don't send me to the Outlook forum!

    I have a mail message in a particular Outlook folder that I want to Forward a copy to someone by clicking a button in Excel.
    The mailitem has some attachments (which I want to include when I Forward the copy)
    I would like to add some body text to the Forwarded mail item.

    So,
    I can identify the particular mailitem from its unique Subject header
    I've got the following:

    zFolder ;this is the particular mail subfolder that has the mailitem I want
    zMailSubject ;this is the unique mail subject header to identify the mailitem I want to Forward a copy
    zMailBody ;this is the bodytext that I want to add to this existing mailitem
    zTo ;this is who I want to Forward the mail message to
    zCC ; this contains the recipients I want to cc copy the Forwarded mailitem to

    Is this simple to do?????

    As always I really appreciate all the help I can get!

    zeddy

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel controlling Outlook (Excel2000)

    Check out Ron deBruin's page Example Code for sending mail from Excel

    I can not help with programming in Outlook only in Excel. If you are an "excel man" you may have to go to the outlook forum for getting answers to the Outlook Model, even if you are calling it from Excel...

    Steve

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Re: Excel controlling Outlook (Excel2000)

    Thanks Steve

    It is a useful link for showing how to send worksheets, workbooks and all manner of stuff from within Excel
    I checked out the page but couldn't find what I needed.

    The Outlook forum made my head hurt.

    I'll have another bash later trying to sort this out.

    zeddy

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel controlling Outlook (Excel2000)

    I don't use Outlook, but if it has a macro recorder, you could try doing what you need to do with the recorder on to get the object's you need and then modify the code created. I find it much easier to modify than to create code especially when trying to learn the object model

    Steve

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Re: Excel controlling Outlook (Excel2000)

    If only it had a macro recorder!

    zeddy

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel controlling Outlook (Excel2000)

    Excel, Word, and powerpoint all have recorders which are very useful for learning each of their object models. Without a macro recorder, you really need to use the Outlook Forum to get information on the model or find a good reference book.

    Steve

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel controlling Outlook (Excel2000)

    As Steve already indicated, you WILL have to ask this question in our Outlook forum for the solution has nothing whatsoever to do with Excel.

Posting Permissions

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