I have been asked the question about importing data from the body of a email into access, and then splitting out into separate fields,
A example of the data is enclosed below, This would have to go into their own fields.
email_Q1_1_Your_Name:
John Smith
email_Q1_2_Managers_Name:
Jenny Smith
email_Q1_3_Site:
Anywhere
email_Q1_4_ACCOUNT_NUMBER:
11111111
email_Q1_5_Customers_Name:
Mr John Jones
Etc to :-
email_Q1_14_comments:
Test
A example of the data is enclosed below, This would have to go into their own fields.
email_Q1_1_Your_Name:
John Smith
email_Q1_2_Managers_Name:
Jenny Smith
email_Q1_3_Site:
Anywhere
email_Q1_4_ACCOUNT_NUMBER:
11111111
email_Q1_5_Customers_Name:
Mr John Jones
Etc to :-
email_Q1_14_comments:
Test