Distribution List - custom order

[teiben]

The boss wants his name to appear in all distribution lists first, from everything I've read the list is alpha either descending or ascenting....problem is his last name is Bob Looserr so it appears in the middle of the list.

 

[Minkey]

The boss wants his name to appear in all distribution lists first, from everything I've read the list is alpha either descending or ascenting....

He must have an over inflated ego , the reason for distribution list is so that everyone on it gets all the e-mail sent to the address so the only reason I can see for this is to massage his ego "oh look I'm first on the distribution list I must be more important than anyone else"

I know what I would say, a short reply of "sorry not possible I'm afraid"

You could do it by designing a custom form but then it wouldn't be a 'true' distribution list.

problem is his last name is Bob Looserr so it appears in the middle of the list.

LOL If that's his real name he is a truly a loser

 

[Ron_dK]

The boss wants his name to appear in all distribution lists first, from everything I've read the list is alpha either descending or ascenting....problem is his last name is Bob Looserr so it appears in the middle of the list.

You might consider putting a space () before his name.
This will put him first when ordered ascending.

 

[boblarson]

Or you can add a numeric (Integer) column to the table and set it to 1 for him and 2 for everyone else. Then sort in the query first by this column and then alphabetical by name. His name will come first and everyone else's will be in Alphabetical order.

 

[teiben]

Solution

Actually I figured it out; I have to create the distribution list in word, using the properties from outlook (spelling of the name, etc) then I have to paste it into outlook. What a crock huh?

 

[boblarson]

Actually I figured it out; I have to create the distribution list in word, using the properties from outlook (spelling of the name, etc) then I have to paste it into outlook. What a crock huh?

Actually that is the hard way. If you just used my original suggestion it works great. I don't know why you went through all of that trouble.

 

[teiben]

boblarson

I know it works w/access, since I've already had to do it, I was wondering how to do it w/Outlook only. Thanks