Using Worksheet as Data Source

P

Pixie78

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.
 
S

smartin

Pixie78 said:
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.

I can't speak to E2007, but in E2003 (for me at least) I can only get a
worksheet to appear as a data source if it contains a named range that
contains all the data.
 
S

Sheeloo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top