I think this is a little crazy but I supposed to figure out how to get the body of an email message (Outlook) into an Access DB table, with little to no effort :)
Here is the deal I receive email with the results from an online survey and I need to get the data into Access for reporting proposes.
-------------------------------------
I can get it in Access with a copy/ paste to Excel the use “Text to Columns” Then “Pate Special”/ “Transpose” to get the data into the fight format, and then save as a csv then import to Access. Obviously not the best way
I got the table set up with the appropriate fields.
Also a I have folder from my Inbox linked to Access, a make table query to only have the Body of the email in the table.
But I see no way to Link them or make the Outlook data (from the body of the message) useful.
Even with Export from Outlook to a csv, excel, or text files doesn’t come out right.
Here is a sample of the BODY of the email. The text before the “:” are the Column headings and the f’s and Strongly Agree are the records
training_class_on: ffffffff
like_about_job: ff
change_one_thing: ffffffffffffffffffffffff
changes_communicated: Strongly Agree
changes_communicated_memo: fffffffffff
tech_skill_needed: Strongly Agree
have_skill_knowledge_memo: ffff
Really I want know if it is possible to use the linked table from the Outlook to add the survey results to my table.
Honestly I don't think it will work so if you have any suggestions please I'm take any. !!!!
Any info would be great.