refreshing a table in outlook template based on an access query

[danatafl]

Each day I have to send out an email with 3 tables depicting the current
status of our testing. I have created an outlook template (form) and I drag
the queries one at a time into the template from an access database prior to
sending. This is OK but I would like to automate the process a bit. Firstly I
would like to open the template and it would automatically insert the tables
based on the latest data derived from the access query. Is this possible or
is there a alternative?

 

[a a r o n . k e m p f]

SQL Server can readMail programmatically.

Jet linked tables just aren't reliable enough for anything.

-Aaron

 

[Arvin Meyer [MVP]]

Each day I have to send out an email with 3 tables depicting the current
status of our testing. I have created an outlook template (form) and I
drag
the queries one at a time into the template from an access database prior
to
sending. This is OK but I would like to automate the process a bit.
Firstly I
would like to open the template and it would automatically insert the
tables
based on the latest data derived from the access query. Is this possible
or
is there a alternative?

Please ignore Aaron. He is fixated on SQL-Server and regularly trolls these
newsgroups. Besides, his suggestion probably wouldn't work in your case
since you'd have to rewrite everything you've done.

Yes you can do what you want. There may be an easier way, but I'd create
spreadsheets from the query using the TransferSpreadsheet Method, then
attach them to my Outlook email using the code at:

http://www.datastrat.com/Code/OutlookEmail.txt

Sample code for TransferSpreadsheet should be in the help files.

 

[danatafl]

Thank you Arvin. I will give this a shot over the next couple of days.