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

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
 
G

Gina Whipp

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
 
Top