Results 1 to 6 of 6
  1. #1
    Bette B
    Guest

    Converting a list to merge data source

    Often, a mailing list is typed in with name, street address and city using an Enter between each line and then 2 Enters before the next entry. I want to be able to convert the list into field names such as first name, last name, address 1, etc. so that I can use it in a merge or import to Access. Is there a macro or some code that will convert such "mailing lists" into a csv file or a merge date source? Thanks for any help or suggestions.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Converting a list to merge data source

    Try converting the data to a table. Select the text and choose Table > Convert Text to Table

    Play around with the options for cell separators and number of columns. If the data is consistent in its pattern then this is by far the easiest way to go.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting a list to merge data source

    Hi Bette:

    Try this.

    1. Select your mailing list.
    2. Press Ctrl+H (to bring up Find/Repalce
    3. press more
    4. Don't tick wildcards
    5. Find ^p^p
    6. Replace: %$% (assuming that doesn't exist in your doc)
    7. Replace All
    8. Find: ^p
    9. Replace: ^t
    10. Replace all
    11. Find: <spacebar>
    12. Replace ^t
    13. Find: %$%
    14. Replace: ^p
    15. Table/Convert to text

    You should now get a table with 1 column for each field. If you do this often, record it as a macro. Note: this will separate your address into components so you might want to keep them together with no tabs between them. There may be a more elegant way of doing this & if I come up with it, I'll let you know.

  4. #4
    Bette B
    Guest

    Re: Converting a list to merge data source

    Thanks for the suggestion - I will give it a try. I did some find and replace and did make a macro for it. I was trying to figure out how to repeat the macro via code because there are at least 200 names in the list.

  5. #5
    Bette B
    Guest

    Re: Converting a list to merge data source

    Phil:

    Thanks again. I should have tried it before I replied. I didn't need code to have it repeat as you had me select the entire list and replace all. It's very close to what I want and again I appreciate your time in replying.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting a list to merge data source

    Hi Bette:

    Your welcome. If you find a thorough solution, why don't you post it. It will come in handy for others, I'm sure.

Posting Permissions

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