Extracting eMail Addresses

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

1. open query analizer
2. connect to your database of RMS
3. copy and paste this in a query window

select EmailAddress, FirstName, LastName from customer

1. you can copy the results in a excel file.
2. 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