Trying to do a mail merge

[Kathyrlcrs]

My problem is this.
I have created a report using Crystal 9.0. It is a listing of Brokers from an Access Database. I have an extensive record selection critera. Now I have a request to do a mail merge for this listing. They want to send out a form letter.
I have the form letter in Word because we did a mailing using it but not with this criteria.
How can I do a mail merge in Word using the criteria that is in my report in Crystal? Or should I be doing the merge somewhere else.
Any help or suggestions would be appreciated.
Thank you!!

 

[synapsevampire]

You can do a Mail Merge in Crystal. File->New->Form Letter

Crystal isn't a database, so you can't link your Word doc to Crystal as a data source, although you could just export the data from Crystal to Excel or something and use that from within Word.

If you prefer to use Word, then I would use the same criteria in the Microsoft Query portion of the Mail Merge to filter the data the same way.

-k

 

[Kathyrlcrs]

I have tried that, but it only allows me to do 6 criteria statements.
I have also tried to export the Crystal to Excell. I did that. It came out as a nice report, but I have not been able to figure out how to get the fields into my Mailmerge in Word. If you can point me in a direction to find that I would appreciate it.

 

[synapsevampire]

MS Query isn't limited to 6 criteria unless you have a very old version, just select the AND radio box.

To use Excel as your data source, export the fields so that you get only columns and rows.

Then in the Data Source of the Mail Merge select Open Data Source and change Files of Type to Excel.

-k

 

[Kathyrlcrs]

My query in word2000 gives me 6 spaces to put criteria. When I get to the last one is there some way I can keep inputting with an and or and or?
I guess I do not know how to do this.