Devicode Technology Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Getting email address from PayPal "on behalf of"

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    Devicode Technology Forum Index -> Response Mailer
View previous topic :: View next topic  
Author Message
devicode
Site Admin


Joined: 05 Mar 2005
Posts: 249

PostPosted: Sat Apr 21, 2007 10:31 am    Post subject: Getting email address from PayPal "on behalf of" Reply with quote

I need to create a fancy-looking HTML auto-responder to send to each of my PAYPAL customers as soon as I receive the "payment notification" email from Paypal. (I'll copy-n-paste an ENTIRE sample message below).

AT A MINIMUM: I need the autoresponder to extract the CUSTOMER EMAIL ADDRESS (you can see it is sent to me in the form of "On Behalf Of"--rather than the normal "From" field). . . is this possible?

IDEALLY (asking to much?): I would ALSO like to extract the CUSTOMER's FIRST NAME, too.

If I had the 2 above bits of data, I could then send the customer a email "Hello--I got your order" HTML message; and personalize his message by addressing his FIRST name (i.e. "James" using the example message below).

What do you think? How close can I come to my wish list with "Response Pro"?
Code:
From: sendmail@paypal.com on behalf of jimbrown@somewhere.net
Subject: Notification of Payment Received

This email confirms that you have received a payment of $19.95 USD from James A Brown(jimbrown@somewhere.net).
View the details of this transaction online at:

Total Amount: $19.95 USD
Transaction ID: XXXXXX123456X111111
Quantity: 1
Item/Product Name: 1 Page Simple Resume
Buyer: James A Brown


Last edited by devicode on Sat Apr 21, 2007 7:59 pm; edited 5 times in total
Back to top
View user's profile Send private message Visit poster's website
devicode
Site Admin


Joined: 05 Mar 2005
Posts: 249

PostPosted: Sat Apr 21, 2007 10:38 am    Post subject: Reply with quote

Here is how you would extract the fields from the PayPal email message.

Setup an autoreply responder as follows.
Filters | Subject Line Contains : Notification of Payment Received
Filters | From Line Contains : sendmail@paypal.com

To extract the email address you would add an Extractor as follows
Select Extractor | Extract Data From Incoming Email
Field Name – Extracted_Email
Email Field – Select Message Body
Start of Data Field
From - Select Specific text
Text - From: [b]sendmail@paypal.com on behalf of

End of Data Field
From - Select End of line

To extract the first name you would add an Extractor as follows
Select Extractor | Extract Data From Incoming Email
Field Name – Extracted_FirstName
Email Field – Select Message Body
Start of Data Field
From - Select Specific text
Text - From: Buyer:
End of Data Field
From - <here you would enter a SPACE character>

You can now use the extracted field in your autoreply messages.
In the Message Header To use [[Extracted_Email]] for persons address and in the body use [[Extracted_FirstName]] for the persons first name.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    Devicode Technology Forum Index -> Response Mailer All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group