Multiple Emails

[jocat]

I have a database that contains a table of individuals. I would like to send Email messages to all, or select individuals within the table.

Can anyone advise me on the best method to perform this task.

Your help would be greatly appreciated.

 

[SQLBI]

Jo,

The following will create a new email message assuming you're using MS Outlook as your mail client.


Dim olApp As Object
Dim subject As String
Dim olMailItem
Dim newMail
Dim newRecipient
Dim mailBody As String

subject = "Your text here"
mailBody = "Your text here"

Set olApp = CreateObject("Outlook.Application&quot
Set newMail = olApp.CreateItem(olMailItem)
Set newRecipient = newMail.Recipients.Add(someone@somewhere.com)

With newMail
.subject = subject
.body = mailBody
End With

newMail.send

olApp.Quit
Set olApp = Nothing
Set newMail = Nothing
Set newRecipient = Nothing

hope this helps.


Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk