Mail merge with alot of selection criteria

[Kathyrlcrs]

Here is my problem. I have a database in access. I have done a report for a broker listing using Crystal Reports and accessing that database. I have an extensive list of selection criteria using the record selection in Crystal. The report worked fine. Now i have a request for a mailing using that list of Brokers. I am having a hard time tryng to create the mailing because mail merge in word is limited to how many criteria I can have. I tried to create a simple select query in Access and that is limiting me to the criteria on one field.
What am I missing on how to do a simple mail merge with this database and the criteria?
Any help would be greatly appreciated.

 

[psemianonymous]

I've come up with a (pretty large) code solution for this problem. You figure out how to generate the equivalent SQL statement with all the parameters hard-coded into the SQL, and you will be able to use this procedure to painlessly use Mailmerge:


thread705-821410

 

[Kathyrlcrs]

Is this the mailmerge in word? I can use that sql in word?

 

[lespaul]

No, you will need to put that code into Access, when you call the code, it will open word.


Leslie