Opinions - Invitation Address Font
more by mizrunzou
Which accessory set?
needed... mad skills in photoshop!!!!
more in Technology
Blogs
Do you remember this post?
more in Boards
PSA: Aldo Shoes 50%

Mail Merge Help

posted 2 years ago in Technology
  • 1 Members Subscribed To Topic
  •  
    1.
    Member
    578 posts
    Busy bee
    mizrunzou    June 26, 2010   Kansas City, MO

    Hi Bees!

    I've searched the archives, but thought one of you might be able to direct me to a tutorial or walk me through faster than I could find a tutorial.

    FI and I are going to print our addresses directly on our envelopes and we have no idea how to mail merge.  Can anyone help? 

    Thanks Hive!

     
    2.
    Member Icon
    Member
    52 posts
    Worker bee
    Jamieawh    07/03/2009   San Francisco, CA

    I assume your names and addresses are in excel? Are you using office 2003 or 2007 (or some other version)? I think that this gives a pretty good overview for 2007: http://helpdesk.ua.edu/training/word/merg07.html

     

     
    3.
    Member
    578 posts
    Busy bee
    mizrunzou    June 26, 2010   Kansas City, MO

    I'm using an older version, FI has 2007.  Currently my addresses are in a excel csv file (so I can load them into the RSVP tool in weddingwire).

     
    4.
    Member Icon
    Member
    52 posts
    Worker bee
    Jamieawh    07/03/2009   San Francisco, CA

    If you go to Tools --> Letters and Mailings --> Mail Merge a little wizard will come up. In the first step, you'll select "envelopes." In the second step, you'll select your recipients from an existing list (then search for your excel file). When you select your excel file, make sure that you identify the contents of each column (name, address, etc.). You will then add an "address block" to the first record and copy the formatting of that to all of the other records.

     

    It is probably easiest if you just give it a go and let us know if you have questions!

     

    Microsoft has a fairly comprehensive set of instructions: http://office.microsoft.com/en-us/help/ha010349201033.aspx

     

     
    5.
    Member
    578 posts
    Busy bee
    mizrunzou    June 26, 2010   Kansas City, MO

    Thanks!  That is what I will do!

     

    Reply

    You must log in to post.





    Visit our sister sites eHarmony
    Online Dating
    eHarmony Advice
    Dating Advice
    Project Wedding
    Wedding Songs
    JustMommies
    Pregnancy Calendar
    Copyright 2004-2012, Weddingbee.com
     

    Find your vendors on Weddingbee

    Real reviews from brides in your area!

    Favors by Weddingbee

    • Favors by season

    Shop Now ยป

    Find Registry Find Registry Find Registry

    More
    User Posts Today
    Rojocameo 16
    Rivendeler 15
    Suikerbossie 9
    Future Mrs K 8
    ellisrobertson 8
    lionskitty 7
    keranos 7
    fivemonthsnotice 7
    janetsnakehole 6
    shychigirl 6

    Technology


    Sorry, there are no users yet.


    More