Re: How can I attach several reports to one email message?

NancyM <NancyM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Does anyone know how to attach several reports and/or tables from the
current database to one email message?

I have no idea what tables would look like when sent as attachments
and don't really care to experiment to find out. <smile> So I'd
suggest making a report based on that table.

Then I'd suggest explicitly creating PDF files from the reports.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required. http://www.lebans.com/reporttopdf.htm I use this
solution myself a number of times and am exceedingly happy with it.

Alternatively see Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: how to resize my partition while vista says it has no space but theres space enough
    ... Ok i decided to upload the reports, the attachments as asked but they are too large and uploading them here doesnot work, i put them here to see: ...
    (microsoft.public.windows.vista.performance_maintenance)
  • Re: Images in VBA application
    ... If you are printing the images in reports, to avoid memory leakage, you ... the Access formatting process prior to being spooled to the Printer Driver. ... Memory" error that can popup when printing image intensive reports. ... Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Attachment size reported as double the real size
    ... I'm not 100% sure what version of Outlook the recipient is using but I ... has reported email attachments doubling in size. ... Exchange Tracking Centre reports the true size of the email, ... * Moving a users' mailbox from one store to another results in an effective ...
    (microsoft.public.outlook.general)
  • Re: Why wont this statement work
    ... that you'll use a word reserved by Access/VB/JET ... ... "fredg" wrote: ... building reports in access for the first time. ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.reports)
Loading