• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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.
0
minus_17
Asked:
minus_17
1 Solution
 
dottheiCommented:
Which parameters are different?
The recipient?
The query?
0
 
minus_17Author Commented:
The user's email address changes with each report along with the user's ID which is used to pull their account information.
0
 
stuleesCommented:
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





0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
minus_17Author Commented:
Actually what I ended up doing is opening the report based upon a filter defined by the records then attaching the report, and then closing the report. Doesn't look the prettiest but it works.

                   Thanks all,
                      Josh
0
 
TextReportCommented:
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. http://www.experts-exchange.com/Community_Support/
0
 
dottheiCommented:
TextReport
You are a busy one with these cleanups.

A domani, bello.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now