We're about to upgrade from a DOS register program to POS v2.0. We've just started up our store mailing list, and I need to be able to grab the latest e-mail addresses entered into the database during the day. I don't see any way at all to get e-mail addresses out of POS. Am I missing some report?
I'm fine with getting all the addresses then comparing them to my existing list. But I do need a way to get them out or life is about to become much more difficult.
Thanks.
-Laura
I use a simply query... with a where statement for the date. Then I export to CSV and merge with my newsletter system. I also saw a qrp somewhere on the list... awhile back.
select lastname, firstname, emailaddress, accountopened from customer where emailaddress '' and accountopened > '01/09/2007' order by accountopened
Danny
Thanks Danny. I really should've thought of that. I've been working with the old database so long I've forgotten the simplicity of queries.
"Danny" scribbled these words:
No problem - nice to have people in the newsgroup to bounce ideas with...
Have something to add? Share your thoughts — no account required.
Ask the community — no account required