Access Data Collection through Outlook - Help please!

[chabbir]

Hi,

Thanks in advance for reading this post.

I have setup a access 2010 database to collect the data through outlook 2010 using the access data collection wizard.

I have send the email to a group email id and this group comprises of 20 - 25 people. Each one of them will reply with the data using outlook and access will update it automatically in a table.

Now my concern is that I want to know which salesperson has replied what. I was thinking of creating a field in the table which get auto updated with the outlook login id of the person replying the mail. I tried searching many posts and forums but with no success.

Any advise if what I am planning is possible and any guidance as to how should I proceed further...

Thanks again

Chabbir

 

[chabbir]

Thanks for replying.

Yes I can come to know from the email who has replied but this data collection is expected to be used quite often and single person can reply multiple times, as and when a salesperson has any inquiry, he will reply to the email and Access Data collection feature will automatically process the data and update the relevant tables.

Based on the data there are certain reports and analysis to be done and the sender's email or login id is needed in such cases. Manually updating the field will defeat the whole automation objective.

Any suggestion as to how to achieve this?

Thanks

chabbir