#1
|
|||
|
|||
Word vs Excel (NEXTIF, SKIPIF mergefield)
Hallo,
in our company we use Word merge for some Agreements. No problem to specify commands IF for example: { IF { MERGEFIELD name }<>"" { MERGEFIELD birh no } "................" } etc. but this is only to specify only for column record,,,, Excel: 1st row.... LV = 1, name = Mr. Black 2nd row... LV = 1, name = Mr. Brown 3rd row... LV = 1, name = Mrs. Brown 4th row... LV = 2, name = Mr. Blue 5th row... LV = 3, name = Mrs. Blue 6th row... LV = 3, name = Mr. White .. .. etc. Word: (merge to Excel) 1st Agreement for LV = 1.... 3 people on one page (Mr. Black, Mr. Brown, Mrs. Brown)2nd Agreement for LV = 2.... 1 people on one page (Mr. Blue) 3rd Agreement for LV = 3.... 2 people on one page (Mrs. Blue, Mr. White).. .. etc. Many thanks. Jerry (CZ) |
#2
|
||||
|
||||
Hi Jerry,
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://windowssecrets.com/forums/sho...ngs-(2000-2010) or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. For some recent, worked examples, see the attachment to the posts at: https://www.msofficeforums.com/mail-...html#post23345 https://www.msofficeforums.com/mail-...html#post30327 Alternatively, you may want to try a Many-to-One Mail Merge add-in from either: • Graham Mayor at: http://www.gmayor.com/ManyToOne.htm • Doug Robbins' Windows Live SkyDrive page at: https://skydrive.live.com/?cid=5aedc...615E886B%21111
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hallo macropod,
i try it, but i donīt understand. I send you web link to download my merge Word vs Excel files (seznam.cz + šablona...doc) sorry in Czech. See you to Word text box where I try to explain my problem. Many many thanks. Jerry Here is: http://www.sdhhornizlebmmdecin.czweb.org/merge/TEST.ZIP Macros in Excel, Word must be enabled... Last edited by jerry00769; 04-30-2012 at 01:04 PM. |
#4
|
||||
|
||||
Which one did you try? Have you read the tutorial and experimented with its examples? Have you looked at the examples in the links I provided? I have looked at your document and, apart from the fact that I have no idea what your document is about (I don't read Czech), I cannot see any indication that you have tried to use any of the tutorial examples.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mergefield IF/ELSE determin source type | legg1 | Mail Merge | 6 | 03-26-2012 09:18 PM |
Mail Merge to multiple .doc files named after a mergefield | nicnad | Mail Merge | 1 | 02-22-2012 01:59 AM |
Mail Merge to print specific record based on mergefield criterias | nicnad | Mail Merge | 1 | 02-22-2012 01:53 AM |
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248 | Joe Patrick | Word VBA | 2 | 01-30-2012 07:23 AM |
Mergefield date error | michielvanderbiest | Mail Merge | 1 | 04-12-2010 11:22 PM |