Hello,

I am using Office 2007, which I am new to from 2003 and which I am not
liking that much. I created a workbook in Excel to use for mail merges for
my company and I have about 7 tabs, 1 for each property. I am using each
worksheet as its own data source, however, it doesn't seem to be pulling all
the sheets in the book. I can only get 4 to show as data sources. I even
copied and pasted a worksheet into its own file and when I tried to link it
as a data source from the mailings option in Word, it told me that the
document was not formatted to be a data source. I'm confused on how half the
worksheets are fine and the others are not correct when they all have the
same layout and information set up..... Please help. And keep in mind that I
cannot find anything on this 2007 version.
Thanks for any help.

Do you have lables (column headings) for all columns?

Do you still have access to 2003? Did the worksheet work in 2003?

Can you upload a copy to wikisend.com and paste a link here?

"Pixie78" wrote:

Hello,

I am using Office 2007, which I am new to from 2003 and which I am not
liking that much. I created a workbook in Excel to use for mail merges for
my company and I have about 7 tabs, 1 for each property. I am using each
worksheet as its own data source, however, it doesn't seem to be pulling all
the sheets in the book. I can only get 4 to show as data sources. I even
copied and pasted a worksheet into its own file and when I tried to link it
as a data source from the mailings option in Word, it told me that the
document was not formatted to be a data source. I'm confused on how half the
worksheets are fine and the others are not correct when they all have the
same layout and information set up..... Please help. And keep in mind that I
cannot find anything on this 2007 version.
Thanks for any help.