Access Report Bursting

D

Dean Underwood

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.
 
R

Rick B

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
 
D

Dean Underwood

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?
 
R

Rick B

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
 
D

Dean Underwood

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