How do we extract eMail addresses from RMS? We have them in two locations: in the eMail box shown on the "Billing Information" tag, and in a text box on the "additional" tag.
Extracting eMail Addresses
Sep 19, 2006
6 Replies
firstly what do you want to do with the email addresses when you extraxt them ?
Check the reports library on Customer Source. There are some extended reports that include Customer email and physical addresses.
Glenn Adams Tiber Creek C> How do we extract eMail addresses from RMS? We have them in two locations:
Hi jim you can use this SQL query
- open query analizer
- connect to your database of RMS
- copy and paste this in a query window
select EmailAddress, FirstName, LastName from customer
- you can copy the results in a excel file.
- you can send your coupons.
let me know if you need more help
see ya.. Robert> This is all new to me. Where are you referring to when you say the "reports
Robert, thanks for everything. It worked out perfectly. Now, all I have to do is figure out how to send out 1000 eMails.
Thanks
Jim
"robert> Hi jim
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required