Collect data by using e-mail messages



In Access 2007, a user can open a table, click on the External Data tab,
click on the Create Email group, and follow the steps to collect data updates
through email.

Rather than have to click on the tabs from the toolbar, I need to create a
macro so that when the user clicks a command button, the same events happen.

I asked this question a few weeks ago, but received just a few responses and
no one seemed to be aware that Access 2007 has the "Collect Data through
Email" option.

Thanks in advance for your time!


Tom van Stiphout

On Thu, 4 Feb 2010 06:31:01 -0800, *Glen*

One reason may be that it is highly unusual to allow users access to
the tables. Typically the developer sets this up for the table(s) that
warrant this, before the user even gets to see the application.

If your users are more developer-types, I'm sure they won't shy away
from a few mouse clicks.

Pretty much any menu operation has a RunCommand equivalent. Check it

Microsoft Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question