Creating new mail with default mail program

[Fides]

Hello again,

I want to put 2 buttons on my form which creates a new mail using the default program. First button would have to put all email addresses in the database into the BCC field. The second button would put all people filtered by a listbox into the BCC field.

I hope this is clear enough. Haha.

Thanks in advance!

 

[John Big Booty]

Have you had a look at the SendObject method.

It will look something like

    Dim stDocName As String

    stDocName = "RPT_SFPOStatusGen"
    DoCmd.SendObject acReport, stDocName, acFormatSNP, [EmailAdd], "brad@progressshipping.com;andrew@progressshipping.com;tony@progressshipping.com", , [SEmailSub], [EmailMess], True

The variables in the Square brackets [] all represent fields that reside on the calling form.

 

[Fides]

Isn't it possible to use the FollowHyperlink option? Then somehow loop through the database and get the emails?