Creating Address List

Discussion in 'Mac Basics and Help' started by mac77bear, Aug 17, 2005.

  1. mac77bear macrumors newbie

    Joined:
    Jan 16, 2004
    Location:
    NYC
    #1
    Can someone help me out. I am trying to take a few address lists from the internet and some how copy and paste them from the web to make an address list or database that I can then reference for mailing lists or contacts. Any help you could give this beginner would be greatly appreciated.
     
  2. mkrishnan Moderator emeritus

    mkrishnan

    Joined:
    Jan 9, 2004
    Location:
    Grand Rapids, MI, USA
    #2
    Are you using Microsoft Office? Can you say more about the format in which the addresses appear in the existing internet document?

    What you can basically do is import the document into Excel, do some reformatting, so that it becomes a table with a structure of parts of the address (name, street line 1, street line 2, city, state, etc) in columns, and individual addresses in rows. If the addresses are in a neat, consistent format, you can usually do this without a lot of re-typing.

    Then, you can mail merge this document with Word so that fields in the Word doc read from fields in the Excel doc. But first, we need more info on what the address list you have now looks like.
     
  3. mac77bear thread starter macrumors newbie

    Joined:
    Jan 16, 2004
    Location:
    NYC
    #3
    Here are a few samples of the addresses. I can use office or an other program that would work. I understand the copy and paste part in Excel except can't figure out how to get the info to pasted horizontal so the colums will line up.

    '0Media Movers, Inc.
    1221 Avenue of the Americas,, 34th Floor
    New York, NY 10021
    Phone: (978) 359-6137
    Fax: (978) 359-6137
    www.dubbingstudio.com

    1womanshow
    854 W. 181st, 5J
    New York, NY 10033
    Phone: (212) 740-0929
    Fax: (212) 740-0929

    321 FILM
    9 Desbrosses St., 411
    NYC, NY 10013
    Phone: (212) 334-3456
    www.321film.com

    321 FILM
    9 Desbrosses St., 411
    NYC, NY 10013
    Phone: (212) 334-3456
    www.321film.com

    40 Acres & A Mule Filmworks, Inc.
    75 S. Elliot Place, 3rd Floor
    Brooklyn, NY 11217
    Phone: (718) 624-2974
    www.40acres.com
     

Share This Page