[AccessD] Transfer data from email to Access

How do you collect the data in the first place?

Susan H.


> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com