08-02-2009 11:35 PM
08-03-2009 08:15 AM
The E-mail "field" that you see in the layout is not a field in the main database table but rather a portal to the separate E-mail table. That is why E-mail is not available as a data type and why you can't sort by e-mail address or use E-mail in the duplicate checking. The E-mail table can hold more than one E-mail address for a user but only the default address can be used for addressing an e-mail message.
ACT! 7 and later handles email addresses different.
08-03-2009 12:06 PM
Lookup | E-mail Address | Select 'Empty Field'
Run the Lookup then use Edit Replace and choose a spare field, for instance 'User 6' to use as a flag for all records that do not have an email address.
To do so replace User 6 content in the Lookup with characters 'No Email' for instance. Run the Replace on thr Lookup.
Now you have flagged all the records that do not have an email address. You can use this field in the Contact List view to sort by. You may need to add the User 6 field into the Contact Lis, to do so right click on column header, 'Add Columns to View...'.
08-03-2009 02:25 PM
ACT! 6.0 will also fall over if any of the addresses have bad email data.
If you want to do this without worrying about those things, have a look at the trial of MergeMaster!