How We Read A PayPal Notification Email Using VBA

Here Is How We Read A PayPal Notification Email Using VBA

Here are some screen shots from PayPal reader download that comes with The Toolshed (Order Here).

A newer version of this page with Access 2007 sample available in the Toolbox

Paypal Notification email with some contents blurred. Note that the paypal email is in HTML format so it is quite tricky to read in VBA code.

Move the email to the _Orders folder (using a rule or manually)

Open the Main form in the Access Database (you can import full code into your database)

Press the Extract button and Confirm that the order is OK.

The order is read, data is added to the table and the email is move to the _Orders Processing folder.

Click on the View Order button that will appear when the Paypal email order is moved successfully.

View the complete details on the form that pops up.

The data that was transferred from the PayPal Notification email to the table

Downloads

Click here for the Access 2000/2003 download file if you own "The Toolshed"

otherwise Order The Toolshed Here and receive a Microsoft Access help file with all the Toolshed downloads.

or Click here for the Access 2007 page and subsequent ACCDB file

Note: The Toolshed download for this article comes with full source code which includes late binding Outlook Automation calls and tricky html email parsing of the paypal email..

Other Pages At VB123.com You Might Want To Try

Stop Those Annoying Outlook Warning Messages
Processing Regnow E-Mail Orders using Outlook and Access
Form Based Selection Criteria For Queries using Combo Boxes

Author Bio.
Garry Robinson is the founder of GR-FX Pty Limited, a company based in Sydney, Australia. Garry has been involved in 100s of Access databases Access. Contact details in Australia Web http://www.gr-fx.com/