Mail Merge...Mailing Labels from Excel to Word

I swear I have forgotten how to do the Mail Merge for address labels, 30 per sheet, 1" x 2 5/8" from Excel to Word. When I go to Word I get the format of the label but no information in each label. It used to pull the information after I told Word which column for each line and now nothing.

What am I doing wrong?

Sherry

 

Did you specify the excel file as the database? If so you should be able to define the address fields. I don't have any excel files on this computer so I can't help you tonight but can help you tomorrow if nobody else chimes in.

 

I would deeply appreciate it. Thank you.

Sherry

 

Here's a 2 page PDF that you can print:
mailmerge.pdf


This one has a good list of "If that doesn't work" answers:
Excel Mail Merge

 

Here's a 2 page PDF that you can print:
mailmerge.pdf


This one has a good list of "If that doesn't work" answers:
Excel Mail Merge

Defining the header row in excel with bold type or shading, etc. helps word define your data columns

 

How the heck did that happen???? I went to add that last note and it created a new post??????????

 

I'm getting nothing yet but will try all of your links. I do know that in Word if one un-checks the "header row" it will not pick up the header. We did not put a header row because we wanted it to be simple. Right!!!!!!!!!!!

I used to do this within minutes but just haven't done it in while and cannot figure it out. My daughter is lost on this one......tee hee.......something technical I thought I knew more about than her.

Thanks,
Sherry

 

Ima,

What we've done is put all addresses in Excel, only one column is misc. Want to do a Mail Merge to print them off in Word and every time we do get the layout of the Address Layout for printing but nothing in the boxes. I used to be able to see the actual data in each box a while back when I did this.

We tried printing it off but get nothing when printing. Told my daughter this would be easier for sending mass items out and then thank you notes but she may have the last laugh on me. :lol: I hope to have it figured out before she gets home from school but need to look at Dan's links to see if they help.

Thanks so very much.

Sherry

 

Dan's links look pretty good. I can do a similar step-by-step if you want.

What version of Word are you using?

 

I use a program called Mail List for my lables. Easy.

 

It's actually 2007 Home Edition but I change the setting to 2003 for formatting even when I write a letter.

Sherry

 

Is that using Excel and Word? Getting ready to look at Dan's links. Hopefully I can figure it out from one of his as I just need a refreshing step by step.

Thanks,
Sherry

 

I get my list in Excel format and then import it ino the Mail List program, we bought it years and years ago, pick what style you are printing and PRINT. So easy.

 

Dan,

Thanks so very much as we are up and running. Thank you, you Commie, Pinko, scum sucking Socialist Liberal. :lol::lol::mrgreen::jester::mrgreen:

And a big thanks to Ima, as well for always helping......you "Right Wing Nutbag". :lol::lol::mrgreen::jester::mrgreen:

Who said we couldn't all work together?

On a serious note: Thanks bunches as we need to get this done and I must of had a brain fart.

Sherry

 

Thanks so much. Once my brain fart was gone, Dan and Ima got me going, I was on my way. I swear it has been a while since I used that function along with many Pivot Tables in Excel.

Hey when you come and clean out my house this weekend :lol: if my other neighbor is at home, who is a gun toting due, I'd like to take you over. They have a deer's head on the wall in the den. Scares the crap out of me plus I feel sorry for it but I think you'll like it and meeting them. Networking baby, networking. (wink, wink)

Sherry

 

Whoo Hoo!