SendObject Macro

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am trying to create a button on a form that will send
the results of a query to someone through e-mail. I
created a macro and then selected SendObject as an
action. In the "To" section I put the person's e-mail
address. In the Subject I put in a title called
Deletions to the Mailing List. I wasn't sure how to
handle the Message Text part. I have a query called
MailingDeletions. What I want to do is the have the
results of this query be in the body of the e-mail that I
send to someone. I created a form called Deletions and
have the query results appear when the form is opened. I
then put =[Forms]![Deletions] in the Message Text but am
getting error messages. Is there an easier way to do
this?

Thanks,

Chuck
 
Chuck,

Have a look at my reply to "Command Button to E-Mail"

In your case base a report on your query MailingDeletions and then send
that, you would not have to worry about the current record part.

If you cannot follow it, post back again.



John A
 
Back
Top