Excel/Word Mail Merge, saving as individual documents using two mergefields as name

Hi guys,

This is my first post on the forums, so hoping you can help me!

Essentially I've constructed a working Mail Merge in which data is pulled from Excel to build a number of different letters. My intention is to arrange a way of saving each letter individually, with two mergefields making up the title:

I.e, if one Mergefied was 'Customer ref': 1234567 and the second Mergefield was 'Brand': CompanyCo, ideally I'd want individual word docs to be saved with a filename like this: 1234567 CompanyCo

I've had a scour of the forums and whilst I've found similar queries, how I'm not sure how best to achieve this, nor have I located an instance in which someone has done this with two separate fields, whilst leaving the file editable (i.e. not PDF).

Can anyone assist? I'm assuming some swish VBA is the answer but I'm a bit of beginner in this respect.

Hi flakjack and congratulations on your first post.

See the files associated with post #5 in the following thread: http://www.excelforum.com/excel-prog...ail-merge.html

The above thread:
a. Uses an Excel Control file that uses VBA.
b. The control file runs Mail Merge using an Excel Data and a Word document.
c. This particular control file saves each 'Mail Merged Page' individually.

The following code excerpt (important lines in red) show how the Mail Merge is accomplished from the Excel control file:

Please Login or Register  to view this content.

Lewis

Thanks for the response, code worked well, just what I was looking for!