Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word labels to colums/Excel (2000)

    <font color=4682b4>I have several documents containing Word labels. A whole address is contained in each cell of a 3 column table. Is there a simple way to convert this to a data source-type format--A table in Word or Excel that would have columns First Name, Last Name, Address, City, etc.? I guess this would be basically be running a mail merge backwards somehow...</font color=4682b4>

  2. #2
    BAM
    Guest

    Re: Word labels to colums/Excel (2000)

    Hi Angela,

    This can be done, but it involves several steps. (Although easier than retyping everything! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> )

    This article from the MS Word FAQ provides the necessary steps for this:
    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MailMerge/ConvertAdrsToDatafile.htm> How to convert addresses into a Mail Merge Data Source</A>
    ~~~~~~~~~~~~
    Cheers! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word labels to colums/Excel (2000)

    Thank you! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>. I tried doing it with Excel (after the table->text conversion in Word). It worked but I had to go through and assign field names to each row and then do auto-filters to pull out each column. Definitely clunky!

Posting Permissions

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