How do I populate a Word template from Excel data?

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.

How do you fill in a box in Word?

To add a fill or effect, click your shape, click Format, click the arrow next to Shape Fill or Shape Effects, and select a color, gradient, texture, or effect. Click the shape that you want to fill.

Can an Excel spreadsheet be used as the data source for a Word mail merge?

An essential step in a Word mail merge process is setting up and preparing a data source. You can use an existing Excel data source or build a new one by importing a tab-delimited (.txt) or comma-separated value (.csv) file.

How do I merge an Excel document into a Word document?

Embed an Excel Worksheet as an Object

1. Open the Word document.
2. Go to the Insert tab.
3. Select Object > Object.
4. In the Object dialog box, select the Create from File tab.
5. Select Browse, then choose the Excel worksheet that contains the data you want to embed.
6. Select OK.
7. The Excel worksheet is embedded in the Word document.

How do you fill a white outline?

Select your text or WordArt. Click Home > Text Effects. Click the effect you want. For more choices, point to Outline, Shadow, Reflection, or Glow, and then click the effect you want.

How do you create a data source in Word?

Go to Mailings > Select Recipients > Use an Existing List, then choose New Source to open the Data Connection Wizard. Choose the type of data source you want to use for the mail merge, and then select Next. Follow the prompts in the Data Connection Wizard to complete the data connection to the merge document.

How do you create a data source using Word table?

Use a table or query as the data source

1. Open the source database, and in the Navigation Pane, select the table or query that you want use as the mail merge data source.
2. On the External Data tab, in the Export group, click Word Merge.

How do you fill a white outline in Word?

Add an outline, shadow, reflection, or glow text effect

1. Select your text or WordArt.
2. Click Home > Text Effects.
3. Click the effect you want. For more choices, point to Outline, Shadow, Reflection, or Glow, and then click the effect you want.

How do I fill a shape with text in Word?

Right-click anywhere in your shape and click the “Add Text” command. This places an insertion point in the shape where you can type your text. Once you’ve added whatever you want to write, the “Format” tab has tools you can use to give your text a little pop with things like text styles and shading.