Subaru Enthusiasts Car Club of the Sierras - View Single Post

sperry · 2010-12-02, 06:12 PM

I'm not helpful or awesome:

Access sucks.

Okay, I might be a little helpful and/or awesome:

Uniquely sort the output by address. That way if two people have the same address, you only mail to that address once. Concatenate the To field with all names of people matching that address like this:

John Doe
Jane Doe
1234 Address St.
Reno, NV 12345

Or if you really want to get fancy, check the last name fields and cat only the 1st names to get your solution to situation 1. But really, you'd probably be just fine to have multiple lines for all the names at the one address even if the last names match.

2010-12-02, 06:12 PM	#2
sperry The Doink Real Name: Scott Join Date: Nov 2002 Location: Portland, OR Posts: 20,335 Car: '09 OBXT, '02 WRX, '96 Miata Class: PDX/TT-6 The way out is through	I'm not helpful or awesome: Access sucks. Okay, I might be a little helpful and/or awesome: Uniquely sort the output by address. That way if two people have the same address, you only mail to that address once. Concatenate the To field with all names of people matching that address like this: John Doe Jane Doe 1234 Address St. Reno, NV 12345 Or if you really want to get fancy, check the last name fields and cat only the 1st names to get your solution to situation 1. But really, you'd probably be just fine to have multiple lines for all the names at the one address even if the last names match. __________________ Is you is, or is you ain't, my con-stit-u-ints?