How can I send an email to multiple email addresses through Outlook 2007

[farisallil]

Hi
I have a table called Info with a column called Email Address in it. I want to create a command button in a form called Customer ,which has the Info table as the Record Source, and I want this command to open up a new email window in Outlook 2007 and copy all the email addresses to the To field without forgetting adding a semicolon after each email

How can I do that? or what is the VB code for such button?
I'm not so good in Access but I have a little experience

Any help will be greatly appreciated

 

[John Big Booty]

The code behind your button will look something like this;

Private Sub CmdEmail_Click()
DoCmd.SendObject acSendReport, "ReportNameHere", "FormatHere", MessageTo, MessageCC , MessageBCC , "SubjectHere", [Body], True
End Sub

To concatenate your email address see the example in this link

 

[CEH]

Take a look at this code RuralGuy helped me on a while back... Does what you want I think.....
http://www.access-programmers.co.uk/forums/showthread.php?t=96783