Volleynerd Knowledge Base

Sunday, December 12, 2010

Christmas Card Mail Merge to Labels - HowTo


Since I only do this once a year, I always forget the couple sneaky steps I have to do to pull this off.
  • Outlook Contacts, select "Christmas Cards" view
  • Tools, Mail Merge. Select New document, and Labels (at the bottom) of the dialog
  • (Now over in Word, get the layout of the labels, but no data yet)
  • Cursor in first label (top left corner), choose "Address Block" in Mailings ribbon tab. (this puts the field in the first label, and fields in all the rest.
  • Click "Update Labels" in the Mailings ribbon tab. (this adds the in all the rest of the fields)
  • Click "Preview Results" in the Mailings ribbon tab to see the data.
  • Review each label to make sure the names look good (some might have first & last name reversed)
  • When layout and addresses on that first page look good, click "Finish & Merge" in the Mailings tab. This creates the final document with the labels spanning multiple pages in the doc that you will print. You can still make more changes in these addresses before printing (but those changes obviously won't make it back to the source address info in Outlook)





Comments: Post a Comment

Home