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.