I merge several letters per day, from a database that I have in Excel. For each merge, I have to create a new Word document from a template. To do this I go to the mailings tab; Click on Edit the Recipients List and select the recipient. This can get very tedious indeed.
Is there any way that I can merge this data direct from Excel. My idea is to have a command button on the user form, that will open the necessary Word template and populate the merge fields.
I have searched everywhere but cannot, for the life of me, find anything. I realise that this probably means that no one has come across this type of problem before or it just cannot be done.
Please help as I am tearing my hair out and I am too young to go bald
Is there any way that I can merge this data direct from Excel. My idea is to have a command button on the user form, that will open the necessary Word template and populate the merge fields.
I have searched everywhere but cannot, for the life of me, find anything. I realise that this probably means that no one has come across this type of problem before or it just cannot be done.
Please help as I am tearing my hair out and I am too young to go bald
