HTML reports from Access

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,

I am looking for a way to send some access reports out to
people through e-mail. I have built an access report
that shows weekly sales for various pracitioners in a
clinic. I have arranged the report to force a new page
after each pracitioner and have the practitioner name in
the page header section. So there are about five or six
pages in the report with each page being a new
therapist.

The best way I could think of to send these out is to
create html files and e-mail them to the pracitioner.
They are in different locations so I cant print them and
and hand them off. If I create pdf file then all five
pages of the report are one document which I dont want.
When I create html file by File => Send to => Mail
recipient as attachment => html it will create separate
files for each pracitioner which is what I want. But the
names of the files are called WeeklyReportPage1.html,
WeeklyReportPage2.htm. and so forth. Is there a way
through a template or something like that to name each
html page by the pracitioner name? I don't know much
about html templates.

Thanks,

Chuck

..
 
Change you report to be based on one practioner that is a
record on a form with thier email address. Then create a
macro similar to the one below which is from
http://www.granite.ab.ca/access/email.htm

The macro should contain these actions:
SendObject
GoToRecord , Next
In the To argument of the SendObject, put the equivalent of...
=[Forms]![NameOfYourForm]![NameOfEmailAddressControl]
Then make a second macro, with these actions:
GoToRecord , First
RunMacro , Name of first macro.
In the Repeat Count argument of the RunMacro action, put
10. This assumes there will always be 10, otherwise you
need to put an expression that counts the number of records.

Chris
 
You could just write a few lines of code to loop thru a recordset and email
each person and attach the one page as a pdf file to each email. We have an
example of how to do that in our batch reporting module.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

PS: Our example uses a cheap third party email component and win2pdf or
adobe pdfwriter pdf drivers.
 
Back
Top