Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Envelopes (2000)

    A co-worker has a multi-page Word document (I've attached a small sample) which has all the school districts and addresses she must request student records from. On any given day, she may have to mail anywhere from 1 to 25 requests to 25 different school districts.

    Can she use her existing list to "pick and choose" which addresses she needs envelopes for for a particular mailing without either importing this list into Outlook, for example?
    Attached Files Attached Files

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

    Re: Envelopes (2000)

    The list is not the way to do this. What she needs is a table with column headings for each type of information & 1 row per school. Then she can use a mailmerge by printing form letters & either envelopes or labels. The table needs to be in a format like:

    <table border=1><td>SchoolName</td><td>Address</td><td>City</td><td>State</td><td>Zip</td><td>Attention</td></table>

    However, this list can be converted to a table without too much work using Find/Replace. Before doing so, go through the list and make sure that all addresses are 1 line addresses, all school names are on 1 line. i.e. the format for each school must be the same.

    1. Select everything (Ctrl+A)

    2. Press Ctrl+H to bring up the replace box. Make sure "use wildcards" is unticked.

    3. Make sure "no formatting" is selected for Find or Replace.

    4. Find: ^p^p
    Replace: %%%
    & press Replace All

    5. Find: ^p
    Replace: ^t
    & press Replace All

    6. Find: %%%
    Replace: ^p
    & press Replace All

    You will then be able to go to Table/Convert table to text..., select the tab as the delimiter (IMPORTANT), & convert the paragraphs to a table. You can then use this table as a datasource in a mailmerge.

    If you need any further clarification, post back.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Envelopes (2000)

    Sorry for the delay in thanking you. Your instructions were perfect and she is eternally grateful for the help - she has over 2000 addresses in this list and this will save her tons of time.

    Again, thanks from both of us and have a great day.

    Aunt Linda

Posting Permissions

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