Showing results for 
Search instead for 
Do you mean 

Sending Email

New Member
Posts: 3
Country: United States

Sending Email

I have 6.0 and I am trying to send a mass email to my current Look Up but not all of them have email addresses listed. Act won't let me sort by email, is there a way that I can delete all the clients who do not have emails listed from my current Look Up?
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Sending Email

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. 


Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
Bronze Elite Contributor
Posts: 2,639
Country: New_Zealand

Re: Sending Email

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...'.

Graeme Leo
Xact Software - consultants and developers
Follow us on Twitter and check out our Blog

Platinum Elite Contributor
Posts: 14,854
Country: Australia

Re: Sending Email

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!