How can I set Outlook Mail merge to show the contacts’ name in the sent folder?

Sharon September 28, 2010

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?

  1. Anonymous
    October 1, 2010 at 4:58 pm

    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.