Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field value visible in E-mail header 1

Status
Not open for further replies.

Ctrler

MIS
Oct 31, 2001
18
0
0
FI
When sending a report for one record via e-mail, is there a way to automatically include a certain field value (eg. RecordID) in the e-mail header?

Thanks, Gion

see also thread181-159806
 
DoCmd.SendObject acReport, "reportname", acFormatRTF, "email@email.com", , , "subject text " & [Forms]![formname]![RecordID], "main message text"

hope this helps....
 
Thanks benwah,
i still did it in a macro with SendObject, not in code, and included field values from the report (not from the form) in the message header:
=[Reports]![reportname]![RecordID]&" "&[Reports]![reportname]![Name]

Thanks for showing the direction.

Gion
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top