Mail Merge to chosen template?

[CutAndPaste]

Demo file attached

I want to output a single record to a Word Template.

I got a single template version of this working with a hard coded path to the template. But I wanted to choose a different template, i.e. use the same info, but write a different letter. I set up a combo with the template details in.

However, whilst this works to a point, on my PC, all of the fields were output to the template, but were run together in a line accross the top of the document.

Any ideas on how to fix this?

tx

 

[Michelangelo]

Hi,

I attached your db but working as you wish.
The dot-filenames are located in a new table called Templates, to which the combobox refers.

HIH

Michelangelo

 

[CutAndPaste]

Fixed it !

Michelangelo,

Thanks for your reply,

I came back to post my own fixed version and found your fix!

Essentially we'd done the same thing, which was to fix the rowsource of the combo.

My new upload shows a static and a Choose template version of the Merge to Template.

Hope people can get something from this!

tx