asked on

Access 2007, invoke Manage Replies wizard via on form cmb

Hello all,

I am working on a local DB that will be used to track some training. I would like to use the built in automation of the e-mail data collection capabilities. I have the structure and forms complete, I am just trying to make it so that my user does not have to navigate the ribbon to get to the Manage Replies wizard.

I have a cmbSendMail on my form, that I need to invoke the wizard. I did some digging around MS, and TechNet but came up with very little that was helpful.

Thanks.

TLH

ASKER CERTIFIED SOLUTION

puppydogbuddy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tony Hungate

ASKER

I looked over the msdn article, like you said there really isn't a lot of infor out there. I think that might be a good start, if I can find the time to play with all of the different aspects metioned therein.

I am going to leave this question open for a bit to see if someone finds that magic nugget of info.

Thanks puppydogbuddy

TLH

puppydogbuddy

may be the nugget you are looking for (see code by Arvin Meyer):
http://www.accessmonster.com/Uwe/Forum.aspx/access/92331/How-do-I-collect-data-via-email-for-a-specific-record-in-a-table
Some more good reference sources:
http://www.databasedev.co.uk/access2007_collect_email_data.html

http://www.informit.com/articles/article.aspx?p=727322&seqNum=4 (scroll down to email topic)

http://office.microsoft.com/en-us/access-help/data-collection-e-mail-options-HA010030534.aspx

http://office.microsoft.com/en-us/access-help/demo-collect-data-in-access-2007-by-using-e-mail-HA010252713.aspx [Also see hyperlinks on the right]

Tony Hungate

ASKER

After doing some reading and looking into it, I think this would be much more work than it is worth at the moment. Thank you both for your participation, I will be splitting the point between the two of you.

TLH