View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kevin J Prince
 
Posts: n/a
Default Mail Merge basics - I think I'm missing something

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