First let me say that after looking through to posts mine seems trivial but I'm going to ask your advice anyway. I have Office Professional 2013 and I use word a lot. I was just getting prepared to do a mass mailing so I wanted to print a bunch of labels. I created a data base using Excel with the name, address, and city zip. Save it and then opened Word, selected my label design, imported my list and set up my address block. Everything is going swimmingly but I'm getting a space in front of the first line of the address and no matter what I do, I can't get rid of it. I can adjust the first label but when I click on update it goes back to adding an extra space. I know it sounds piddling but it's really irritating me. I tried going back to my data to see if I inadvertently put a space in front of the name field, but that didn't seem to be the problem so I looked around in my word document to see if I was missing something there, but all that looked alright too. So what am I doing wrong, or is it just a glitch in either Word or Excel. Looking forward to hearing from all of you. Thanks.



Manny

What kind of a space? A space character? Paragraph-before space? Something else?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi and thanks for responding. It's a space and no matter what I do it will not go away.

Manny

If you're using Word's AddressBlock merge field, you might get better results by not using that and, instead, inserting the mergefields individually as & where you require them. If the space remains, it's in the data. There's nothing a mailmerge can do about that; you'll need to fix it at the source.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul and thanks loads for helping me out.

Manny