#16
|
||||
|
||||
Quote:
• you have have more than one FILLIN field in the document; and/or • you are using a Word template rather than a mailmerge main document. You should also have a space after the '<>' in the SKIPIF field.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#17
|
|||
|
|||
I give up its not working.... No matter how I add the fields the prompt doesn't populate the job field and the results seem to stay the same (a previous entry not updating).
To test if there was more than 1 FILLIN I deleted it and it didn't prompt me so I know there wasn't. I guess my faith in Word isn't restored |
#18
|
||||
|
||||
If you can attach the actual document to a post I'll take a look at it. Also, how are your job #s formatted?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
|||
|
|||
Hi,
Thanks that would be ideal, the job numbers are 5 digit numbers so for example 10310. File attached appreciate your help |
#20
|
||||
|
||||
OK, the reason you're getting the prompt for every record is that you have omitted the closing double-quotes before the \o switch in your FILLIN field. Hence the switch doesn't work. You have:
{ SKIPIF{ MERGEFIELD Job } <> {FILLIN "What Is The Job Number?\o}} instead of: { SKIPIF{ MERGEFIELD Job } <> {FILLIN "What Is The Job Number?" \o}} As for the job Nos., the only issue I can see is if they have leading 0s. In that case you should re-code the SKIPIF field as: { SKIPIF{ MERGEFIELD Job \# 00000} <> {FILLIN "What Is The Job Number?" \# 00000 \o}} Note also that your 'Job Number' cell won't get populated unless you have a copy of the Job MERGEFIELD there, outside the SKIPIF field. Personally, I'd prefer to keep the SKIPIF field above the table, too.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#21
|
|||
|
|||
|
#22
|
||||
|
||||
I don't understand why it wouldn't be working. I tried the exact same setup using your document and a dummy Excel data source and everything works fine.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#23
|
|||
|
|||
Is there an easy way to get copy merge field property into a document property?
|
#24
|
||||
|
||||
No. Aside from which, nothing in this thread indicates why that would be necessary.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populating Data in New TABs? | Sueade | Excel | 2 | 06-02-2015 09:12 PM |
Mail Merge Field Not Populating | JennEx | Mail Merge | 3 | 05-10-2015 09:30 PM |
Populating a table cell wit document properties | milena | Word VBA | 2 | 04-15-2015 07:28 AM |
Reapting/Populating the same text in Word 2007 | akwjaw14 | Word | 0 | 06-03-2014 03:40 PM |
Need help populating dropdown box | antztaylor | Word | 3 | 11-06-2012 05:46 PM |