Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Envelope (XP; SP3)

    Does Excel's "MailEnvelope" feature have a "save as draft" feature? I could not find anything relating to it.

    With Sheets("Message").MailEnvelope
    .Introduction = "Introduction Message Here""
    .Item.To = "EmailAddress.com"
    .Item.Subject = "Subject of Email"
    .Item.Send Looking to save as draft. I don't want to send it.
    End With


    Thanks,
    John

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

    Re: Mail Envelope (XP; SP3)

    SandMail and MailEnvelope are very general, they work with all mail applications. Saving as draft is specific to some mail applications, so that is not provided.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Envelope (XP; SP3)

    Hans,

    Is there a list of "Items" that are available to MailEnvelope?

    I know there is a "To, Subject and Send" but what else is available.

    Thanks,
    John

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

    Re: Mail Envelope (XP; SP3)

    Item seems to correspond to the MailItem object in Outlook, so its properties and method will be those of MailItem, more or less. If you have Outlook, you can use .Item.Save to save the message in the Drafts folder of Outlook. No idea if this will work with other mail programs.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Envelope (XP; SP3)

    Hans,

    Is it possible to print the MailEnvelope? I can successfully send the message though Outlook but I would like a hard copy printed.

    The best I can do is print the sheet the MailEnvelope was created from. The printout does not include the typical "Recipient, Subject or Introduction". I don't necessarily want to go to Outlook, open each message and print from there.

    Regards,
    John

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

    Re: Mail Envelope (XP; SP3)

    I don't think you can print the mail envelope from Excel, you'll have to print the message from Outlook. Sorry.

Posting Permissions

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