Putting Query Results Into Email

emcf

Member
Local time
Today, 07:21
Joined
Nov 14, 2002
Messages
209
info as body of email, not attachment

afternoon all,

apologies if this has been covered previously, have done a search but can't find an answer.....

problem: I need to send an automatic email to certain users every day. This i can do easily using docmd.sendobject (did use a macro to start with but access kindly converted it to code for me).
Curently this email has an html attachment with the info, however, I would much rather have the query results displayed in the body of the email rather than as an attachment.
is this possible on access97?

thanks in advance......
 

Users who are viewing this thread

Back
Top Bottom