Sorting so Blank Contacts are at bottom

[Stilla]

Hello, I just imported my contact email list from an excel file. In Outlook,
the list appeared at the bottom of the contacts "space" so that there are a
zillion blank lines before my "A"s even start... I can't seem to "delete" the
blank lines.. Is there any way to sort so that my contacts appear followed
by black spaces?

 

[PC Datasheet]

When you want to display your contacts in a form or report, use a query
based on your contact list table and in the contact field set the criteria
to Not Is Null and sort ascending.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

 

[MacDermott]

Are you working in MS Access, or in Outlook?
If you're in Outlook, you might do better posting in an Outlook group.

 

[Stilla]

Oh Dear! made a mistake.. that's where I thought I posted it! Thanks!