[AccessD] Transfer data from email to Access

Susan,

You can transfer data via email using .xml files.

1. Access will export from a table or query to an .xml file.
2. Send an email to the correct person with that file attached.

Do this:
3a. The recipient receives the email and moves the attached file to a
location.

Or this:
3b. Write code so that the recipient can simply select the email.  Access
(using Outlook VBA methods) can select the email and 'strip off' the
attachment to a specific location.

4. Access can now import that file to append the data to a table.  This
could be a temp table so that the data could be further manipulated.

I've done 3b enough to know that it does work.  In the next few days I'll
publish the key lines of code.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, April 15, 2008 9:13 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Transfer data from email to Access

Last summer I wrote an article on using Word forms to collect and transfer 
data to an Access database.

http://blogs.techrepublic.com.com/howdoi/?p=187

You don't really need to read the article to answer the following question, 
but thought I'd include the link just in case.

A reader wants to collect the data using a Word form and then send the form 
via Email and transfer to Access on the other end.

I don't think this is the right technique for that type of venture. First, I

thought using an Outlook custom form would be easier, but that restricts the

sender to using Outlook. Please don't suggest a .NET form -- if this reader 
knew .NET, he wouldn't be asking for help.

Any suggestions?

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com