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
 

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

Mail Merge skipping records/sending one at a time 0
Can't send emails but can receive in Outlook 2019 1
Outlook 365 overriding formatting choices 0
Synchronization problems while moving folders to new email 1
Converting excel to PDF, single page converts to multiple HELP! 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
How do I migrate Outlook 2007 to Outlook 2019? 0

Top