Automatically Emailing Data from MS Access to MS Outlook 
Author Message
 Automatically Emailing Data from MS Access to MS Outlook

Quote:

>I would like to take data from a database and automatically email via =
>Outlook. Fields included in my ms access database are email address and =
>error code message. How can I transfer this data into the MS Outlook =
>Outbox so that a message will automatically be emailed?

In addition to Davids suggestion see my website below for an email
FAQ.

Tony
----
Message posted to newsgroup and emailed.
Tony Toews, Independent Computer Consultant
The Year 2000 crisis: Will my parents or your grand parents still be receiving
their pension in January, 2000?  See www.granite.ab.ca/year2000 for more info.
Microsoft Access Hints, Tips & Accounting Systems at www.granite.ab.ca/accsmstr.htm



Thu, 11 Jan 2001 03:00:00 GMT  
 Automatically Emailing Data from MS Access to MS Outlook

Here is what I use to send an e-mail via Outlook or Exchange

Private Sub EmaiReportButton_Click()
On Error GoTo Err_EmaiReportButton_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

    Dim stDocName As String

    stDocName = "IssueReport"

    'DoCmd.SendObject acReport, stDocName
    DoCmd.Save
    DoCmd.SendObject acSendReport, "IssueReport", acFormatTXT, _
    Form_IssueTable.KeyPerson, , , _
    "A New EMIS Exception Issue", , False, False

Exit_EmaiReportButton_Click:
    Exit Sub

Err_EmaiReportButton_Click:
    MsgBox Err.Description
    Resume Exit_EmaiReportButton_Click

End Sub

James A. Taylor Jr.



Mon, 15 Jan 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Automatically Emailing Data from MS Access to MS Outlook

2. Use VBScript to read data from MS-Access to MS-Outlook

3. automation from ms access to ms outlook to do something

4. DDE between MS Access and MS Outlook

5. Print out MS Outlook calendars via VBA WITHIN MS Outlook

6. How does one look at data in an open MS access aplication from MS Word

7. Saving data in MS Project 98 to MS Access

8. How does one look at data in an open MS access aplication from MS Word

9. MS ACCESS data to MS EXCEL directly

10. EMailing out of MS Access 2.0 (NT 4) with a Lotus Client

11. send email automatically from Filemaker via MS Outlook 2000

12. Need help automatically selecting MS Outlook Object Library in VB -please

 

 
Powered by phpBB® Forum Software