merge records with today's date

[bcturner]

I need to do a mail merge for a form letter that will gather all of th
contact information from a MySQL database from that day. I hav
created a document in word, and can merge my records just fine.
However, the database grows by about 150 contact names everyday, and
only need to send letters to the ones captured that day. I have a
time stamp field in my database, and it is in the format YYYY/MM/D
HH:MM:SS. Can anybody point me in the right direction? Thanks fo
your help

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Use a query in the database to return only the records for the day and use
that query as the datasource for the mailmerge.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Peter Jamieson]

Do what Doug says, but if you're an SQL newbie MySQL the equivalent of a
"Query" is called a "View".