Tags: access, addresses, combo, database, docmd, docmdsendobject, filtered, form, microsoft, multiple, mysql, oracle, output, record, reports, sendobjectis, sql

DoCmd.SendObject / multiple reports to multiple addresses

On Database » Microsoft Access

629 words with 0 Comments; publish: Sun, 01 Jun 2008 10:48:00 GMT; (25062.50, « »)

Maybe not possible ?

I am using Using DoCmd.SendObject

Is it possible to output reports to each record held in a filtered combo.

I have a form that a user selects a recipient to recieved a filtered report

by e mail as an attachment.

Of course they can simply select each line of the combo then click send.


Is there a way to run the report to that person then select the next line in

the combo and on until each report has been sent to all the people in the

combo. Basically looking for a Send All Reports button.

Any ideas would be great.


Manchester, England.

All Comments

Leave a comment...