Need Help Printing Labels in MS Word from TXT File

[txdave35]

Hi guys,

I exported some address data from a database into a fixed width text file. My goal is to import this data into a Word document template for address labels.

I imported the data into Excel and saved it. Then I went through the wizard on Mail Merge for labels. I get to the point where it asks for the REceipts, and I select my Excel file.

The weird thing is that the next screen shows:

Sheet1$
Sheet1$label
Sheet2$
Sheet3$

I only have one spreadsheet with a single worksheet. I tried picking the various sheets, and it does display my mail merge recipients in the wizard screen. However, when I click ok, my work doc only displays <<Next Record>> for each address label.

I can't get Word to display the address data. Anyone have any idea what I'm doing wrong? I am using Word 2003.

 

[SkipVought]

Hi,

"I only have one spreadsheet with a single worksheet."

You have THREE sheets. Sheet1 has your data. The other two are probably empty.

Sheet1$lable is the table containing the data. Select it.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[txdave35]

Thanks Skip. I figured it out. I was skipping past the "arrange labels" portion in the wizard. I went into this option, then match fields and apparently, this action created the link to my spreadsheet.

Now, the addresses are showing up on each label, but each line is like double spaced instead of single space. I can't figure out how to single space the lines. If I manually change one label, it will not apply for the other ones. Any suggestions?

 

[SkipVought]

You can do an Edit > Replace
[tt]
Find what: ^p^p
Replace with: ^p
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

==>If I manually change one label, it will not apply for the other ones. Any suggestions?

Depends upon what you mean.

If it is truly double-spaced, you can change the line options. Select all you want to change, and then go to Tools-Options, and set the line spacing options appropriately...

If it is an extra space or two or whatever at the end, you might be able to use Find-Replace to clear those out. To do so, put a space in the "find what" box, and just leave the "replace" box empty. Then, if you are sure you don't need any spaces, hit "replace all". If you need some, but not others, and it's not a super lengthy piece of data, you can manually go through the results one at a time to be sure.

If it's line breaks, then you'll need to remove the line breaks. I'd think that could be done with find and replace as well, but I am not sure of what symbol/character you need to symbolize line breaks for that option - I'm thinking something like Chr(13) or [CR], but I doubt those will work in that context..

--

"If to err is human, then I must be some kind of human!" -Me

 

[txdave35]

Yes, every line is double spaced in the address. Where do I go under Tools- Options? I looked under each tab, but I don't see anything for line spacing. I tried clicking the line spacing button on the tool, but it only lets me go to 1.0 which is still too wide.

 

[SkipVought]

Hellooooooo.

Did you try replacing two paragraphs (^p^p) with one paragraph (^p)?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Yeah, now that I see it, ^p looks like the correct paragraph symbol that Word will recognize. I would have noticed Skip already answered that if I had double-checked before I posted.

--

"If to err is human, then I must be some kind of human!" -Me

 

[fumei]

Hellooooooo."


Don't know why, but in my (warped) mind, I immediately flashed to Billy Crystal saying that in City Slickers.

You crack me up.

Gerry

 

[SkipVought]

I'm not quitting my day job, tho. ;-)

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}