YouTube Pinterest GooglePlus instagram

Blog

Nov 15, 2013

Simplify your Holiday Open House Parties!


It is time to start planning your holiday open house party! Let UnitWise help you send postcards with open house invitations & reminders.

If you are not an Address Label Wizard, no need to worry, we have provided 2 methods with easy to follow step-by-step instructions. You can print your address labels using Microsoft Word, or you can print them online at Avery.com.

Method 1 Using Microsoft Word:

Step 1:  First you will need to go to Home then Reports
Step 2:  Select Address Labels
Step 3:  Select the group you want to print
Step 4:  Choose export as excel and save it as (report.xls) on your desktop - and as an excel workbook 97-2003
Step 5:  Go to your desktop and open the (report.xls) file, then save as Mylabel3.xls - also as a excel workbook 97-2003
Step 6:  Open Microsoft Word, then choose mailings
Step 7:  Then click on start mail and labels, then a box will appear with labels listed - make sure 5160 is selected and click OK
Step 8:  Then click on select recipients and choose the second option (use existing list) - then select the Mylabel3 file from your desktop, after you do this there will be a pop up that comes up just click OK
Step 9:  Then click on the address block and click OK
Step 10:  Then click update labels
Step 11:  Select the finish and merge option and select the first option (Edit Individual Documents)
Step 12:  A Merge to New Document Box will appear.  Choose All, then select OK
Step 13:  You can then save it as whatever you wish and print it


OR Method 2 Using Avery.com:

Step 1:  First you will need to go to Home then Reports
Step 2:  Select Address Labels
Step 3:  Select the group you want to print
Step 4:  Choose export as .CSV file and save it on your Desktop
Step 5: Go to Avery.com and select "Design & Print Online" Then search for the Address Label that you need to print (example: 5160)
Step 6: Choose the design, like the one with the Christmas Tree theme, then click “Select and Customize”
Step 7: On the "Design & Print" Page, you will need to select the text & click "Start Mail Merge." You can then “Browse for File” and upload your excel or csv file & then map the fields correctly for the label
Step 8: Click “Complete Merge”. Once this is complete, you can select "Preview & Print" to view a printable PDF of your labels and print them directly from here


If you have any questions regarding Address Labels, check out our Address Label Video.



You can contact our team of Heroes at 704.234.6006, or send us an email at heroes@UnitWise.com


No comments:

Post a Comment

*UnitWise is not affiliated with Mary Kay.

Copyright © 2016 SPAN Enterprises LLC. All rights reserved. Terms of Use | Privacy Policy