Post # 1
I need so serious HELP!!!
I am trying to be organized but no matter how I arrange the columns in excel I am unhappy. I’d like to address envelopes as:
Mr and Mrs. (mans name) (last name)
Guest (if not married) or Childrens names
City, State Zip
Since we will not be doing inner envelopes so I need all those invited on the outer ones. But Id like to keep track of the wifes names as well for seating cards. UGH!
Its such a mess. Anyone have a good organized spreadsheet that I can base mine off of. Also any suggestions for mail merging (so I dont have to copy and paste all these addresses into word for printing envelopes?)
Post # 3
You should have several different colums One should be Name in which you put Mr and Mrs first and last name and then the next should be additional in which has guest or childrens name and then separate columns for the address, city state and zip. I would suggest using the mail merge wizard. It’s confusing at first but it does help, at one point it will say something to the effect of arrange labels, then it takes you to a screen that you decide on what line you want the info in your columns to be organized. Play around with it, because it does take some time, it took me almost a whole day. Sorry I can’t explain it better but it’s hard when you can’t see what the person is looking at, hope this was slightly helpful
Post # 4
This post by a bee really helped me, it isn’t exact instructions but it helped a lot
Post # 5
PM your email adresses and I”ll see what I can do for you!