Why does it ask me to specify a table when creating a mail merge?

  • Thread starter Thread starter Ashley Claire
  • Start date Start date
A

Ashley Claire

I'm trying to create lables in word from an excel document but when I specify
the document and sheet, it prompts me to select a table and there is no table
to choose from! I'm so confused. This has never happened before.
 
This might help.

Make sure the sheet with the data is first sheet in workbook.......that's where
Word looks for source data.

Or Word will take a range name as the source if sheet is not first sheet.

In Excel, select the range to use for labels.

Insert>Name>Define.........give the range a name like MyLabels

Save the workbook.

Try the mailmerge again.


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 08:58:01 -0800, Ashley Claire <Ashley
 
Back
Top