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...
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.