Inspire Others...
  • 9
  • 41
  •  
  •  
  •  
  •  
  •  
  •  
  •   
  •  
    50
    Shares

How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning. How to Mail Merge with Microsoft Word. Mail Merging Labels. Addressing Wedding Invitations. Wedding Guest list How to. Wedding Guest List Spreadsheet.If you have not been using the Microsoft Word, Mail Merge feature to print labels {for anything in life} you’re missing out! It’s time to add this life skill to your toolbox and more importantly, use it for your wedding planning! If you have not yet downloaded our FREE Guest List Excel Spreadsheet, you’ll want to do that now and start wrangling your addresses.

The Mail Merge concept can be applied to your wedding planning in so many forms, but the most beneficial is Invitation Addressing. You may think I’m referring to printing labels, which I am. But, as you may have caught in my Invitation 101 slideshow, Formal Invitations can’t have a sticky label on them. The Mail Merge still helps with that in a roundabout way and,  that rule doesn’t apply to your Save-the-Dates, Bridal Shower(s) and Thank You cards!

How to use Mail Merge for your Wedding Guest List

This post is written using examples and pictures from our very own Guest List Excel Spreadsheet, which you may download from this post. However, the same instructions can be applied to any Spreadsheet you’re using.

If you do not yet have Microsoft Word or Microsoft Excel you can download them both from the Microsoft Website.

Microsoft

The following series of screenshots is a guide to beginning your first Mail Merge. We begin at Step 1 which is opening a blank Word Document and then clicking the [Mailings] tab in the main, blue taskbar. This will open a new Menu where you can select, Start Mail Merge. Click that.

How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning

Step 2 | Creating your Labels

The next step, before you can begin your Mail Merge is selecting the size of your labels. As you continue on in your newly found Mail Merge excitement, you’ll learn that you can now print hundreds of new labels in all different sizes {Hooray!} But for this lesson, I’m going to encourage you to select the standard Avery Shipping Labels 8160 which are the perfect size for mailing your wedding stationaries.

How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning

Step 3 | Selecting Your Merge List

Now, this is where it can get a little tricky. {the first time anyway} To continue your Mail Merge you must select the LIST you are merging into the label format. Still in the [Mailings] menu, now click on the Select Recipients drop-down menu. Once that menu opens, click [Use an Existing List…] that list being your Wedding Guest List Excel Spreadsheet you’ve been working on. You may have renamed it by now, or you may have is saved in a special desktop folder. You’ll need to know the name and find it easily. If you’re using our Wedding Guest List Spreadsheet, it is formatted so that all of your Guests’ names and addresses are on Sheet 1, so select that sheet when asked to do so.

**You’ll want to know where you have saved your Wedding Guest List Excel Spreadsheet on your computer. How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning

Step 4 | Inserting Proper Merge Fields

This is officially the most tricky part. Merge Fields are the columns of your Spreadsheet on Sheet 1. They tell the Merge which information to insert, by column as you have it listed. I have written the remaining steps within the text of each screenshot to make it the least confusing as possible.

How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning How to Mail Merge your Wedding Guest List Spreadsheet and why you should. Green-Eyed Girl Productions. Wedding Planning

Why you should Mail Merge your Wedding Guest List

There are many reasons to Mail Merge your Wedding Guest List Spreadsheet. The first and most obvious is for shipping labels. Reminder- you cannot put printed shipping labels on your formal invitations. {I know, I know, etiquette police.} The address on the outer envelope of you Formal Invitations will be handwritten or printed {from the computer} directly onto the envelopes. This begs the question, why do the Mail Merge?

Keep Reading | Click below to read 3 Reasons to Mail Merge your Wedding Guest List…





Like what you read?

Hi there! I’m Kandice, Owner of Green-Eyed Girl Productions and engineer of The Project Block System. Thank you so much for stopping in on this blog post! For more Wedding Inspirations, How-To Articles, Vendor Advice and DIY Projects, join our Inspired Coordination Newsletter by subscribing below. You’ll get informational posts just like this in your inbox on Fridays.

Follow us on | Facebook | Instagram  | Twitter | Pinterest  | Etsy

This post is a part of The Project Block System, The only Step by Step Wedding Planning System you need to plan your own wedding. We’d love for you to enroll!
Happy Planning!

The I’m Engaged ECourse | Our famous FREE ECourse Are you new to our email list and recently engaged? Congratulations, and you’re in the right spot! If you haven’t already, go enroll in our FREE I’m Engaged ECourse on Teachable. You’ll receive a 7-Day Action Plan, free downloads and Introductory Wedding Planning Videos. Find it HERE.
The Project Block System | The GEG Trademark Our Project Block System on Teachable is our unique way of organizing wedding set up that has clients hunting us down worldwide. ENROLL HERE.
My Wedding is in 4 Weeks! | Our Top 10 Videos No time for the entire Project Block System ECourse? We’re sorry you found us too late to help you through your planning, BUT we can still help you make sure your day runs smoothly. Watch our Top 10 Videos on Wedding Day Set Up, Running a Rehearsal and more. Learn more HERE.
Thank You for being here!
Hi there! I’m Kandice. Thank you for being a part of our team! It is my mission in life to make your wedding a smooth and efficient experience! Learn all about being a Money Savvy Bride HERE. 

Don’t forget to snag some of our best FREEBIES too! From Free Wedding Websites and Registries to cold, hard cash! Read all about our Top 10 Freebies.


Cupshe Matching Sets! Starts at $6.99! Free Shipping! Shop Now!
**Affiliate Disclaimer** We are proud to partner with many amazing Affiliate Programs including Amazon, Cupshe, Toms Shoes and Many More. You will see our affiliate links sprinkled throughout every blog post. When you click on our affiliate links and make a purchase we earn a commission. However, all of our opinions, reviews, and recommendations of products and services are our own. We would never send you in the wrong direction 😉

Comments! 

I do love responding to comments and questions below. If you have something to add please let me know and I’ll be sure to respond ASAP. Better yet, JOIN OUR FACEBOOK GROUP!I’m much faster at responding over there! 
Facebook Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.