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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Query Field to name SendObject file 3
Sending email from access with attachment via Outlook Express6 3
How to pass email addresses to an Access macro that is sending ob. 1
Sending An access report in PDF format 2
sendobject in a macro 1
SendObject Macro to multiple Recipients 1
send email to that employee on the current record in a form 3
Sending multiple queries in an e-mail 3

Back
Top