Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 :-) |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge basics - I think I'm missing something
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
Please help - Missing headers in mail merge | Mailmerge | |||
Header missing from mail merge document | Mailmerge | |||
Mail Merge Word/OutLook Express Date Missing causes email bounces? | Mailmerge | |||
mail merge with attachments | Mailmerge |