Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to form email in outlook | Excel Worksheet Functions | |||
Create Outlook email from Excel | Excel Discussion (Misc queries) | |||
Excel and Email/Outlook | Excel Worksheet Functions | |||
How do I get excel to create an email using Outlook? | Excel Discussion (Misc queries) | |||
automate input of an address from Outlook into excel | Excel Discussion (Misc queries) |