Report from Word 2003

[GrahamK]

Dear All,

Please can you tell me if it is possible to have a word document as a report - with data in - so I could perform a glorified mail merge really? I tried doing a straight mail merge but it lacks the control and ability to query every time which record you want.

Many THanks
Graham

 

[Galaxiom]

This sounds like you are mail merging in Word using Access as the source of the dynamic data but you want more control than is offered by the standard mailmerge.
Access is not so well suited to producing a slab of text with variable phrases as Word is so capable of doing. Access is more suited to a static layout.

However if you can produce a table of the information you want to be used for each receipient based on certain properties of the receipient ( eg customer type, city etc) then you can use Access to produce customised queries for the mailmerge to work with. This would also include the name of the merge document you want to use.

Using VBA in Word you would loop through these lists and generate the variety of required letters.

Hope this makes sense.