Send HTML Email Using Email Addresses in Access DB

Question:

I'm trying to decide which Chilkat product to purchase. #1 I'm using Visual Basic 6 #2 I want to create and send HTML emails #3 I want to send the emails automatically using email addresses in an Access DB.

Answer:

You would need to purchase the Chilkat Mail ActiveX. If you also wanted to automate the conversion of HTML files and/or web pages to email, you would also want to purchase Chilkat MHT. (Chilkat Mail can be used to construct and send HTML emails, but if you want the images to be embedded in the email, you would have to write the code to edit the HTML IMG tags to be "CID:" URLs referencing the related items (image files) in the multipart/related email.)

Chilkat Mail provides a feature to send email to a distribution list. The email addresses in the Access database can be transformed into a CkStringArray, and passed to the Chilkat mailman's SendToDistributionList method.