Mail merge
System
Posts: 100,534 🤖 Admin 🤖
I know this isn't an accounting question, hence on this forum. But anybody know anything about mail merge?
We are trying to send out a mailshot and want to use labels to send out brochures. I've set up a data base on excel and have managed to get the labels printed of a sorts. Trouble is if a have say 50 records it prints out 50 sheets of labels, one for each record. If I ask it to fill in the rest of the labels, I still end up with 50 sheets, but with the rest of the addresses on, except sheet 2 starts with record 2, sheet 3 with record 3 etc. Hope this makes sense, any ideas?
We are trying to send out a mailshot and want to use labels to send out brochures. I've set up a data base on excel and have managed to get the labels printed of a sorts. Trouble is if a have say 50 records it prints out 50 sheets of labels, one for each record. If I ask it to fill in the rest of the labels, I still end up with 50 sheets, but with the rest of the addresses on, except sheet 2 starts with record 2, sheet 3 with record 3 etc. Hope this makes sense, any ideas?
0
Comments
-
Re:Mail merge
Isn't it easier to do it in Word?
I did it years ago, but not sure how!
0 -
Re:Mail merge
The mail merge is done in word Helen, but the "record" is in excel.0 -
0
-
Re:Mail merge
Thanks, I'll check this out when I'm in work tomorrow.0