[AccessD] Embed Query Results in an Email

Lonnie,

I've done something similar to what you are trying to do.  In my app, I
send out daily activity summaries using a procedure that opens a
recordset and steps through the resulting rows, formatting and appending
the values to a string variable.  The procedure adds column headers and
explanatory text to the string before using it as the body of an email
message that is sent using "Blat."  In my case, the process is triggered
automatically once a day, but you could just as easily put something
like this on a button.

HTH,

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie
Johnson
Sent: Tuesday, November 29, 2005 3:07 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Embed Query Results in an Email


The two queries hold the results of stats for case workers that are
mailed to the whole company. The requestor was wanting two embedded
tables vs attachements. The two queries are both three columns wide and
never have any more than 15 rows. It's inner office so everyone can read
HTML format.
   
  Thanks for the response.