Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

send email and attachments from VB 6 app using ms access db

Status
Not open for further replies.
Dec 17, 2002
7
GB
I am trying to develop a VB6 package that will use Outlook 2k to send a number of emails and attachments to various users drawing the details from an ms access database. can anyone help with the code for this please?
 
There have been quite a lot of posts regarding email (To Outlook/MAPI) so you could find some examples by doing a keyword search on "email", "MAPI" or "outlook". In general what you will need to do is:

1) Open the recordset containing your data
2) Loop throught the recordset, access the relevant email function (Outlook, MAPI or whatever you choose to use) and send the email

Do you need help on how to obtain the recordset details?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top