Drag-and-Drop fills in the Form

[kevin_Carr]

Hi guys,

our team received webform booking requests which are in a text format. I would like to make it easier for my team to process these requests by dragging and dropping the email into a space on the form, which will in-turn auto-populate the form so that we dont have to manually fill it out.

The optimum process would be for the email to go straight into the form without us even touching it, but alas i havent worked out how to do that either. The process we are following is just a rudamentary (manual) workaround for what is meant to be an automated process.

MS ACCESS2007

kev

 

[spikepl]

If you are using Outlook:

Check out this: http://www.tek-tips.com/viewthread.cfm?qid=1346884

There are many other ways to do this.

In some applications, I parse the email inside Outlook, and either put the results in a file, or call an Access function. In another, I call an Access function and pass the entire body of the email in an argument, and then the mail is parsed in Access. All this is triggered by a custom button in Outlook menus. Fully automated processing can be done too, with a rule set up to trigger the code for certain mails.

 

[kevin_Carr]

Hi Spikepl,

thanks for that, i will attempt youtr suggestion, i think putting a button in Outlook sounds like a very good idea. I am the owner of the Functional Mailbox that the emails drop into, so hopefully I can work this out!


Kevin