Email Report tru Snapshot

[victorluke]

hi all,

how to send specific report to email? i made in macro SendObject and i tried
emailing the report successfully but i received all the records... Please
help me email the specific record only. Can Macro do it, im new to it but im
keen to it. if this works good..wew my department will easin the reporitng
system(in my own little way )

thank you so much!!!!

victorluke

 

[Tony Toews [MVP]]

how to send specific report to email? i made in macro SendObject and i tried
emailing the report successfully but i received all the records... Please
help me email the specific record only. Can Macro do it, im new to it but im
keen to it. if this works good..wew my department will easin the reporitng
system(in my own little way )

You'll have to use some VBA code within the report.

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/

 

[Steve Schapel]

Victorluke,

How do you identify the "specific record only". All you need to do is
base the report on a query, where the criteria defines which record(s)
you want included in the report. For example, if the report is supposed
to relate to the current record on a form which is open at the time,
then in the (usually) Primary Key field in the query that is the Record
Source of the report, you enter a criteria that references the Primary
Key field of the form's data, using syntax such as...
[Forms]![NameOfForm]![NameOfKeyField]