Using Outlook with Excel to Input Names into Email
 

Hi All,
I have an Excel Spreedsheet that has email names in cell
C3:AU3. Is there a way to build a command button or form
in the spreadsheet to input thoses names into the MS
Outlook To: Section of the email? Thanks for the Help!

Using Outlook with Excel to Input Names into Email
 

Paul,

Everything you wanted to know about e-mailing from
Excel (and then some):

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

John

Paul wrote:

Hi All,
I have an Excel Spreedsheet that has email names in cell
C3:AU3. Is there a way to build a command button or form
in the spreadsheet to input thoses names into the MS
Outlook To: Section of the email? Thanks for the Help!

Using Outlook with Excel to Input Names into Email
 

Ron,
Thanks for the info! Where do I plug that code in? I am
confused!
-----Original Message-----
You can use this

Dim cell As Range
For Each cell In Range("C3:AU3").Cells.SpecialCells
(xlCellTypeConstants)
If cell.Value Like "*@*" Then
strto = strto & cell.Value & ";"
End If
Next
strto = Left(strto, Len(strto) - 1)

And use this in the To field

..To = strto



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul" wrote in message
...
Hi All,
I have an Excel Spreedsheet that has email names in cell
C3:AU3. Is there a way to build a command button or form
in the spreadsheet to input thoses names into the MS
Outlook To: Section of the email? Thanks for the Help!


.

Using Outlook with Excel to Input Names into Email
 

http://www.rondebruin.nl/sendmail.htm#other

Look here Paul

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul" wrote in message ...
Ron,
Thanks for the info! Where do I plug that code in? I am
confused!
-----Original Message-----
You can use this

Dim cell As Range
For Each cell In Range("C3:AU3").Cells.SpecialCells
(xlCellTypeConstants)
If cell.Value Like "*@*" Then
strto = strto & cell.Value & ";"
End If
Next
strto = Left(strto, Len(strto) - 1)

And use this in the To field

..To = strto



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul" wrote in message
...
Hi All,
I have an Excel Spreedsheet that has email names in cell
C3:AU3. Is there a way to build a command button or form
in the spreadsheet to input thoses names into the MS
Outlook To: Section of the email? Thanks for the Help!


.

Using Outlook with Excel to Input Names into Email
 

Ron,

I think I said that already <vbg

Again, my thanks for an excellent web page that
completely answers over 90% (maybe more) of the
questions posted on the subject of e-mail (of which
there are an abundance).

John

Ron de Bruin wrote:

http://www.rondebruin.nl/sendmail.htm#other

Look here Paul

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl