Send Email from Excel - but only to people in range
 

hi all,

am new to coding, any help appreciated. have tried google etc to no avail.

List of names in A1:A100
List of either Yes or No in B1:B100 respectively

I would like to send an email to everyone in Range A1:A100 that has a 'No'
next to their name in column B

eg Create a text string of names that meet the 'No' criteria of column B and
pass it to Outlook.

Any help/code greatly appreciated
tia

Steve

Send Email from Excel - but only to people in range
 

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en...odc_xlmail.asp

Dick Kusileka's site
http://www.dicks-clicks.com


You should be able to find most of what you need.

--
Regards,
Tom Ogilvy



Steve wrote in message
...
hi all,

am new to coding, any help appreciated. have tried google etc to no
avail.

List of names in A1:A100
List of either Yes or No in B1:B100 respectively

I would like to send an email to everyone in Range A1:A100 that has a 'No'
next to their name in column B

eg Create a text string of names that meet the 'No' criteria of column B
and
pass it to Outlook.

Any help/code greatly appreciated
tia

Steve

Send Email from Excel - but only to people in range
 

Can you do a sort by column B? Then eliminate the No's and send the rest to Outlook

I'm a rookie so perhaps I don't know what I'm talking about

Send Email from Excel - but only to people in range
 

http://www.rondebruin.nl/sendmail.htm#message
Perfect Tom...much appreciated

thanks
steve




"Tom Ogilvy" wrote in message
...
Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en...odc_xlmail.asp

Dick Kusileka's site
http://www.dicks-clicks.com


You should be able to find most of what you need.

--
Regards,
Tom Ogilvy



Steve wrote in message
...
hi all,

am new to coding, any help appreciated. have tried google etc to no
avail.

List of names in A1:A100
List of either Yes or No in B1:B100 respectively

I would like to send an email to everyone in Range A1:A100 that has a
'No'
next to their name in column B

eg Create a text string of names that meet the 'No' criteria of column B
and
pass it to Outlook.

Any help/code greatly appreciated
tia

Steve