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 Rhinorhino 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
Joined
Nov 9, 2003
Messages
54
Location
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 Question
Report waiting for printer before displaying results
Replies
3
Views
657
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Sending report via email only works when Outlook is closed
Replies
1
Views
803
breezett93
breezett93
JimStrand
  • Locked
  • Question Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
1K
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Print multiple copies of report data
Replies
5
Views
1K
dhookom
dhookom
SamuelR
  • Locked
  • Question Question
Dlookup in a report
Replies
13
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top