Results 1 to 10 of 10

Thread: [RESOLVED] saving outlook mail item after sending it from vba

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2005
    Posts
    586

    Resolved [RESOLVED] saving outlook mail item after sending it from vba

    Hey,

    I'm using vba to send email with outlook.

    the outlook item is previewed before sent, so that the user can add email recipents, body text and attachements to the original message.

    I'd like to be able to save the mail item after it is sent from outlook with all the revisions that the user made to the original message (that was sent through the vba code).

    problems are:

    1. the users modifications are not saved to the file, just the original message that was sent from vba.

    2. for trying to save the file to hdd, I get the securtiy message prompting the user to authorize the sending (must I build a trusted object for this)


    here's the code:

    Set outlookApp = CreateObject("Outlook.Application")

    Set outlookMailItem = outlookApp.CreateItem(olMailItem)

    With outlookMailItem
    .To = strTo
    .Subject = Nz(strSubject)
    .Display
    End With

    strSubject = outlookMailItem.Subject
    outlookMailItem.SaveAs SaveFile, 3
    Last edited by bambo; Jan 7th, 2006 at 11:58 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width