N
TruthVerse News

Can you mail merge from Excel to Word?

Author

Christopher Duran

Updated on February 22, 2026

Can you mail merge from Excel to Word?

On your Word document, highlight the field you want to populate with the data from Excel. On the Mailings tab, choose the 'Insert Merge Field' button, a list of the column headers on your saved excel document will drop down (i.e. Company Name, etc.). Choose the appropriate field you want to merge and choose Insert.

Moreover, how do I mail merge from Excel to Word?

You can insert one or more mail merge fields that pull the information from your spreadsheet into your document.

  1. Go to Mailings > Insert Merge Field.
  2. Add the field you want.
  3. Repeat steps 1 and 2 as needed.
  4. Choose File > Save.

Furthermore, can you mail merge pictures from Excel to Word? You can't put an image in an Excel spreadsheet cell and import that image into a mail-merged Word document. That just doesn't work. When Word imports information from an Excel spreadsheet during a mail merge, it only wants text-based data.

Accordingly, how do you mail merge from Excel?

Once you have completed the mail merge, the emails will be sent from your Outlook mailbox.

  1. Open an Excel workbook containing the names and other identifying data that you want to use in your email.
  2. Open Microsoft Word and type your form letter.
  3. Click on the "Mailings" tab, choose "Start Mail Merge" and click "Email."

How do I mail merge from Excel to Word percentage?

Mailmerge - Percent in Excel Sheet converts to decmail in word document

  1. select your mergefield, which will look something like «Percent»;
  2. press Ctrl-F9 to wrap another field around it, thus { «Percent» };
  3. edit the field so that you get {=«Percent»*100 # 0.00%};

How do I mail merge labels from Excel to Word 2010?

Making Address Labels Using Address Blocks
  1. To start the Mail Merge for labels, you should already have an Excel spreadsheet with a list of all the addresses you want to use.
  2. Next, open up Word and click on the Mailing tab at the top.
  3. Click on Start Mail Merge, then select Step-by-Step Mail Merge Wizard.

How do I import data from Excel to Word?

How to Import Excel Data into a Word Table
  1. Open a new or existing document in Microsoft Word.
  2. Click the "Insert" tab > Locate the "Tables" group.
  3. Select the "Table" icon > Choose the "Insert Table" option.
  4. Set the "Number of columns," "Number of rows," and "AutoFit behavior" to your desired specifications > Click [OK].

What are the six steps of mail merge?

There are six steps in the mail merge wizard:
  1. Select the document type.
  2. Start the document.
  3. Select recipients.
  4. Write your letter.
  5. Preview your letters.
  6. Complete the merge.

Can you make Avery labels from an Excel spreadsheet?

If you use Microsoft Office, you can easily import addresses or other data from an Excel spreadsheet and place them onto Avery labels, name badges, name tags or other products to edit and print using Microsoft Word. See the steps to mail merge onto an Avery template, making preparing for mailings and meetings a breeze.

How do you mail merge from Excel into a picture?

Press Mailings + Insert Merge Field and select the database field you need. You'll immediately see a preview of the image in the top, right corner. A preview of the picture file's full name is to the left for reference. Press Alt + F9 again to go back to Picture View to view your handiwork.

How do I use mail merge in Word?

How to Use Mail Merge in Microsoft Word
  1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge .
  2. Click Step-by-Step Mail Merge Wizard .
  3. Select your document type.
  4. Select the starting document.
  5. Select recipients.
  6. Write the letter and add custom fields.

How do I add a logo to a mail merge?

How to insert and print a picture or logo in a mail merge
  1. Create a merge letter using Word merge integration.
  2. When adding fields to the merge document, insert picture/logo in the appropriate location by selecting Insert, Picture from the menu bar of Word.
  3. Select the picture from the Pictures library or browse to the picture location.

How do I mail merge a picture in Word?

Click on the picture and press “Alt+ F9” to toggle to field codes. Select the “pic” you just input and click “Mailings” tab. Then click “Insert Merge Field” and choose the right field.

What is mail merge in MS Word?

Mail Merge is a handy feature that incorporates data from both Microsoft Word and Microsoft Excel and allows you to create multiple documents at once, such as letters, saving you the time and effort of retyping the same letter over and over.

How do I add an image to a mail merge label?

Create a single label with a graphic
  1. Start by creating a New Document of labels.
  2. Select Mail Merge (we're creating a blank sheet).
  3. Insert a graphic and then select it.
  4. Go to Picture Format > Wrap text and select Square.
  5. Drag the image into position within the label.

How do you mail merge a picture in Word 2013?

Mail Merge With Variable Pictures Using Word 2013
  1. Reconnect to your Data Source file: from the Start Mail Merge group, click Select Recipients, Use an Existing List, browse to your Excel Data Source file.
  2. Press FN+ALT+F9 to display field codes.
  3. Click in the square in the banner on the right where the picture will be inserted:

Can you merge images in Word?

Double-click the image, which opens the picture on the Word page. Click once on the first image, press and hold down the “Ctrl” key and then click once on each other image. When they're all selected, click the “Insert” button and the to-be-merged pictures open together on the page, but not yet merged.

How do I format a merge field in Word?

To format a merge field:
  1. In the template document, while the merge field is selected, do the following to display the field code: Press Shift + F9 on Windows.
  2. Remove " * MERGEFORMAT " from the field code.
  3. Enter the switch in the field code. For example:
  4. Update the field: Press F9 on Windows.

How do I mail to 2 decimal places?

If you want to round to two decimal places, use #0.00 in your merge field. If you want the number to have a dollar sign before it (for anything that is money), use #$# in your merge field.

Why is my mail merge date format not working?

Sometimes in a Word Mail Merge the dates do not come out as Day/Month/Year regardless of how you enter it in your data (usually an Excel spreadsheet). To fix this you need a workaround in Word. Essentially you need to add a code to tell Word what format you want it to show.

How do I change the date format in a mail merge in Word 2007?

Controlling Date Formats in a Mail Merge
  1. Display the Word Options dialog box. (In Word 2007 click the Office button and then click Word Options.
  2. Click Advanced at the left side of the dialog box.
  3. Scroll through the available options until you come to the General section.
  4. Make sure the Confirm File Format Conversion On Open check box is selected.
  5. Click on OK.

How do I get rid of decimals in Excel?

For example, to remove all digits except the first one after decimal, you can apply the formula =INT(E2*10)/10. TRUNC function: Besides the value you will remove digits after decimal, enter the formula =TRUNC(E2,0) into a blank cell, and then drag the Fill Handle to the range you need.

How do I bold a field in a mail merge?

Turn on bold formatting (press Ctrl+B). Insert the company merge field followed by a space. Turn off bold formatting (again press Ctrl+B), and insert the company merge field again.

How do I keep formatting in a mail merge?

Method 2
  1. In Excel, select the column that contains the ZIP Code/Postal Code field.
  2. On the Format menu, click Cells.
  3. Click the Number tab.
  4. Under Category, click Text, and then click OK.
  5. Save the data source. Then, continue with the mail merge operation in Word.

Why does my font change in a mail merge?

When you perform a mail merge, the merged information may appear in a different font. This behavior occurs when the default Normal style is different from the font applied to your mail merge main document. Once you click on Next: Preview your letters the font size changes.

Related Documentation

Does vitamin D increase growth?

How do you defend a unit in football?

Why is Rome a popular tourist destination?

Can you mail merge from Excel to Word?