I am asked twice to select an excel table in mail merge
 

I have been doing mail merges for ages. We haven't upgraded or changed
anything recently. For some reason now, though, while going through the
prompts, i am asked to select a table IMMEDIATELY AFTER I have just gone into
Excel and selected which data file I will be using. The mail merge won't
complete because it's asking me for a table - and I can't tell it anything.
What am I doing wrong? I am wondering if I've changed something in the
actual set-up for Excel, not realizing what the implications were going to
be, down the road!

Help would be appreciated!

I am asked twice to select an excel table in mail merge
 

Mailmerge requires that the source data in the Excel workbook be on the
first sheet or in a named range within the workbook.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 12:27:01 -0700, VMPeters
wrote:

I have been doing mail merges for ages. We haven't upgraded or changed
anything recently. For some reason now, though, while going through the
prompts, i am asked to select a table IMMEDIATELY AFTER I have just gone into
Excel and selected which data file I will be using. The mail merge won't
complete because it's asking me for a table - and I can't tell it anything.
What am I doing wrong? I am wondering if I've changed something in the
actual set-up for Excel, not realizing what the implications were going to
be, down the road!

Help would be appreciated!