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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Emailing Access "reports" to addresses in data

Status
Not open for further replies.

jslone

Technical User
Aug 20, 2008
1
US
We use Access 2007 to generate reports (containing information in a database)in letter form that we send to clients also in the database. I'm trying to switch from letter form to emails. I can get the report and use SendTo to create the email but that requires retyping the address but would much prefer the address to automatically be inserted in the send to line of the email. Any suggestions would be appreciated. I didn't think this would be hard but haven't been able to figure it out on my own yet.
 
Can't you use the DoCmd.SendObject method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top