+ Reply to Thread
Results 1 to 3 of 3

Converting a Word File with addresses to Excel

Hybrid View

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Bangor
    MS-Off Ver
    2010
    Posts
    20

    Converting a Word File with addresses to Excel

    I used to use Wordperfect but no longer use it and saved a Wordperfect Data (.DAT) file to a Word Document which contains names and addresses.
    It has created one name/address per Word Page as attached.

    I want to do a MailMerge to print address labels. How can I convert this Word Document to an Excel one with each name/address on a separate row ?
    Attached Images Attached Images

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Converting a Word File with addresses to Excel

    the MM function in word pulls data from grids. that can be in excel or access. or other places I think, even. per your words, if you wanna throw the data from ur word doc into an excel file, ur gonna have to code it. or look up software to get into out of word, page by page, into a table of any kind, any extension. if you copy the data from word to notepad, it appears as you see in image 1 below. if you paste it into excel via the clipboard (same method), it shows as image 2 below. if you wanna do it that way, all you have to do to change it at that point if write a simple loop.
    Attached Images Attached Images

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,839

    Re: Converting a Word File with addresses to Excel

    Cross-posted at: https://www.msofficeforums.com/excel...xcel-file.html
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create new Word file then Copy table and contents from Excel to that Word file
    By sbv1986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2018, 09:14 AM
  2. Help converting file format from PowerPoint to Word, PDF
    By nkhondeya@gmail.com in forum PowerPoint Formatting & General
    Replies: 5
    Last Post: 03-25-2014, 10:55 PM
  3. Help converting file format from PowerPoint to Word, PDF
    By nkhondeya@gmail.com in forum Excel General
    Replies: 0
    Last Post: 10-10-2013, 11:50 AM
  4. Replies: 0
    Last Post: 04-02-2013, 07:04 AM
  5. Converting gif file to word.
    By radha143 in forum Word Formatting & General
    Replies: 1
    Last Post: 09-27-2012, 07:40 AM
  6. Microsoft Word and Excel addresses
    By zodiacs in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2011, 01:10 PM
  7. Replies: 3
    Last Post: 03-14-2006, 10:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1