When using the Mail merge wizard with Outlook – how can I force the “display name” indicated in my Outlook contacts to appear in the sent eMail in lieu of their email address?
can Mail Merge Toolkit be of any help
The Mail Merge Toolkit dialogue looks very similar to the standard Microsoft Office box "Merge to Electronic Mail". In that box, like in the standard one, you can choose the data field containing recipient addresses, set message subject (btw, in Mail Merge Toolkit you can use automatic data field insertion like in a document text), set the format, and choose files to be attached to each message if necessary.
Export your contacts to Excel. Put the desired "To:" name in the A column, then put the corresponding email addresses in the B column.
In column C, your formula needs to be ="'"&A1&"'"&" ""
The ouput in column C will read 'Name'
Export contacts into a CSV file
The CSV file should break down the info by column, according to first name, last name, email address, telephone number
Save the CSV file in a place where you can find it easily
Open Word, and choose Mail Merge
Use your CSV file as the source, and choose the addressees you want
Choose the data fields you want and construct your merge.