D
Dos Equis
Hi All,
I am trying to create a query for a mailing list ordering labels by
zip code with certain parameters(USPS bulk mail). They are:
Grouped by zip code if more than 10 in the set.
Set to bundle between 10 and 15 per bundle. (If there are 18 in the
set, then 15 go into the bundle and 3 are sent to the next level of
sorting.)
Sets are (88001; 88005; 88007; 88011; 88012; 880; NM; and all others).
The first 5 are local zips, 880 is the next lower level of sort
followed by NM (New Mexico) and then all others are in a MXD category.
2 of the groups currently contain more than 15, but less than 20 labels
and need to have the remainder sent to 880 or NM.
5 digit sorting is assigned code D
3 digit sorting is assigned code 3
Albuquerque is assigned code 3 unless more than 15 then extras are sent
to 880 or NM
NM is assigned A
And all others are assigned MXD
My current breakdown is: Bundles
88001 - 46 11,11,12,12
88005 - 41 10,10,10,11
88007 - 18 15, (3 to 880)
88011 - 27 14,13
88012 - 12 12
880 - 21 12,12, (3 from 88007)
ABQ - 17 15, (2 to NM)
NM - 13 15, (2 from ABQ)
MXD - 65 10, 11, 11, 11, 11, 11
I currently use a spreadsheet with conditional formatting to organize
this every week and color codes tell me when there is a problem. In
addition, the spreadsheet calculates postage so I can't goof that
either. The calculation is all 5 digit zips + 880's summed and
multiplied by .15, all others summed and multiplied by .209. With 260
labels, I currently have 80 X .209 and 180 X .15 for a total of $16.72
and $27.00. I then fill in the blanks on the postal form and my
courier finishes once total weight is decided.
I have all the zips in a subscriber table so the data is available and
accurate when I create it, however, it changes weekly and sometimes
daily so I'd really like to automate the process.
I believe I've provided all the pertinent data but if you need
something else just ask.
Any help you can provide would be greatly appreciated.
Thank you,
Byron
I am trying to create a query for a mailing list ordering labels by
zip code with certain parameters(USPS bulk mail). They are:
Grouped by zip code if more than 10 in the set.
Set to bundle between 10 and 15 per bundle. (If there are 18 in the
set, then 15 go into the bundle and 3 are sent to the next level of
sorting.)
Sets are (88001; 88005; 88007; 88011; 88012; 880; NM; and all others).
The first 5 are local zips, 880 is the next lower level of sort
followed by NM (New Mexico) and then all others are in a MXD category.
2 of the groups currently contain more than 15, but less than 20 labels
and need to have the remainder sent to 880 or NM.
5 digit sorting is assigned code D
3 digit sorting is assigned code 3
Albuquerque is assigned code 3 unless more than 15 then extras are sent
to 880 or NM
NM is assigned A
And all others are assigned MXD
My current breakdown is: Bundles
88001 - 46 11,11,12,12
88005 - 41 10,10,10,11
88007 - 18 15, (3 to 880)
88011 - 27 14,13
88012 - 12 12
880 - 21 12,12, (3 from 88007)
ABQ - 17 15, (2 to NM)
NM - 13 15, (2 from ABQ)
MXD - 65 10, 11, 11, 11, 11, 11
I currently use a spreadsheet with conditional formatting to organize
this every week and color codes tell me when there is a problem. In
addition, the spreadsheet calculates postage so I can't goof that
either. The calculation is all 5 digit zips + 880's summed and
multiplied by .15, all others summed and multiplied by .209. With 260
labels, I currently have 80 X .209 and 180 X .15 for a total of $16.72
and $27.00. I then fill in the blanks on the postal form and my
courier finishes once total weight is decided.
I have all the zips in a subscriber table so the data is available and
accurate when I create it, however, it changes weekly and sometimes
daily so I'd really like to automate the process.
I believe I've provided all the pertinent data but if you need
something else just ask.
Any help you can provide would be greatly appreciated.
Thank you,
Byron