Ask Your Question

Mail Merge wildcards [closed]

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

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-04 23:59:02.546675

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 143 times

Last updated: May 14 '16