Consulting

Results 1 to 3 of 3

Thread: Auto reply with original email and reply to address

  1. #1

    Auto reply with original email and reply to address

    Hello
    First time user of the forum.
    I have a situation where I get these emails from service""intl.paypal.com when somebody pays me for something they bought. Paypal specifies in the reply to properties the email of the buyer.
    I want to autoreply to that email so it also contains the original email.
    I made a template with a reply message and set up a rule to reply when that email comes in.


    Here is the problem:
    When i do this the email gets sent to service""intl.paypal.com
    When I look in outlook it says in the from column service""intl.paypal.com and when I open the email and hit reply it shows the buyers email address in the to box and not service""intl.paypal.com and when I look at the properties of the email the buyers email shows up as


    From: "service""intl.paypal.com" <service""intl.paypal.com>

    X-Email-Type-Id: PPX000600

    Reply-To: One 506 Media <janedoe""hotmail.com.com>

    If i open the email and select reply it will show janedoe""hotmail.com in the to field.

    You think there is any way to prevent that so it goes to the buyer.

    It seems to me that if it were possible to open the email and then auto reply it would go to the buyer and then close the email again.

    Would it be possible to do with a macro so that when an email comes in it will run the macro, open the email, reply and then close the email ?

    Regards

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Moderator Bump
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Mentor skatonni's Avatar
    Joined
    Jun 2006
    Posts
    347
    Location
    If RunAScript is still available in Rules Wizard then

    Sub ReplyTo_Not_PayPal(currItem As mailItem)
    
        Dim myItem As mailItem
        
        Set myItem = currItem.reply
        Debug.Print myItem.To
        
        myItem.To = currItem.reply.To
        Debug.Print myItem.To
        
        myItem.body = "Here is your reply."
        ' or
        'myItem.HTMLBody = "Here is your reply in HTML."
        
        myItem.Display
        ' once tested replace with
        'myItem.Send
        
        Set myItem = Nothing
    End Sub
    To debug, mouse-click anywhere in the code. Press F8 repeatedly to step through the code. http://www.cpearson.com/excel/DebuggingVBA.aspx

    If your problem has been solved in your thread, mark the thread "Solved" by going to the "Thread Tools" dropdown at the top of the thread. You might also consider rating the thread by going to the "Rate Thread" dropdown.

Posting Permissions

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