I have a vba module which sends an email using Outlook. The code I use is shown below.

DoCmd.SendObject acSendReport, "rptEmailWinnertoMembers",
acFormatHTML, "Margaret McDonald", "", strBccList, "Firrhill High School Association
Lottery Club", "Lottery results for " & Format(Date, "mmmm yyyy"), True, ""

As I have several email accounts, I would like to sepcify which account is used (profiles aren't set up) using (normally) the Options choice in Outlook.

Does anyone know if there is a way to set this option in my VBA command?

Colin McDonald
colinmac@blueyonder.co.uk