Re: Loop to export report and email to each person

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

charliesangels <charliesangels@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

What I would like to do is have some code that runs the query, selects a
project manager, run the query / report with only that project manager?s
data, export to Word (rich text), e-mail the report, then move on to the next
project manager and repeat.

So you need two queries. One by sample and another with the sample's
project managers on it.

For sample recordset looping logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

So you will have the loop for the project manager(s) records that
match that sample inside the loop for the sample.

Within the second loop you will do your work of sending the emails,
etc, etc.

Now why use Word? Why not create the report and then make a PDF file
from it? That would be less hassle I would think.
A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Required System Test Specialist
    ... Provide System Testing of the WCIS application during FY09, ... Execute test cases and report status to the ... Project Manager. ... Must have demonstrated ability to create and execute ...
    (comp.databases.pick)
  • Required System Test Specialist Immediately
    ... Provide System Testing of the WCIS application during FY09, ... Execute test cases and report status to the ... Project Manager. ... Must have demonstrated ability to create and execute ...
    (comp.databases.pick)
  • Re: [Algorithm] Sum of Primes < 1000000
    ... I was forbidden to make the algorithmic optimization, ... trouble because the report was too slow once they loaded all the data. ... The difference in that case was not weeks but a few hours of development time to implement the fix. ... That didn't happen until the project manager who had forbidden the change was replaced. ...
    (comp.lang.java.programmer)
  • Re: email alert and update task
    ... Did you place yourself at a higher level in the RBS above those who report ... Project manager assign a task to team member which start ... I tried to set up the resource break down structure and ...
    (microsoft.public.project.pro_and_server)
  • Re: Send email ?
    ... Base on my records I need to send 200 emails separately with attached report ... PDF files is Stephen Lebans solution. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)