I have the following text file.

[shukui]

I have the following text file.

David Smith
1 New York St West
Toronto, ON N1T 2W3

Micheal Jones
34 Wellington Street
New York, NY 37377

...


Any one know how I can convert it to a MS Word 2000 file (using AveryWizard actually) so I can print out all the addresses onto a sheet of adhensive stickers. Any idea how? Please help!

Thanks,

Shukui Guan

 

[Dreamboat]

Shukui: Are they ALL 3 lines? If so, it's not too tough to do. Let me know.

http://www.PiersonTech.com

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

 

[shukui]

Yes, they are all three lines. Please tell how.

 

[Dreamboat]

Turn your show/hide button on so you can see the paragraph returns. It looks like a backwards P on your upper toolbar.

If your data is exactly as you've stated, and there is ONE paragraph return (backwards P) at the end of each line and one between each address, then take the following steps EXACTLY.

1. Delete any paragraph marks at the top of the document so that the first character is the first letter of the first person's name. Delete any paragraph marks at the bottom of the document, except for the one behind the very last character of the very last record.

2. Hit Ctrl-h. In the FIND WHAT box, type: ^p^p In the REPLACE WITH box, type: parareturn and hit Replace All.

3. In the FIND WHAT box, type: ^p In the REPLACE WITH box, type: ^t and hit Replace All.

4. Select your entire data by hitting Ctrl-a. From the menu, hit Table-Convert text to Table. Tell it you want 3 columns and you're using a TAB as a delimiter.

5. Click inside the first cell of the table at the top left and drag to the right to select all three cells. Hit Table-Insert Row. Type in column headings: Name, Address, CitySTZip.

The Steps above should give you a data source. Save it. Call it MLdata.doc. Keep it saved that way. Close it.

Now merge to labels:

1. New, blank document.

2. From the menu, Tools-Mail merge. On Step 1, hit Create, choose mailing labels, choose Active Window.

3. On Step 2, hit Get Data, choose your MLdata.doc file, hit Open. You'll get a prompt.

4. At the prompt, hit Set up Main document. Choose your label type, hit OK.

5. Hit Insert Merge Field button on toolbar. Choose Name. Hit Return. Hit button again, choose Address, hit return, hit it again, choose CitySTZip. Hit Ok.

6. If you think you'll be doing this again sometime with the same files, close the mailmerge helper and save the file, then hit Tools-Mailmerge again. If not, continue to step 7 (here).

7. Hit Step 3, Merge, choose new document, hit Merge again. Print your labels.

The new document with the labels can be closed without saving. The "coded" file can also be closed without saving.

Good luck!

http://www.PiersonTech.com

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

 

[shukui]

Thank you DB,

It works very well. Just two more little questions.

(1) Do you think I can make the whole process simpler?
(2) Why is there always a empty line after each label?

I am actually working on a ColdFusion project to faciliate the administrator to select a few names from a webpage/database, then press a button. The system can write a table file in the same format as the MLdate.doc you indicated above. However, do you think I can get a script or a macro to make the mail merge process automatic? I know nothing about VB, by the way. Maybe you or someone out there could help me.

Ta,
Shukui

 

[Dreamboat]

Extra line:

After creating the label file, you can hit Find/Replace again and then put in ^p^p and replace with ^p. That should get rid of the line. I don't know why Word does this. I often change the font, etc., AFTER I've created the file. Just hit ctrl-a first if you're changing any of the formatting.

Make process simpler:

If you're doing this on a regular basis, record a macro that does it for you. If you need to know the steps to record a macro, email me, and ask for my "record macro Word doc". I'll email by reply.

http://www.PiersonTech.com

techsupportgirl@home.com
Brainbench MVP for Microsoft Word