Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Gainesville, Florida, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bulk Mail Order (Word 2000)

    <img src=/S/please.gif border=0 alt=please width=31 height=23> It was suggested to me to post here as well as my original Excel posting. I hope I do not offend anyone by the double post.

    We are going to attempt to do a bulk mailing ourselves. I'd rather not have to sort the labels/envelopes by hand. We will be using a CSV file exported from an SQL database. I can sort by zip but thought there may be a vb script that will further sort by bulk mail rules. I'm trying to get the computer to do as much of the work as possible. Searches on Google have not resulted in a solution that I believe should exists. Can anyone here help me? I am open to other suggestions on this as well but would like to use the software I already have (ie SQL 7 and Excel/Word 2000).

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Bulk Mail Order (Word 2000)

    You may be able to do this manually without any macros/scripts. Word is not my field of expertize, but I found these two titles in W2000 Help:

    Use a tab- or comma-delimited text file as a data source

    Sort data records in a data source
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Winston-Salem, North Carolina, USA
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bulk Mail Order (Word 2000)

    (sigh) I started to respond, but it's been so long since I did this that I thought someone might have a more up to date answer. Back when I was doing bulk mailings (lots and lots of bulk mailings), my understanding was essentially that the more of the sorting you were able to do, the less the post office charged you to deliver the mail. If I remember right, the bulk rate was applied to every piece of mail you sent when you had so many pieces in the same zip code (200, maybe?) The three digit rate applied when you had so many pieces (again, maybe 200?) where there weren't enough of any one zip code to make the bulk mail rate, but the first three digits of the zip code matched. I believe another rate applied for the odds and ends that didn't make the three digit rate.

    Back in 1987 or 88, in Excel 2 maybe, the first macro I ever created was to determine what rates to apply to a 3000-piece bulk mailing. So, part of the answer is, yes, this can be done in Excel. I certainly wouldn't want to try it in Word. It's been a long, long time since I did that, but I believe the steps the macro took were to sort the list by zip code, then count how many were in each zip code to see if they made the bulk mail rate. I then sorted those that didn't qualify to see if there were any that made the three-digit rate. I then sorted the remainder by zip code just to be tidy. I'm sorry not to be more exact, but as I said, it's been a long time. I hope this helps in any small way.

    Lee Morgan

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

    Re: Bulk Mail Order (Word 2000)

    Hi Maeven:
    I started to respond, but the term SQL sent chills down my spine, since I have no experience with it. However, I can give you some general information about Word's Mail Merge features. While I don't know what your datasource looks like, doing bulk mailing in Word, including sorting, is easy.

    If you go to Tools/MailMerge... & dialog box will open up which gives you step by step instructions. There are 3 parts to a mail merge:
    1. Your form letter containing boilerplate, layout, & instructions to Word as to what fields you want, etc. Word calls this a Main document. You may wish a label or envelope instead
    2. Your datasource - which contains your fields & records.
    3. Your merged document, or result.

    There are 3 main steps that Word takes you through. You first choose your main document type & insert fields, boilerplate text, & choose the layout. You then select your datasource. Then you do the merge.

    When it comes to sorting, you have two choices. You can sort your datasource by zip code & then just merge without worrying about queries. Or, when you go to the 3rd step, you will see a button for Query Options... If you click that, you'll find a sort records tab. Here you will sort records by zip code.

    If you have any problems with this approach, please post back.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Bulk Mail Order (Word 2000)

    So I suggested you come over to the Word Forum and nobody has responded? No fair!

    [Edited to correct munged first link]

    Wendy, what is the difference between 3 digit ZIP sorting and bulk rate sorting? See http://pe.usps.gov/text/Pub49/pub49ch5.htm, which I found from http://www.usps.com/businessmail101/sortin...sortingMail.htm. Also http://www.usps.com/businessmail101/...d/bulkMail.htm may be of interest.

    Finally, attached is a list of three digit zips which I had created about two years ago, it may not be up-to-date.
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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