Can I use Paradox 8 as an e-mail marketing tool?

[hotrodjim48]

I have a customer using Paradox 8 to keep track of customers and what they purchase from them. The dbase has about 5000 customers in it. Right now, using filters they group customers by purchases and print mailing labels and send them an apropriate catalog. In the dbase it has email address and when you click on the e-mail Paradox invokes an e-mail client... They are wondering if they can filter customers who bought chocolate chip cookies and e-mail them all "monthly specials" by the query results of the choclate chip cookie customers. So it looks like a personal e-mail to them and not have a bunch of e-mail address in the to: portion without having to do one email at a time.

 

[Kliot]

Sure, at least I think so. I belive Paradox started supporting MAPI in version 8. Look up "Mail" in objectpal help. It's easy to set up in a scan in the filtered table.

var
m MAIL
tc tcursor
endVar

tc.open("customer table&quot
scan tc:
m.addAddress(tc.customer-email-address)
m.setSubject("Cookies&quot
m.setMessage("Buy our Yummy Cookies&quot
m.send()
endscan

I do something similar to this at the end of the day to send my customers shipping details for their orders.

Good luck
Perrin

 

[Kliot]

Forgot to add you need to m.emptyAddress() or m.empty() to clear the mail for the next message

scan tc:
m.addAddress(tc.customer-email-address)
m.setSubject("Cookies&quot
m.setMessage("Buy our Yummy Cookies&quot
m.send()
m.empty()
endscan

or

m.setSubject("Cookies&quot
m.setMessage("Buy our Yummy Cookies&quot
scan tc:
m.addAddress(tc.customer-email-address)
m.send()
m.emptyAddress()
endscan

Perrin

 

[Kliot]

Make that m.emptyAddresses()

 

[hotrodjim48]

Thank you... Happy that you are a programer... Have a CSE deg. But don't know syntax...
Thank you,
Thank you,
Thank you,
Will post back and let you know how it went.
Jim

 

[Langley]

I have successfully done this - but the message length was a problem. As long as you keep it short (say, a brief note and link), you should be okay. You can also add attachments (i.e. a TXT file). Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[hotrodjim48]

OK, I'm getting a syntax error on the word email.
I coppied what you had?
Any suggestions?

 

[Kliot]

Can you post your code and I'll see if I can find the problem.

Perrin