Mail Merge Issues

M

mike L.

This is something that randomly began happening today with a mail merge that
i perform every day or two. The document is an e-mail merge in Word 2003,
and the data source is as plain old spreadsheet in Excel 2003, and usually i
have no problem linking the two files. Today, Word started opening the
"Select Table" dialog box a second time, after selecting "Sheet1$" as i
usually do. This new "Select Table" dialog is smaller, and has nothing in
it, other than "Table:" and "Options..." "Ok" and "Cancel" buttons along the
bottom. If i select Options, another dialog pops up with four checkboxes
(and doesn't help me at all). If i hit "Ok" i get "Word was unable to open
the data source."

I've tried creating a new document, and also copying and pasting some of the
records from the Excel sheet to another sheet, with the same unfortunate
result. This could become a serious issue for me at some point soon.

If anyone's got any suggestions, i'm happy to try anything out. Like i
said, this was totally random.

thanks!
 
Top