Word Doc Columns converted to Merge Table

Among other assumptions, we assume you have Word 2007, and that you have a significant number of names so that cut and pasting would be impractical. The document could be formatted a couple of different ways. If a document has 2 columns, you can have actual columns, or things that look like columns, but are not really columns which I call pseudo columns. Pseudo columns are created like so:

Jack Frost [tab][tab][tab]Victor Frost
1 North Pole Way[tab][tab][tab]2 North Pole Way
North Pole, NJ 07601[tab][tab][tab]North Pole, NJ 07601

Bob Bright [tab][tab][tab]Maggie Moth
22 Ivan Ho Way[tab][tab][tab]393 Manlott Dr
Hackensack, NJ 07601[tab][tab][tab]San Juan, PR 00601

The [tab] represents a tab character. If you did it this way, it’s a bit messy but still workable. To fix it up you need to do a search and replace to convert all multiple tabs to single tabs so that your document will look like:

Jack Frost [tab]Victor Frost
1 North Pole Way[tab]2 North Pole Way
North Pole, NJ 07601[tab]North Pole, NJ 07601

Bob Bright[tab]Maggie Moth
22 Ivan Ho Way[tab]393 Manlott Dr
Hackensack, NJ 07601[tab]San Juan, PR 00601

Then select the whole document, and click on the “Insert” tab. Click on the “Table” icon and select “Convert Text to Table”. Make sure you have the “Paragraphs” radio button selected under the “Separate text at” section. Click OK, then you will have a table with two columns.
Next, you need to cut the second column, then paste it at the bottom of the first column. The result is that you will have two columns of data. Make sure you have a two blank cells as your last two cells in the first column. (Paste the cut column into the very last cell of the first column)
Ok, save the file as an Plain text. Make sure that you you have “MS-DOS” selected and “Insert line breaks” Selected, and “End lines with” “CR/LF” in the “File Conversion” popup window.
Ok, now open the text document in Word. You should have one column of names and addresses.
**actual column start point**
Now you have one column of names that you need to convert to a table. Do a search and replace. Replace all double paragraph marks (^p^p) with single manual page breaks (^m). Next, replace all single paragraph marks (^p) with tab (^t). Now replace all manual page breaks (^m) with manual line breaks (^l). You can now use the file as a merge file, or open the text file directly in Excel, save it as an Excel document and use it as the merge table.
Now I’ll hand it off to Microsoft for merging directions:
http://office.microsoft.com/en-us/help/h…
The process would be much the same if you had two true columns. But first you would make the document into 1 column, and just go to the spot I marked as **actual column start point**, and continue.
Ok, so it’s not so easy, but it is the easiest way to do it in my opinion.
If you need a template for the 5164, we’ve got a few to choose from at:
http://www.macolabels.com/ml-0600-templates.html
Our ML-0600 is comparable to the Avery 5164 shipping label.
You could also use the data for an ML-3000 label which is Avery 5160 laser label and inkjet label compatible.

Advertisements

Tags: , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: