Linking from Access to Outlook.

[sstump]

I am trying to link from Access to one particular folder in Outlook and pull the necessary data. However when I look at the linked table it only records 1 line of the contents field and I need 14 lines to evaluate these survey results.

For example, the information being sent in the email looks as follows:
Question 1: 3
Question 2: 4
Question 3: 3
Question 4: 2
Question 5: 2
Question 6: 1
Question 7: 3
Question 8: 1
Question 9: 2
Question 10: 2
Question 11: 2
Question 12: 3
Question 13: 3
Question 14: 3

However Access is only capturing the first line of each email.

My question is how do I get it to read all lines. Also how can I get it to seperate this as Question # and Answer, so that it's easily queried.

 

[sstump]

One correction on this...hopefully this makes sense. When I look at the individual rows on the linked table and click on the contents field and arrow over it will show me the next line. So I guess all I need to know is how to split them up into seperate lines and then parse them after the ":". To build the query?