Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

creating mailing labels

Discussion in 'Information Technology' started by JON, mcse, mcdba, Nov 13, 2005.

  1. JON, mcse, mcdba

    JON, mcse, mcdba
    Expand Collapse
    Guest

    I have a client who has a list of about 7000 real estate properties. The
    data is currently in Excel format with multiple columns: STREET ADDRESS,
    NAME, MAILING ADDRESS, STATE, ZIP. The STREET ADDRESS pertains to the
    physical location of the property, while the NAME, MAILING ADDRESS, STATE,
    ZIP would be the information on a mailing label.

    I need to be able to create and print mailing labels with the NAME, MAILING
    ADDRESS, STATE and ZIP... BUT... to be searchable and listed by the STREET
    ADDRESS. So in the event they need to print a particular label they can query
    by STREET ADDRESS, and print out the label neccassary for that property.

    I went through the mail merge in Word, but that just creates the labels, NOT
    organize the data by STREET ADDRESS. I was hoping that Access would give me
    this function.

    Thanks for any help you can provide!
     
  2. Loading...

    Similar Threads Forum Date
    Canada Ottawa weighs creating ambassador for religious freedom Breaking News Oct 4, 2011
    India SGPC Accused of Creating a Row Breaking News Jan 20, 2011
    Pacific International Gathering of Young Sikhs Focuses on Creating Good Citizens Breaking News Jan 8, 2011
    Are We Creating New Devtas? Sikh Sikhi Sikhism Aug 21, 2009
    Sikh News Sharif warns against creating instability in Punjab (Express India) Breaking News Sep 19, 2008

  3. ldiaz

    ldiaz
    Expand Collapse
    Guest

    It's easy to make this in Word, to order by Street Address you need to open
    the Excel and sort them by Street Address,
    otherwise you'll have to make a Table,Form,Query and the report with the
    info that it need to have.
    in the query you can order as you want.

    ldiaz

    "JON, mcse, mcdba" wrote:

    > I have a client who has a list of about 7000 real estate properties. The
    > data is currently in Excel format with multiple columns: STREET ADDRESS,
    > NAME, MAILING ADDRESS, STATE, ZIP. The STREET ADDRESS pertains to the
    > physical location of the property, while the NAME, MAILING ADDRESS, STATE,
    > ZIP would be the information on a mailing label.
    >
    > I need to be able to create and print mailing labels with the NAME, MAILING
    > ADDRESS, STATE and ZIP... BUT... to be searchable and listed by the STREET
    > ADDRESS. So in the event they need to print a particular label they can query
    > by STREET ADDRESS, and print out the label neccassary for that property.
    >
    > I went through the mail merge in Word, but that just creates the labels, NOT
    > organize the data by STREET ADDRESS. I was hoping that Access would give me
    > this function.
    >
    > Thanks for any help you can provide!
    >
    >
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    In Access, you would create these tables:

    AddressType table:
    AddressTypeID Text primary key
    This table would contain just a couple of records, e.g. "Street", "Postal".

    Client table (one record per person):
    ClientID AutoNumber primary key
    ClientName Text
    ...

    Address table
    AddressID AutoNumber primary key
    ClientID Number (Long) Which client has this address.
    AddressTypeID Text Relates to AddressType.AddressTypeID.
    AddressLine1
    AddressLine2
    City
    ...

    After creating the tables, use the Relationships window (Tools menu) to
    create relationships between the tables:
    - One client can have many entries in the Address table;
    - One AddressType can appear many times in the Address table.

    Now you can search by any address (the addresses are all in the one table)
    and find out which client this is (because it links back to the client
    table), but still set up your print out so it uses the Postal address if the
    client has one.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.
    "JON, mcse, mcdba" <JON, mcse, mcdba@discussions.microsoft.com> wrote in
    message news:F051EC91-6EAB-46E9-8A28-301A0B40402C@microsoft.com...
    >I have a client who has a list of about 7000 real estate properties. The
    > data is currently in Excel format with multiple columns: STREET ADDRESS,
    > NAME, MAILING ADDRESS, STATE, ZIP. The STREET ADDRESS pertains to the
    > physical location of the property, while the NAME, MAILING ADDRESS, STATE,
    > ZIP would be the information on a mailing label.
    >
    > I need to be able to create and print mailing labels with the NAME,
    > MAILING
    > ADDRESS, STATE and ZIP... BUT... to be searchable and listed by the
    > STREET
    > ADDRESS. So in the event they need to print a particular label they can
    > query
    > by STREET ADDRESS, and print out the label neccassary for that property.
    >
    > I went through the mail merge in Word, but that just creates the labels,
    > NOT
    > organize the data by STREET ADDRESS. I was hoping that Access would give
    > me
    > this function.
    >
    > Thanks for any help you can provide!
     

Share This Page