Can you rework the report so that instead of a multi-page report, you have whatever number of one-page reports with different recipients? In other words, are the pages identical except for the data? If they are completely different, then they should be separate reports.
Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Harrison Sent: Monday, August 01, 2005 6:45 AM To: [email protected] Subject: [AccessDevelopers] Can I create a report in vba I have a requirement to send each page of a report to a different email address, which seems a problem. Is there a way then to create a report in VBA where I can loop through sending each report to a different user? Regards Pete ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h1kh7a2/M=362329.6886308.7839368.1510227 /D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122900298/A=2894321/R=0/SIG=11dvsfulr /*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hfpcepk/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122905693/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
