Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does it ask me to specify a table when creating a mail merge?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does it ask me to specify a table when creating a mail merge?
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. InsertNameDefine.........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 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge | Excel Discussion (Misc queries) | |||
Mail merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |