OK all you clever ones will say a brain.....

I need to mail merge some data from an excel workbook, the workbook
consists of some 62 worksheets. 52 of which are identical structure but
with different (guess what ) weeks information in them.

I need to access the information from each of these 52 worksheets, the
cells in question are C33 and F4. How do I reference these in a Word
mail merge document?

I just do not seem to be able to get anything to work... I have labelled
C33 and F4, but even using the correct worksheet ref and the cell labels
or cell reference just wont work.

HELP please what have I missed.

Regards

--
Kevin J Prince

Word can only use one sheet as the mailmerge data source. Therefore you
will need to add another sheet to the file and on it reference in a column
for each week, the cells C33 and F4 from the other 52 sheets and then use
that sheet as the data source for the mail merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Kevin J Prince" wrote in message
...
OK all you clever ones will say a brain.....

I need to mail merge some data from an excel workbook, the workbook
consists of some 62 worksheets. 52 of which are identical structure but
with different (guess what ) weeks information in them.

I need to access the information from each of these 52 worksheets, the
cells in question are C33 and F4. How do I reference these in a Word mail
merge document?

I just do not seem to be able to get anything to work... I have labelled
C33 and F4, but even using the correct worksheet ref and the cell labels
or cell reference just wont work.

HELP please what have I missed.

Regards

--
Kevin J Prince

Thanks,
I think that means in real terms a 63 worksheet GRIN...
so that gives me another question...

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

Just trying to make the whole thing simpler!

Regards Kevin



In message , Doug Robbins - Word
MVP writes
Word can only use one sheet as the mailmerge data source. Therefore you
will need to add another sheet to the file and on it reference in a column
for each week, the cells C33 and F4 from the other 52 sheets and then use
that sheet as the data source for the mail merge.


--
Kevin J Prince

Hi Kevin,

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

You need to ask this in an Excel forum :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Sorry Group...

Thanks Cindy.

I'm only subscribed to two, other than this one its the excel one.

SORRY!

In message VA.0000bf69.007965e1@speedy, Cindy M -WordMVP-
writes
Hi Kevin,

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

You need to ask this in an Excel forum :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)


--
Kevin J Prince

Hi Kevin,

I'm only subscribed to two, other than this one its the excel one.

SORRY!

Not a problem :-) It's just that you're more likely to get a quick
answer, or even any answer, asking there. If I'd known how to do it,
I'd have told you.

Cindy Meister

I would use Access rather than Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Kevin J Prince" wrote in message
...
Thanks,
I think that means in real terms a 63 worksheet GRIN...
so that gives me another question...

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third one
would be the date from A3 & A9 ) Do I have to get into some form of VBA to
do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

Just trying to make the whole thing simpler!

Regards Kevin



In message , Doug Robbins - Word
MVP writes
Word can only use one sheet as the mailmerge data source. Therefore you
will need to add another sheet to the file and on it reference in a column
for each week, the cells C33 and F4 from the other 52 sheets and then use
that sheet as the data source for the mail merge.


--
Kevin J Prince

Thanks,

Hmmmm, I wish I had now. But I have three years figures input now. First
year can be ignored or lost but it's still 62/63 worksheets per year.

Ah well looks like it can't be done, so it will have to be the hard way.

Cheers

In message , Doug Robbins - Word
MVP writes
I would use Access rather than Excel.


--
Kevin J Prince