Find E-mail Address

[delboy2]

Hi
Is there any way that access can link to outlook and return the users e-mail address.

Guess I am just being lazy but it would save compiling a list of e-mail addresses

The reason I ask this is we are looking to automate mails to specific users who are still logged on to a database which is ran over several sites.

 

[dt01pqt]

Have you seen this?

 

[Steve5]

Dellboy,

This Vaioman!
Here is the VB code that will automatically set-up an e-mail from outlook, along with placing the distribution list you create in outlook.


Private Sub Command19_Click()
On Error GoTo Err_Command19_Click

' Open Report "Hidden"
DoCmd.OpenReport "enter report name here", acViewPreview, "", "", acHidden
' Send Report
DoCmd.SendObject acReport, "enter report name here", "SnapshotFormat(*.snp)", "enter distribution list NAME here", "", "", "subject title here", "Message in body of e-mail here", True, ""
' Report
DoCmd.Close acReport, "enter report name here"




Exit_Command19_Click:
Exit Sub

Err_Command19_Click:
MsgBox Err.Description
Resume Exit_Command19_Click

End Sub