mail merges/publishing to Word--problems with both

[evansc]

I have a letter for faculty that we've always typed in Word based on a template. Well, now I have made a faculty DB that includes a lot of the information we would have to retype into that letter. So I want to make it easier with less typing.

My first thought was to do a mail merge. But I would need to pull the info from a query that I've limited based on the course the faculty members are teaching for. Word apparently doesn't recognize as possible data sources anything that has parameter limitations. It sees some queries, but only those that pull data from the WHOLE DB! Does anyone know if there's a way around this? (We have the XP suite and Access 2002, if that helps.)

My second thought was to just make the report and then publish it to Word (b/c there would still be a few minor edits to personalize letters from time to time.). It's perfect as an Access Report, but when I publish it to Word, one of the paragraphs at the beginning of the letter leaves off the last few words and then posts those words on the next page, in the middle of a different paragraph. It's not columns or anything--just a letter! Another paragraph does the same thing.

Does anyone have any ideas?

 

[dhookom]

I always export my records to either a csv or Word Merge file for merging so that Access isn't required when performing the merge. YOu can easily create a merge file or even your entire merge letters using the Query By Form found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.