{"id":1983,"date":"2018-10-28T12:36:27","date_gmt":"2018-10-28T16:36:27","guid":{"rendered":"http:\/\/www.thatsoftwareguy.com\/blog\/?p=1983"},"modified":"2018-10-28T12:36:27","modified_gmt":"2018-10-28T16:36:27","slug":"printing-mailing-labels-from-salesforce","status":"publish","type":"post","link":"https:\/\/www.thatsoftwareguy.com\/blog\/2018\/10\/28\/printing-mailing-labels-from-salesforce\/","title":{"rendered":"Printing Mailing Labels from Salesforce"},"content":{"rendered":"

Thanksgiving and Christmas are just around the corner – would you like to send cards to your customers?\u00a0 Doing this with Salesforce and a Dymo printer is quite straightforward.<\/p>\n

You may want to create a new field in your Contacts account that allows you to mark customers who should receive cards.\u00a0 I have a Status field that allows me to find customers who have a Support agreement with me, and I select on that basis.\u00a0 (If you’re unsure how to add a new field to an object, watch this video from Salesforce<\/a>.)<\/p>\n

In Salesforce, go to Reports->New Report.\u00a0 \u00a0Select “Accounts & Contacts,” and use the report type “Contacts & Accounts.”\u00a0 \u00a0Update the columns so you use the following fields:<\/p>\n

 <\/p>\n\n\n\n
First Name<\/span><\/td>\nLast Name<\/span><\/td>\nAccount Name<\/span><\/td>\nMailing Street<\/span><\/td>\nMailing City<\/span><\/td>\nMailing State\/Province<\/span><\/td>\nMailing Zip\/Postal Code<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

If required, you can also add Mailing Country.\u00a0 Once you have all your fields selected, use filters to reduce the list to only the contacts you want, selecting on the field you used to determine if the contact gets a card.\u00a0 In my case, that would be the Status field.\u00a0 Then do an Export, and choose “Details Only” with format CSV.<\/p>\n

In the Dymo Label app on your computer, use File->Import Data->New.\u00a0 The default label is Address Barcode on Top, but you can change this if you like.\u00a0 I like the address label without a barcode.\u00a0 Select your data file (the CSV you just created from Salesforce), and click Next.\u00a0 On the “Arrange Data Fields on the Label Layout” page, check the box labelled “Use first row as field names.”\u00a0 To create the label, you just double click on each field, and lay it out on the label.\u00a0 By the time you’re done, you should have something like this:<\/p>\n

\"Dymo<\/p>\n

Now just print them out and get cracking on those holiday cards!<\/p>\n","protected":false},"excerpt":{"rendered":"

Thanksgiving and Christmas are just around the corner – would you like to send cards to your customers?\u00a0 Doing this with Salesforce and a Dymo printer is quite straightforward. You may want to create a new field in your Contacts account that allows you to mark customers who should receive cards.\u00a0 I have a Status … Continue reading Printing Mailing Labels from Salesforce<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[90,58],"tags":[],"class_list":["post-1983","post","type-post","status-publish","format-standard","hentry","category-salesforce","category-that-software-guy"],"_links":{"self":[{"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/posts\/1983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/comments?post=1983"}],"version-history":[{"count":5,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/posts\/1983\/revisions"}],"predecessor-version":[{"id":1989,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/posts\/1983\/revisions\/1989"}],"wp:attachment":[{"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/media?parent=1983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/categories?post=1983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thatsoftwareguy.com\/blog\/wp-json\/wp\/v2\/tags?post=1983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}