Email to more than 1 recipient

#11

You can use a code like:

Dim olApp As Outlook.Application
Dim olItem As Outlook.MailItem

Set olApp = CreateObject("Outlook.Application")
Set olItem = olApp.CreateItem(olMailItem)

olItem.Recipients.Add ("aaa (AT) bbb (DOT) com")
olItem.Recipients.Add ("ccc (AT) ddd (DOT) com")

olItem.Display

Peter
http://access.xps350.com/

#12

On 05/06/2011 21:00:00, XPS350 wrote:

Quote:

You can use a code like:

Dim olApp As Outlook.Application
Dim olItem As Outlook.MailItem

Set olApp = CreateObject("Outlook.Application")
Set olItem = olApp.CreateItem(olMailItem)

olItem.Recipients.Add ("aaa (AT) bbb (DOT) com")
olItem.Recipients.Add ("ccc (AT) ddd (DOT) com")

olItem.Display

Peter
http://access.xps350.com/

Thanks Peter

Think it might demend which version of Office you are using.
Does olItem.Recipients.Add ("Fred Smith")
olItem.Recipients.Add ("John Jones") work as well.
Do I need to do a olItem.ResolveAll (I think that is the correct syntax)?

Phil

#13

It works in versions 2002-2010

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote

Quote:

Thanks, Ed

Which version of Access / Office are you using

Phil

#14

On 06/06/2011 13:41:48, "Ed Robichaud" wrote:

Quote:

It works in versions 2002-2010

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in message
news:isg5td$l1r$1 (AT) speranza (DOT) aioe.org...
Thanks, Ed

Which version of Access / Office are you using

Phil

Thanks Ed

Seems to be OK now. I think the space after the semicolon was the cause of
the trouble.

Thanks again

Phil

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Email to more than 1 recipient

comp.databases.ms-access comp.databases.ms-access

Re: Email to more than 1 recipient - 06-05-2011 , 03:00 PM

Re: Email to more than 1 recipient - 06-05-2011 , 04:18 PM

Re: Email to more than 1 recipient - 06-06-2011 , 07:41 AM

Re: Email to more than 1 recipient - 06-06-2011 , 08:14 AM