How to send query results via email (not outlook) in Excel format

  • Thread starter Thread starter Corinna
  • Start date Start date
C

Corinna

Have used a macro to do this before with the SendObject. . . now it seems the
only option is to Send as pdf

Am still in 2003, but will be moving to 2007
 
Corrina,

Did you try? (Watch out for word wrap)

DoCmd.SendObject acSendQuery, "YourQuery", acFormatXLS, To, Cc, Bcc,
Subject, MessageText, EditMessage

I didn't have any sample data to fill in but I think you get the idea.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top