I need a Email Sending and Retrieving MS Access 2003 Application. This application will have 2 parts.
First part is to create a MDB file by exporting certain tables from the main Access Database. Then, this MDB file will be send as an attachment in an email thru a gmail account. It will also send out a SMS thru a 3G Modem to notify user that the email has been sent.
Second part is to retrieve the MDB file sent from the email and import the tables to the main Access Database.
I will need the full working application including any macros or VBA module codes so that I can customize it to my needs.
Please note that some fields in the tables will be OLE object fields such as a photo. I will provide sample Access Database that needs to be emailed and retrieved.