Breaking down snapshot's

[Guest]

Hey Everyone,

I have a question about snapshots. I have a report that I want to run
every month from my database and email out to our customers. Within this
report is data pertaining to mulitple customers. I can already make so that
each customer gets their own pages, so that no 2 customers info is on the
same page. What I need to do is split the snapshot into muliple pieces so
that I can email customers only thier own info. Im not sure if there is a way
that I can. I am pretty good with VBA now so I just need a little direction.
Is there a way to split up a snapshot by category. And maybe even setup a
savefile naming scheme so that when I split the file I dont have to type in a
save as name 50 times. As always thanks very very much for all your help.
Have a great day!


James O'Donnell

 

[Larry Linson]

Other than using code to run a separate Report for each of the users, I know
no way to do what you want... at least not without some significant coding
to process the output file as text.

If you simply wanted to split a printed report, it would be relatively
easy... group by the category on which you want to split, use the "force new
page" property to cause each to print on a new page, and control page
numbering as described in http://www.mvps.org/access/reports/rpt0013.htm.
Unfortunately, that is no real help to you as you need a file to e-mail.

Larry Linson
Microsoft Access MVP