Link to home
Start Free TrialLog in
Avatar of minus_17
minus_17

asked on

Sending a Report with Parameters with DoCmd.SendObject

Hello All,

     I need to send multiple emails using DoCmd.SendObject. Only thing is I need to send a report that the parameters are different for each person. Anyone have any ideas?

            Thanks in advance.
Avatar of dotthei
dotthei

Which parameters are different?
The recipient?
The query?
Avatar of minus_17

ASKER

The user's email address changes with each report along with the user's ID which is used to pull their account information.
The best way that I can think of is to write your code in a looping recordset based on a table of customers and email addresses.

You need to open a recordset that you can retrieve your name, account # and email address from. You then need to loop through the recorset and execute the docmd.send object procedure for every record.

Does this make sense?

Regards
Stu





ASKER CERTIFIED SOLUTION
Avatar of minus_17
minus_17

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
minus_17,
No comment has been added lately (67 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Accept minus_17's answer http:#8254684 and Refund

Please leave any comments here within 7 days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

TextReport
EE Cleanup Volunteer
---------------------
If you feel that your question was not properly addressed, or that none of the comments received were appropriate answers, please post a request in Community support (with a link to this page) to refund your points. https://www.experts-exchange.com/Community_Support/
TextReport
You are a busy one with these cleanups.

A domani, bello.