Home

Mail merge with labels

%3CLINGO-SUB%20id%3D%22lingo-sub-389094%22%20slang%3D%22en-US%22%3EMail%20merge%20with%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389094%22%20slang%3D%22en-US%22%3EHey%20everyone.%20I%20need%20some%20help%20with%20doing%20a%20mail%20merge%20using%20an%20existing%20list%20from%20excel%20that%20needs%20to%20be%20on%20labels.%20I%20can%20easily%20setup%20the%20mail%20merge%20to%20display%20the%20records%20needed%20on%20each%20label.%20I%E2%80%99m%20using%20the%20label%20template%20format%20that%20displays%2030%20labels%20total.%3CBR%20%2F%3E%3CBR%20%2F%3EAm%20I%20able%20to%20tell%20Word%20where%20to%20start%20and%20stop%20specific%20labels%3F%20For%20example%20say%20I%20have%2034%20records%20(or%20rows)%20in%20excel%20that%20go%20into%20the%20label%20mail%20merge..however%20let%E2%80%99s%20say%20half%20of%20them%20say%20%E2%80%9CUser1%E2%80%9D%20and%20the%20other%20half%20%E2%80%9CUser2%E2%80%9D.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20my%20%E2%80%9CUser1%E2%80%9D%20only%20displays%2017%20labels%20from%20my%20excel%20source%2C%20I%20want%20my%20next%20set%20of%20labels%20(User%202)%20to%20star%20on%20a%20new%20page%20and%20so%20on%20and%20so%20forth.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%3F%20Thank%20you!%3C%2FLINGO-BODY%3E
KAE88
Occasional Visitor
Hey everyone. I need some help with doing a mail merge using an existing list from excel that needs to be on labels. I can easily setup the mail merge to display the records needed on each label. I’m using the label template format that displays 30 labels total.

Am I able to tell Word where to start and stop specific labels? For example say I have 34 records (or rows) in excel that go into the label mail merge..however let’s say half of them say “User1” and the other half “User2”.

If my “User1” only displays 17 labels from my excel source, I want my next set of labels (User 2) to star on a new page and so on and so forth.

Is this possible? Thank you!
Related Conversations
Sharepoint document retention labels
svijayan in SharePoint on
2 Replies
Using Flow to send out automatic emails on a weekly basis
sokva in Office 365 on
2 Replies
Automatically applying labels to sites/site collections
Jakob Rohde in Office 365 on
9 Replies
Labelling by default
Andrew Huddleston in SharePoint on
1 Replies