merge records with today's date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bcturner - 22 Jan 2004 21:35 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 08:46 GMT

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

Signature

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

>
> I need to do a mail merge for a form letter that will gather all of the
[quoted text clipped - 7 lines]
>
> ------------------------------------------------

Reply to this Message

Peter Jamieson - 23 Jan 2004 09:31 GMT

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

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I need to do a mail merge for a form letter that will gather all of the
> contact information from a MySQL database from that day. I have
[quoted text clipped - 6 lines]
>
> ------------------------------------------------

Reply to this Message