email each section of Access report to separate person?

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I have a very large report that is formatted in the usual
groupings. Ideally, I'd like to be able to email the
appropriate section of the report to the person it
references. Is there any way to do this? A piece of
mailer software? Anything? Thanks!
 
You can use the sendobject command for example

DoCmd.SendObject acSendReport, "name of your report here", acFormatSNP,
[CboEMail], , , "subject line of the e-mail", , True
End Sub

I am fairly new, there may be another way but my approad would be to break
the report up using a parameter query and combo box of all the people you are
sending the report to. Hope this gets you started.
 
You could use our batch reporting software to automate the process of
basically running this report using different criteria so each time it is
run
it creates what is needed for an individual. Creating a seperate pdf for
each person. You probably need to loop thru a recordset to set the criteria
of
each person.

Many ways to approach emailing, we have one example in our evaluation.

Worst case senerio is that you can steal some example code from our eval
and approach it using DoCmd.SendObject (if snp or rtf and emailing from
access work for you).

Mark
RPT Software
http://www.rptsoftware.com
 
Back
Top