Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word labels - mail merge (Word 2000)

    I have a member of staff who needs to send out our annual review to various people etc.

    The problem is the ONLY dat she has is the word labels used last year. She deleted the data source and only kept the word documents which are address labels . The whole name and address is now in a single cell, within a word table . Tried converting from tables to text but no help

    Is there any way I can get these back into a proper tabular format.

    I have tried copying and paste into excel, but that just splits the date into seperate rows. I tried converting to text and saving as csv but no joy there.

    Please help

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word labels - mail merge (Word 2000)

    Try this (I'd make a backup copy of the label document first):

    - Click in the table.
    - Press Alt+Num 5 (i.e. 5 on the numeric keypad) to select the entire table.
    - Press Ctrl+H to activate the Replace dialog.
    - Enter <code>^p</code> in the Find what box (this is the code for a paragraph mark).
    - Enter <code>@@@@</code> in the Replace with box (this is just a placeholder).
    - Click Replace All; don't continue searching the rest of the document.
    - Close the Replace dialog.
    - Select Table | Convert | Table to Text...
    - Specify Paragraph Marks as delimiter.
    - Click OK.
    - Make sure that the text of the converted table is still selected.
    - Press Ctrl+H again.
    - Enter <code>@@@@</code> in the Find what box.
    - Enter <code>^t</code> in the Replace with box (this is the code for a Tab character).
    - Click Replace All; don't continue searching the rest of the document.
    - Close the Replace dialog.
    - Make sure that the text is still selected.
    - Select Table | Convert | Text to Table...
    - Specify Tab as delimiter.
    - You should now the names and addresses in a tabular format.
    - Insert a new row at the top of the table.
    - Enter the appropriate column headings (field names) in the first row.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •