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!

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

Send Report as email/attachment by Outlook Express

Status
Not open for further replies.
zuza

zuza

Programmer
Nov 9, 2003
54
YU
Hello there,

Below statement is to send report as an attachment via Email/Outlook to Staff member. Please correct me whereever.

DoCmd.SendObject "Reportname", acReport, "Table", "[Claimno]= '" & Text80 & "'"


Thank you.

Zuz.
 
Sort by date Sort by votes

DoCmd.SendObject acReport, "Reportname", "RichTextFormat(*.rtf)", "", "", "", """[Claimno]= '"" & Text80 &", "", False, ""

RichTextFormat(*.rtf) is where your output option goes
Subject Line: [Claimno]='"" & Text80 &" will show up as just that.

The easiest way to do this is create a Macro using the SendObject Command and then convert it to VB.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

telephoto
  • Locked
  • Question
Report waiting for printer before displaying results 1
Replies
3
Views
334
dhookom
dhookom
breezett93
  • Locked
  • Question
Sending report via email only works when Outlook is closed
Replies
1
Views
610
breezett93
breezett93
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
825
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
822
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top