Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

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?

2010-10-01 16:58:00
Hican Mail Merge Toolkit be of any helphttp://www.mapilab.com/outlook/mail_merge/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.orExport 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 fileThe CSV file should break down the info by column, according to first name, last name, email address, telephone numberSave the CSV file in a place where you can find it easilyOpen Word, and choose Mail MergeUse your CSV file as the source, and choose the addressees you wantChoose the data fields you want and construct your merge.http://ist.uwaterloo.ca/cs/sew/courses/wp/Word2002Merge.pdf
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT