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!

Easiest way to print a report to file using VBA help?

Status
Not open for further replies.
newbee2

newbee2

Technical User
Apr 21, 2002
85
Hi,
Is it possible to transfer a report once it has been opened in VBA to a file on a hard drive. What would be the easiest way to do this in VBA. The reson is the report has to be sent on a monthly basis via e-mail.
Thanks
Regards
Bill
 
Sort by date Sort by votes
You can use the OutputTo

eg.

DoCmd.OutputTo acOutputReport, "rptAppend", acFormatTXT, "Append.txt", False

this sends the report called rptAppend to a text file called Append.txt
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
322
andre.meyer
A
renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
4K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
7K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top