Using VBA to automate data collection?

[Sandbox]

Hi,

I'm creating a database for less computer literate people to use - and as part of its functionality the end user needs to collect data via email.

Is there a way (using VBA) to automatically send the email based on a table/query without having to use the send email wizard. ie the VBA code selects HTML message, selects the table/query to use etc (all the first 5 steps that the wizard would do).

Then the user at the end can select the email address to send emails using outlook.

Thanks

 

[John Big Booty]

Welcome to the form.

Have a look at the SenObject method, also have a look at the code here.

 

[Sandbox]

Thanks for your help John Big Booty, that looks like the sort of thing I was after.