Access Data Collection by E-Mail

[Taffski]

Hi troops,

Completing the html wizard for Access Data Collection by e-mail is straightforward enough but I need to change the instructions underneath each of the data fields prior to sending out the e-mail, to ensure (so far as possible) that the forms are completed with the correct information - which, regrettably is not always proving to be the case.

I did this some time back with another e-mail ADC form I completed but for the life of me cannot remember how!!

Any help gratefully received.

Thanks in advance.

 

[AccessMSSQL]

Here is an article that may help you:

http://blogs.office.com/b/microsoft...automate-data-collection-forms-using-vba.aspx

 

[AccessMSSQL]

Here's another one:

http://www.pcreview.co.uk/forums/access-2007-email-template-help-t3775215.html

 

[Taffski]

Many thanks for the replies.

However, through just pottering about, the simplest solution was so ridiculously easy I was embarrassed to have asked in the first place. I knew that, having done this before, it must be easy!!

All I did was right click on the e-mail created by Access and selected from teh drop down menu 'Remove Content Control' and I was then able to amend the 'strapline' instructions beneath each of the data fields - with no effect on the function of data gathering.

As those in the UK will recognise........simples!!