#1
|
|||
|
|||
Empty rules
I have te next mergefields in a document Aan «Client_tenaamstelling» «Client_PA_tenaamstelling» «Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» Sometimes the field <<Client_PA_tenaamstelling>> is empty, but there is stil a empty rule. In that case i want this: Aan «Client_tenaamstelling» «Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» How do i do that |
#2
|
||||
|
||||
Hi rene,
First, select your «Client_PA_tenaamstelling» and press Shift-F9. You should see something like: Code:
{Mergefield Client_PA_tenaamstelling} Code:
{Mergefield Client_PA_tenaamstelling \f "¶ "} Finally, delete the paragraph break or a line break between «Client_PA_tenaamstelling» and «Client_tenaamstelling», so that you end up with: «Client_PA_tenaamstelling»«Client_tenaamstelling» on one line.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
empty rules
Dear Paul,
Thank you for your answer. It works but now i'm getting the «Client_tenaamstelling»«Client_PA_tenaamstelling» on one line when both are filled |
#4
|
||||
|
||||
Hi rene,
Have you executed the merge? You should only see «Client_tenaamstelling»«Client_PA_tenaamstelling» in the mailmerge main document. After merging, these should be replaced in the output document by the data.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Empty rules
Paul,
Ik did see it after merge en than i see e.g. De heer R. Kamphuis p.a. K. Karelsen Beethovenstraat 16 7897 AA Almelo I want to see De heer R. Kamphuis p.a. K. Karelsen Beethovenstraat 16 7897 AA Almelo |
#6
|
||||
|
||||
Hi rene,
Can you attach a copy of your mailmerge main document to a post (delete any sensitive material first)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Paul,
Normally it is a dot |
#8
|
||||
|
||||
Hi rene,
I see what's wrong - you need to re-insert the paragraph break between «Client_PA_tenaamstelling» and «Client_tenaamstelling», and delete the one between «Client_tenaamstelling» and «Client_PA_adres»
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Hi Paul,
But it must be like this: «Client_tenaamstelling» «Client_PA_tenaamstelling» «Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» and not «Client_tenaamstelling» «Client_PA_adres» «Client_PA_tenaamstelling» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» |
#10
|
||||
|
||||
Hi Rene,
Set the fields out as: «Client_tenaamstelling» «Client_PA_tenaamstelling»«Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» If «Client_PA_tenaamstelling» has data, you should get: «Client_tenaamstelling» «Client_PA_tenaamstelling» «Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land» If «Client_PA_tenaamstelling» is empty, you should get: «Client_tenaamstelling» «Client_PA_adres» «Client_PA_postcode» «Client_PA_woonplaats» «Client_PA_land»
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Hi Paul,
Again thank you for your help, i put an doc with paint printscreens within as an attechment. I think i don't get it right. Would you look in the attechment. |
#12
|
||||
|
||||
Hi rene,
The grey field shading in your document suggests it's from a preview of the merge. The field coding won't take effect until you execute (finish) the merge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
Hi Paul,
The gray shading is because i have defiend that mergefields must be marked. (via options, arcering field, always). |
#14
|
||||
|
||||
Hi reneThat may be so but, once you execute (finish) the merge, those fields won't be there in the outupt document - they will have been replaced by the records from your datasource. All you're doing now is previewing the merge. To execute (finish) the merge, you need to click on the 'Merge' (Word 97-2003) or 'Finish & Merge' (Word 2007+). Until you do that, you will never get beyond the preview stage.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
In this database programm (GINO) i go to the functionality 'make sjablone'. There i choose the mergefields, than through GINO MS word wil execute; in MS Word i make text en place the mergefields. Than through GINO i save the sjablone.
Then the normal user recalls in GINO the sjablone, says 'fill' en then the sjablone fils en opens MS Word. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2007 Disappearing/empty emails | Hexasphere | Outlook | 0 | 02-21-2011 03:50 AM |
Shared Calendar Empty | worksmart | Outlook | 0 | 01-21-2011 06:32 AM |
Question about Tools>Rules and Alerts>E-mail Rules | RichGuard | Outlook | 0 | 09-02-2010 05:19 PM |
Populate an empty .PAB file | imported_contiw | Outlook | 2 | 08-17-2006 08:50 PM |