Email addresses in Excel 1

[mccullj]

I have a program that sends out an Email to a user when that user needs to carry out a task as dictated by Excel.
The user name is picked from a cell in Excel.
On some occasions there may be more than one user hence multiple Email addresses. I can find many ways to send to a single mail but no ways to send to multiple mails as dictated by an Excel Range.
Currently I am sending one mail at a time.
Can anyone help with this please.

Jim

 

[SkipVought]

Hi,

Use a for..next loop

'assumed that you list starts in A2, is more than one cell, and is contiguous
dim r as range

for each r in range([A2], [A2].end(xldown))
  'send eMail here to ...
  msgbox r.value
next

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[strongm]

Is it safe to assume that you are using Outlook?

 

[mccullj]

Thanks Skip I will try that.

 

[mccullj]

Sorry all I should have said. Yes I use Outlook 2003.

 

[strongm]

So are you automating Outlook from Excel to send your email?