Hi everyone, I am a newbie to Excel VBA programming and am in need of some help.
I have a column in Excel which I have named 'Label' and runs from A1:A66. I would like to be able to mail merge this into Word labels and for the contents to be inserted via a mail merge. I know you can do this easily through mail merge but I want the code to do this from within Excel, as the labels can change from XXX001, XXX002 to AAA001, AAA002 etc.
I can get the Excel code to create my list and open word but can not get word to perform a mail merge. I have tried recording a macro and editing that but it didn't work.
Your help and thoughts would be greatly appreciated,
TIA
Mikey