Collect data by Email in Access 2007. (1 Viewer)

[mahenkj2]

I want to collect data by email using this feature of Access 2007 but that needs to run a wizard. I need to automate this process through a code, please advise me the best way to do it. I would like to build a button which should send the email to collect data by email.

In my earlier post, I asked this to do in Windows live mail but came to understand that it may not be an easy task. Later, based on this understanding, I was able to convince some users to go for Outlook 2007 and so this new post.

best regards.

 

[mahenkj2]

After lot of googling, I found out the following way:

1. Select the table by using SelectObject macro.
2. Use macro "CollectDataviaEmail".

Tested in accdb as well as accde as well as in accdr. Works beautifully.

One last thing to check is whether runtime runs on the users where access is not installed because Microsoft says Access must be installed on the PC but that is not the big problem.

Thanks all.

best regards.