Mail Merge basics - I think I'm missing something

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin J Prince - 14 May 2006 18:09 GMT

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

Signature

Kevin J Prince

Reply to this Message

Doug Robbins - Word MVP - 15 May 2006 04:54 GMT

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.

Signature

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

> OK all you clever ones will say a brain.....
>
[quoted text clipped - 13 lines]
>
> Regards

Reply to this Message

Kevin J Prince - 15 May 2006 07:05 GMT

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

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

Signature

Kevin J Prince

Reply to this Message

Cindy M -WordMVP- - 15 May 2006 10:29 GMT

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
[quoted text clipped - 3 lines]
> 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 :-)

Reply to this Message

Kevin J Prince - 15 May 2006 11:17 GMT

Sorry Group...

Thanks Cindy.

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

SORRY!

>Hi Kevin,
>
[quoted text clipped - 15 lines]
>This reply is posted in the Newsgroup; please post any follow question or
>reply in the newsgroup and not by e-mail :-)

Signature

Kevin J Prince

Reply to this Message

Cindy M -WordMVP- - 15 May 2006 17:03 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 15 May 2006 18:14 GMT

I would use Access rather than Excel.

Signature

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

> Thanks,
> I think that means in real terms a 63 worksheet GRIN...
[quoted text clipped - 16 lines]
>>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.

Reply to this Message

Kevin J Prince - 15 May 2006 18:29 GMT

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

>I would use Access rather than Excel.

Signature

Kevin J Prince

Reply to this Message

Rate this thread: