Anders is busy prepping for the big Portland Bridal Show this weekend. We will be showcasing our newest save the dates and invitations. Here is a sneak peek at what is to come! Be sure to stop by our booth and check out our latest designs.
Details about the bridal show:
The Oregon Convention Center | January 12th & 13th | $9 admission
For $1 off off an advance ticket go here: http://tinyurl.com/bx2cq6q
Pre-register online and receive valuable gifts!
Creating a data merge file can be confusing! We get a lot of questions regarding addressing etiquette and setup in Excel so here is a helpful 3 step guide to a perfect data merge!
Before you get started…
We recommend using our handy template. You can find the template attached to this blog post or your designer would be happy to email it to you.
We know that you probably have several spreadsheets already created for your wedding but please create a brand new spreadsheet specifically to send to Anders to avoid confusion.
Please exclude any unnecessary information from your spreadsheet such as seating assignments, notes, gifts, catering selections etc…
Please avoid using all caps and fancy formatting such as fonts and colors.
Label your spreadsheet with the bride’s last name. If you have to send us a revised file, please number it. Example: Peterson_datamerge.xls, Peterson_datamerge2.xls
Fill out each column below its respective header in Row 1 (NAME, GUEST, ADDRESS etc….) Do not delete the headers.
Each column will appear on a separate line when printed.
The NAME column:
This column should be reserved for the person or couple you are inviting only.
If the person is single: “Ms. Megan Parker”
If the couple is married: “Mr. and Mrs. James Blackwood”
If the couple is not married, but lives together: “Mr. Adrian Woods and Ms. Alison Golden”
The GUEST column:
Traditionally, guests and other family members should be listed on a separate line by using their name(s). If you don’t know their name(s) use “and guest” or “and family”.
The ADDRESS and ADDRESS2 column:
Street addresses go in the ADDRESS column. Apartment or suite numbers go in ADDRESS2. If there is no apartment, flat, or suite number, please leave ADDRESS2 blank.
The CITY, STATE ZIP Column:
City, state and zip code should stay in one column. Please do not separate them into separate columns.
The COUNTRY column:
Only use the COUNTRY column for guests who live outside of the United States. Otherwise, please leave this column blank.
Send your spreadsheet to your designer in .xls format by attaching it to an email. Before you send your file, double check spelling and make sure you have labeled your spreadsheet with the bride’s last name to avoid additional charges.
VOILA! You’re done! Your designer will email you back with a proof of the data merge exactly how it will appear when printed. If you find any mistakes in this proof, please supply your designer with a corrected Excel document. Your designer is unable to edit the information in your spreadsheet.
[Download] Mail Merge Template