View Single Post
  #8   Report Post  
handeiere handeiere is offline
Junior Member
 
Posts: 10
Default

[quote=chipp2shore;491851]
Quote:
Originally Posted by Peter A View Post
In article bc8dded1-00fa-4edb-8e4d-c508d0ce0e32
@y77g2000hsy.googlegroups.com, says...[color=blue][i]
On 1 Mar, 13:52, Peter A wrote:[color=green][i]
In article 2b20f7b4-2839-4dd4-80fc-d78602aa81c8
@q78g2000hsh.googlegroups.com, says...



I have a Word document with a table set up (to print mailing labels,
in 2 columns). And a plain text document with addresses. I'd like to
insert the addresses into the Word table, _without_ using Mail
Merge.

...
Can I manipulate the text file in such a way that I can paste the text
into the Word doc.with each address on a different label?



If I understand your problem correctly, you need to convert the new addresses into a table which can then be added to the existing table?


There are several options to meld them... the first (text to table) has already been suggested by Suzanne.

To place an address list into a table you can use text to table by first repacing all the para. marks with line breaks. Then replacing 2 line breaks with a para mark, so that you have a para mark as a delimiter between records. Select the text and click 'convert text to table'

If however you have many more raw addresses than the ones in a table, there is another option:
Convert the addresses in your table to text, then add them to the addresses not in your table. This will give you a long vertical row of addresses.

If you follow the directions on this MS support website you will see how to make labels from a vertical list of addresses:

http://support.microsoft.com/kb/212335
making sure you name and save the file after step 5.

Hopefully you will find a label to match the one's you are using.

Another option: To make a table from your asterisk delimited file in WORD 2007 & 2010 (this will also work smoothly with the Avery label software for Word):

1) Open Word
2) Start with a blank page.
3) Make sure the ‘Insert Database’ button is on your Quick Access Toolbar - Q.A.T. (If not click on down arrow on the Q.A.T. / Go to Customize / More commands / Change from ‘Popular Commands’ to ‘All Commands’ / then select ‘insert database’ and add to Q.A.T.)
4) Once on the QAT, Click on this ‘Insert database’ button
5) Select your labels document and open
6) Field ‘NONE , Record ‘*’
7) Insert data / OK, ALL
8) Click on ‘Table Tools’ button and select white table model on left
9) Your addresses are now in a table ready for the Avery Label software


In WORD 97 and 2000 to put your labels into a table, first open the Database Toolbar (which needs to be selected from View / Toolbars). Then open a blank document, click on the icon, ‘Insert Database’ from the Database toolbar/ Click Get Data / find your document set up delimited by tabs and click OPEN / select the delimiters: Field None / Records *
Insert data /then click OK
Your labels are now in a table. Re-name and save.

So here you have three options.

1) Use 'Convert Text to Table' with the raw addresses and meld the new table to the existing one.

2) Set up a delimited document from which you can select the labels of your choice.

3) Create a new table from the document which has been saved in an asterisk delimited format.

I hope this helps. I've tried to cover all the bases in case others have a similar problem! Chris
="" a=""There are several options to meld them... the first (text to table) has already been suggested by Suzanne.

Last edited by handeiere : April 11th 12 at 10:52 AM