Access Report Bursting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how to run a single customer listing report in
access and have it break and email by each sales person. Any help would be
appreciated.
 
Use the sorting and grouping options while in report design view. You can
set your first support/group to the field that identifies your sales person
and include a group header and/or footer. You can place a page break in the
footer from your toolbar.

Rick B
 
I am doing this in the report now. The question is there a way to set up a
macro or something to email out each break (i.e. salesman) in a separate RTF
automatically?
 
Ah, sorry.

The way I have done this is to create a form with the salesmen as my record
source (I have a query that simply pulls all the active userids). The form
has a field that displays that userid, and a button that says "email
reports".

The code behind that button grabs the userid, runs a report with the userid
as a filter and emails it to the user. Then, it loops to the next user and
repeats until .eof.

I don't hve my database on this computer, so I can't give you more details
without going to my car to get my laptop. If you need specific help, ask
and maybe someone will be able to help. I can post more details tomorrow,
if needed.

Rick B
 
I would love examples from anybody. If I get yours tomorrow that would be
great. I really appreciate all the help.
 
Back
Top