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.