Email report automatically with address that is incl in report

[Edain]

I am a beginner user of MS access. Basically I am sending out questionnaires with existing datato vendors and they should confirm/amend and send back to me. I was hoping to use the query function and 'collect and update data via email' but no joy as I get an error message "you cannot collect data for action queries, SQL-specific queries, and parameter queries by using email messages" - presumably as I have used the vendor identifier as a parameter criteria....


Anyway I now have decided to link the query to a report, then email from here - the email address data is captured in the report under the vendor information i.e it has it's own text box. Can I write something taht will take the email address and send direct from access via MS outlook. Also I generic text for each questionnaire is it better to add into the report or in the email body...can I write that in as well or am I becoming to complex (for my beginners brain!)?

Tvm in advance

[June7]

You can use SendObject method for the email but is very limited in how you can structure email. The SendObject will convert the report to designated format (such as pdf) and send as attachment to email. Alternative code does not use SendObject. Examples of both in http://msdn.microsoft.com/en-us/libr.../ff197046.aspx

The alternative would require actually saving the report as a pdf file then attaching pdf file to email. Can use OutputTo method.
Review
http://social.msdn.microsoft.com/For...5-2984825a60be
https://www.accessforums.net/import-...ook-18221.html