Adding Recipient Name using PHP Mailer within excel VB script

Recently i had to send email and i was forced to use PHP Mailer instead of other options. The problem i was facing that PHP Mailer does not have a separate recipient name and recipient address fields but it only has one field addAddress.

So after some hit and trial i was able to add recipient Name and address in this using following code.

StrTo = recipient_email & “‘,'” & recipient_name