Results 1 to 20 of 41

Thread: Macro to send out email based on criteria via outlook

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    VBAX Regular
    Joined
    Apr 2015
    Posts
    18
    Location

    Unhappy

    Thank you very much. Unfortunately the below code does not seem to be working? The macro will no longer bring up an email:

    oRng.Text = "Notification of email arrival" & vbCr & vbCr & _
    "Sender: " & .Sender & vbCr & _
    "Subject: " & .Subject & vbCr & _
    "Attachment: " & oAtt.FileName

    I simply replaced the original code - oRng.Text = "Notification of email arrival"

    Is that how it should be done? Apologies for the basic questions here however my knowledge is very slim!

    It now seems to be bringing the emails up HOWEVER it will not include the sender, subject or attachment info in the message.
    Last edited by MD011; 05-18-2015 at 04:42 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
  •