<div>
I'm checking, but I'm not sure you can do that. &nbsp;You can include the sender's name. &nbsp;Here's Ron's website which is all to do about sending emails from Excel (and lots of other goodies).<br />
<br />
<a href="http://www.rondebruin.nl/cdo.htm" rel="ugc">http://www.rondebruin.nl/cdo.htm</a><br />
<br />
However, I'm testing this now:<br />
<br />
.To = [EMAIL=&quot;Recipient's Name&quot;]emailAddress@whateve<wbr />r.com[/EMA<wbr />IL]<br />
<br />
<br />
Dave
</div>


I'm checking, but I'm not sure you can do that.  You can include the sender's name.  Here's Ron's website which is all to do about sending emails from Excel (and lots of other goodies).

http://www.rondebruin.nl/cdo.htm [http://www.rondebruin.nl/cdo.htm]

However, I'm testing this now:

.To = [EMAIL="Recipient's Name"]emailAddress@whatever.com[/EMAIL]


Dave

<div>
Dave,<br />
<br />
I appreciate your quick response. &nbsp; &nbsp;I did have to modify it slightly to work within the rest of my code. &nbsp;<br />
<br />
.To = cell.Offset(0, 2).Value &amp;&nbsp;&quot; &lt;&nbsp;&quot; &amp;&nbsp;cell.Offset(0, 3).Value &amp;&nbsp;&quot; &gt;&nbsp;&quot;&quot;&quot;<br />
<br />
Thank you,<br />
Jack
</div>


Dave,

I appreciate your quick response.    I did have to modify it slightly to work within the rest of my code.  

.To = cell.Offset(0, 2).Value & " < " & cell.Offset(0, 3).Value & " > """

Thank you,
Jack

<div>
Right. &nbsp;Looks like I put that entire formula in quotes ;) &nbsp;Glad its working well for you.
</div>


Right.  Looks like I put that entire formula in quotes ;)  Glad its working well for you.

<div>
<div class="content wysiwyg-content">
I am using the CDO function in Excel to send batches of emails. &nbsp;I would like to include the recipient's name in addition to their email address in the To field.<br />
<br />
Their name is referenced by cell.Offset(0, 2).Value and their email is reference by cell.Offset(0, 3).Value. &nbsp;<br />
<br />
I receive an error if I simply concatenate the two fields together (cell.Offset(0, 2).Value &amp;&nbsp;cell.Offset(0, 3).Value)<br />
<br />
Can I include their name in the To field? &nbsp;If so, what is the syntax?<br />
<br />
Thank you in advance for any help.
</div>
</div>


I am using the CDO function in Excel to send batches of emails.  I would like to include the recipient's name in addition to their email address in the To field.

Their name is referenced by cell.Offset(0, 2).Value and their email is reference by cell.Offset(0, 3).Value.  

I receive an error if I simply concatenate the two fields together (cell.Offset(0, 2).Value & cell.Offset(0, 3).Value)

Can I include their name in the To field?  If so, what is the syntax?

Thank you in advance for any help.

Include Name with email when sending emails from Excel using CDO

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.