How to create mailing address labels for campaign members?
To create the mailing list, first run a report for the members of the campaign and the desired fields that you wish to put on the mailing label in Salesforce. Then export this report to excel .CSV.
For details on how to obtain the Report please read: How do I get a list of Campaign Members?
Open up Microsoft Word and go to : Tools | Letters and Mailings | Show Mail Merge Toolbar
Choose Main Document Setup (it's the first button on the Mail Merge Toolbar). Choose Labels. It will then ask you to choose your label options (it depends on the kind of label you're printing on).
Notice your Word doc in a format that is broken up into the labels.
Click Open Data Source (the button to the right of Main Document Setup). Now locate your report in the .CSV format.
Choose the Insert Merge Field button (sixth from the left on the Mail Merge Toolbar) and select the appropriate fields that you wish to merge data to.
After choosing all the fields, make sure to click the Propagate Labels button (11th from the left on the Mail Merge Toolbar). This will put in "<<Next Record>>" on all the ensuing labels and allow your mail merge to function properly.
Now merge the data from the .CSV to the word doc. To do so, click on the View Merge Data button which looks like <<ABC>> and is 8th from the left on the Mail Merge Toolbar.
The first page of successfully created mailing labels is now visible. To view the rest of the labels, scroll through the pages by using the "Next Record" button which is 14th from the left, or insert a number as to which page to view. To view all labels at once, simply choose Merge to New Document which is 4th from the right.
NOTE
The mail merge button will not work to create mailing address labels for campaign members. The reason is that none of the data fields necessary for a mail merge document are stored under the Campaign object.
000385220

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.