vb123.com.au
Here Is How We Read A PayPal Notification Email Using VBA
for Access 2007 thru to Access 2000
Here are some screen shots from PayPal reader download that comes with The Toolshed (Order Here).
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
Your Sample Database Is Called "paypalorders.zip"
Sample database is suited to all versions of Access
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Your Access 2007 Sample Database Is Called "paypalorders2007.zip"
Sample database is suited to all versions of Access
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
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
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/
Published 2008-07
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number
of popular computer magazines, is now a book author and has worked on
100+ Access databases. He is based in Sydney, Australia
Access 2003 Security
