I have sussed how to get a list from search facilities, and I have used my own fields fine. How do I say "If the entry hasn’t got an email address don’t include it". I am doing an “all fields” search, I put in the email address field @* thinking it would give me just entries with an @ (ie no blank entries) but it doesn’t work.

Try *@*

Iris

yes should have said I did that too, still get the blanks. It doesnt matter that much, you simply highlight the email addresses then send to them; just doesnt make sense.

I have to say this is one of the most perverse programs I have dealt with.. it just doesnt do common sense things half the time!

maybe give this a go...

Search > All Fields (or retrieve your existing catalog search) > Add > Basic Fields > Email Address > In From Box Type 0* (Zero*) > In To Box Type z* > Add > OK > Apply any other filters etc. (Leave the same if using your catalog search) > OK

... hope this makes sense!

Using the From 0* To z* trick seems to work with most of the text based fields that you can search on for me.

hope this was helpful, would be great if you could let me know how you get on!

quote:

Originally posted by Andrswal:
yes should have said I did that too, still get the blanks.

That's interesting - perhaps that's another quirk with v8.0?

Before my original post and now again I searched using the *@* and it performed as expected! FYI, we're still using Max 7.0.

Iris

quote:

Search > All Fields (or retrieve your existing catalog search) > Add > Basic Fields > Email Address > In From Box Type 0* (Zero*) > In To Box Type z* > Add > OK > Apply any other filters etc. (Leave the same if using your catalog search) > OK

Sorry have been away. Have tried this, I now have to own up to being an idiot. Yes it shows blanks because I have my view columns set to "email" but we have the entry form set to 3 email addresses namely "work" "home" and "other". If I alter the column view to show all three email addresses no blanks.

In my defence however, I am using this for a sendout and if you have a client with a blank email 1 address and a valid email 2 address maximiser doesnt seem to pick it up hence my previous mistake.