[AccessD] Embed Query Results in an Email

Lonnie Johnson prodevmg at yahoo.com
Tue Nov 29 17:46:48 CST 2005


How do you go about formatting and doing headers?

"Mcgillivray, Don [IT]" <Donald.A.McGillivray at sprint.com> wrote:  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.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.


More information about the AccessD mailing list