Creating labels from a text file

I hope there's a simple solution to this task.  OS is Win 7.  I have Office Pro 2010.  I also have Avery Address Labels #5160.  I have a text file with many lines in it.  I'd like to place one line of text from the text file on a single label.  Each line is used exactly once.  Example:  text file contains:

1) This is line one

2) This is the line after one

3) This is the third line

4) Goes on and on...

So I'd like my label sheet to look something like:

|--------------------|--------------------|--------------------|

| 1) This is line    | 2) This is the     | 3) This is the     |

| one                | line after one     | third line         |

|                    |                    |                    |

|--------------------|--------------------|--------------------|

| 4) Goes on and     |                    |                    |

| on...              |                    |                    |

|                    |                    |                    |

|--------------------|--------------------|--------------------|

|                    |                    |                    |

|                    |                    |                    |

|                    |                    |                    |

|--------------------|--------------------|--------------------|

...

Is there an easier way to do this without copy/pasting each line onto each label?  Solution should be able to handle several hundred lines in the text file/multiple label pages.

Thanks,

Jeff

Answer
Answer

Thanks for all the responses everyone.  Figured out what my problem was...I added a line at the beginning of the text file with a field name, then the merge was successful and got the labels I wanted.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 14, 2024 Views 1,134 Applies to: