vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. Enhances the Toolshed More..


Upsize to SQL 
Upsize to SQL Server 2005 or 2008 or improve the performance of your Access to SQL Server application
Read More


DryToast New
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor 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
Contact Us ...

Search ...

or try our new Expression Web
 vb123.com.au
 

 

Next Tip  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).

 
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" 

  Click here for the Access 2007 download file if you own "The Toolshed" 

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

 

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

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals