?
Solved

Sending a Report with Parameters with DoCmd.SendObject

Posted on 2003-04-01
6
Medium Priority
?
317 Views
Last Modified: 2008-03-17
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
Comment
Question by:minus_17
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 4

Expert Comment

by:dotthei
ID: 8247416
Which parameters are different?
The recipient?
The query?
0
 

Author Comment

by:minus_17
ID: 8248496
The user's email address changes with each report along with the user's ID which is used to pull their account information.
0
 

Expert Comment

by:stulees
ID: 8249207
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Accepted Solution

by:
minus_17 earned 0 total points
ID: 8254684
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
 
LVL 28

Expert Comment

by:TextReport
ID: 8677473
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
 
LVL 4

Expert Comment

by:dotthei
ID: 8677542
TextReport
You are a busy one with these cleanups.

A domani, bello.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question