Post # 1
Member
4430 posts
Honey bee
Soooo I know the basics of mail merge….but i’m having a tough time getting my word 2007 to show my whole list of mailing addresses that I need printed from my Excel 2007!
I get a few steps in and after I select “from existing list” it shows everything I need, I click it…and nothing shows up! I see the list on the pop up, but not in my word document!
the old versions were so much easier! I used to do it all the time for my old job….and i’m currently an admin assistant! so I should know this!
HELP!
Sticking this in the hive until someone finds a place for it!
Post # 3
Member
410 posts
Helper bee
Are you using the “mail merge wizard” in Word? That’s what I use at work and I rarely have problems when doing labels.
Post # 4
Member
4430 posts
Honey bee
@stargazer102706: Yes!!!! I went step by step and everything was fine….but in the preview labels or preview anything NOTHING shows up on the screen! I can only see it when i can “edit recepients” but other than that nothing ends up showing up on the blank page!
Post # 5
Member
3580 posts
Sugar bee
There is a tab to the right that says match fields. Make sure that the entre sheet says the same merge codes and then hit finish and merge.
Post # 6
Member
3580 posts
Sugar bee
2007 is really confusing, by the way. I always get stuck at that step!! And the wizard never works for me, for some reason.
Post # 7
Member
410 posts
Helper bee
Did you click “update all labels” in step 4? Then in step 6 you should click “edit individual labels” & then click “all” in the pop-up box.It should then open all your labels in a new document. (At least that’s what it does with the version of Word I’m using, which is 2010. Not sure if 2007 is different.)
Post # 8
Member
455 posts
Helper bee
Oh, I have to do this for my work, too. I am not entirely sure where you are, but have you clicked the Address Block button? Unless you have designated where you want the information to go it won’t show up.
Post # 9
Member
8879 posts
Buzzing Beekeeper
I am so terrible at explaining this kind of stuff. It took me a while to get it with 2007 (cause 2007 is weird). My best advice is to look up a youtube tutorial, that’s what I did 🙂
Post # 10
Member
4430 posts
Honey bee
@WillyNilly: Ohhhh! Thank you…i’m getting somewhere now! Now the names and addresses show up, but are on seperate pages!
Post # 11
Member
3580 posts
Sugar bee
@BellaDee: Ahhh yes. There is a merge code that continues the merge, but you have to place it after the last merge code in the first cell. Frick. I think its continue it something…
ETA- I think it’s ‘next’ actually.
Post # 12
Member
4430 posts
Honey bee
Ok…i’m about to give up…I wanted these done by lunchtime so I could mail them…but this is ridiculous….there has to be an easier way!
🙁
Post # 13
Member
410 posts
Helper bee
Sorry I couldn’t be of more help. Maybe you can google “how to use mail merge in Word 2007” and see if you can find some info there. Good luck!
Post # 14
Member
4430 posts
Honey bee
Too late but thank you soooo much guys….I definitely just gave up … not because it was hard to explain but because I’m at work and frustrated walking back and forth “testing” the pages and printouts!
So I just decided to type out on Avery Label Templates all of the addresses, AGAIN.
I am halfway done printing them on waterproof labels. They look great! I used Vivaldi font in size 22 bold.
The Font Looks Like This
123 Maple Street
New York, NY 12345
Post # 16
Member
3580 posts
Sugar bee
Now that I figured it out at work it’s too late. Holler when you’re in a bind again, okay?