Ask Your Question

Mail Merge wildcards

asked 2016-05-14 16:26:18 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have set up mailing labels through mail merge using MySql database by way of an ODBC connection. I can use the "standard filter" to print only the people I want, and even use the wildcard feature in all the text fields as in <name> <like> 'dun*' which will return all names beginning with "dun"

My problem is I want to find all people who have a birthday in a specific month. I cannot figure out how to do a partial filter for just the month. I have tried #04*# for the first 2 digits of the date field, but that returns an error.

I know this is possible, but I can't seem to find the solution.

Please Help !!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-14 18:31:21 +0100

pierre-yves samyn gravatar image


I personally would go to simpler by adding the MONTH field to a query in the MySQL database.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-14 16:26:18 +0100

Seen: 79 times

Last updated: May 14 '16