multiple emails

[agorman]

Hi,

I have been using this code to send an individual email from a record by d/clicking on the email field, and it works great:

Dim StrInput As String
StrInput = "mailto:" & Me![EmailAddress]
Application.FollowHyperlink StrInput, , True

What I would like to do is to send the email to multiple recipients (cc) and wonderered if there was a simple way of doing this. For example could i run a querry to call up all the email addresses and then somehow send the email to those addresses (using my default mail client (OE))?

Thanks

Adrian

 

[ted.martin]

You can certainly loop through a series of e-mails from a query or table using DLOOKUP etc. but you will end up with (say) 10 separate e-mails which I assume will all have the same body which will be blank at this stage. The thread below will help but essentially you need to use the Outlook Object model which can allow you to use both the To: and CC: fields for your e-mail.


http://www.access-programmers.co.uk/forums/showthread.php?t=141517

 

[agorman]

Thanks for that Ted, I downloaded the db but unfortunatley it has gone way over my head ! (also I do not have MS outlook installed - I use Outlook Express only).

However, I will play around with it and see If I can figure out what to do.

Regards

Adrian

 

[ted.martin]

OK - you may need to get Outlook rather than Outlook Express as I am not sure if the object models are the same. As for the code, don't worry too much about all the complicated stuff in the Outlook section; its standard and you can just copy and paste the whole lot.

Think what you will have learned when you crack it. It took me quite a while the first time.

 

[agorman]

Thanks again.

I do have Outlook but never install it as I think it is more trouble than it is useful. I will install it and see what happens.

Regards again

Adrian