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.