A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text appears when the fields are blank



 
 
Thread Tools Display Modes
  #1  
Old March 31st, 2010, 05:57 PM posted to microsoft.public.word.mailmerge.fields
Lester Lane[_2_]
external usenet poster
 
Posts: 8
Default Text appears when the fields are blank

Hi, I'm not sure if I have the right approach to this problem but here
goes:

I can have up to 5 sets of fields with each set consisting of 3 fields
per record. Some records only have say 3 sets. On the letter each
set is a separate line. For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with some
of the text buried within the merge formula. How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed please?

{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName /f ""} valued at
£{ MERGEFIELD M_2CurrentValue }" "valued at £{ MERGEFIELD
M_2CurrentValue} }

Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at
£4,064.75
Remainder as Cash valued at £200.00

Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at £[4,064.75]
[Remainder as Cash] valued at [£200.00]

Blank lines that should be supressed show:
shares in valued at £

which is that same if I had the text part outside the IF statement
  #2  
Old March 31st, 2010, 10:29 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Text appears when the fields are blank

I think that your construction should be:

"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD "M_2Shares" /f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "valued at £{ MERGEFIELD
M_2CurrentValue}" }

But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message
...
Hi, I'm not sure if I have the right approach to this problem but here
goes:

I can have up to 5 sets of fields with each set consisting of 3 fields
per record. Some records only have say 3 sets. On the letter each
set is a separate line. For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with some
of the text buried within the merge formula. How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed please?

{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName /f ""} valued at
£{ MERGEFIELD M_2CurrentValue }" "valued at £{ MERGEFIELD
M_2CurrentValue} }

Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at
£4,064.75
Remainder as Cash valued at £200.00

Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at £[4,064.75]
[Remainder as Cash] valued at [£200.00]

Blank lines that should be supressed show:
shares in valued at £

which is that same if I had the text part outside the IF statement


  #3  
Old April 1st, 2010, 10:54 AM posted to microsoft.public.word.mailmerge.fields
Lester Lane[_2_]
external usenet poster
 
Posts: 8
Default Text appears when the fields are blank

On 31 Mar, 22:29, "Doug Robbins - Word MVP"
wrote:
I think that your construction should be:

"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD "M_2Shares" /f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }

But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

Hi, I'm not sure if I have the right approach to this problem but here
goes:


I can have up to 5 sets of fields with each set consisting of 3 fields
per record. *Some records only have say 3 sets. *On the letter each
set is a separate line. *For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with some
of the text buried within the merge formula. *How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName */f ""} valued at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in *valued at


which is that same if I had the text part outside the IF statement


Brilliant, thanks. I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }

"Remainder as Cash" was in the Shares field but now I can remove this
and leave the field blank, which is neater. However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. Any ideas on that please?
  #4  
Old April 1st, 2010, 10:33 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Text appears when the fields are blank

I am assuming that what you want to suppress is a blank line. To do that,
start the field construction at the end of the previous line and insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction

{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName /f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue } 0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }


--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message
...
On 31 Mar, 22:29, "Doug Robbins - Word MVP"
wrote:
I think that your construction should be:

"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD "M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }

But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

Hi, I'm not sure if I have the right approach to this problem but here
goes:


I can have up to 5 sets of fields with each set consisting of 3 fields
per record. Some records only have say 3 sets. On the letter each
set is a separate line. For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with some
of the text buried within the merge formula. How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName /f ""} valued at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in valued at


which is that same if I had the text part outside the IF statement


Brilliant, thanks. I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }

"Remainder as Cash" was in the Shares field but now I can remove this
and leave the field blank, which is neater. However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. Any ideas on that please?


  #5  
Old April 6th, 2010, 03:08 PM posted to microsoft.public.word.mailmerge.fields
Lester Lane[_2_]
external usenet poster
 
Posts: 8
Default Text appears when the fields are blank

On 1 Apr, 22:33, "Doug Robbins - Word MVP"
wrote:
I am assuming that what you want to suppress is a blank line. *To do that,
start the field construction at the end of the previous line and insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction

{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName */f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue } 0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

On 31 Mar, 22:29, "Doug Robbins - Word MVP"
wrote:
I think that your construction should be:


"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD "M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }


But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


....


Hi, I'm not sure if I have the right approach to this problem but here
goes:


I can have up to 5 sets of fields with each set consisting of 3 fields
per record. *Some records only have say 3 sets. *On the letter each
set is a separate line. *For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with some
of the text buried within the merge formula. *How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName */f ""} valued at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in *valued at


which is that same if I had the text part outside the IF statement


Brilliant, thanks. *I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }


"Remainder as Cash" was in the Shares field but now I can remove this
and leave the field blank, which is neater. *However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. *Any ideas on that please?


Not quite. The above suggestion gives me extra blank rows. I have
noticed that if on each line I simply have say the Shares field so the
first line is {MERGEFIELD M_1Shares} and the 5th line has {MERGEFIELD
M_5Shares} if the 4th and 5th Shares fields are blank then lines 4 and
5 do not appear at all. They are not blank, they simply vanish. If I
swap the simple merge fields for the complex IF statement then lines 4
and 5 are there but they are blank. Ideally I would like them to
"vanish" also. Hope that is clearer.
  #6  
Old April 6th, 2010, 10:21 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Text appears when the fields are blank

It will be easier to sort this out if you can send me the mail merge main
document and some "dummy" records that cover the range of combinations of
data that you are trying to handle.

You can send it to dkr[atsymbol]mvps[dot]org

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message
...
On 1 Apr, 22:33, "Doug Robbins - Word MVP"
wrote:
I am assuming that what you want to suppress is a blank line. To do
that,
start the field construction at the end of the previous line and insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction

{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName
/f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue }
0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

On 31 Mar, 22:29, "Doug Robbins - Word MVP"
wrote:
I think that your construction should be:


"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
"M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }


But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


Hi, I'm not sure if I have the right approach to this problem but
here
goes:


I can have up to 5 sets of fields with each set consisting of 3
fields
per record. Some records only have say 3 sets. On the letter each
set is a separate line. For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with
some
of the text buried within the merge formula. How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed
please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName /f ""} valued
at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued
at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in valued at


which is that same if I had the text part outside the IF statement


Brilliant, thanks. I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }


"Remainder as Cash" was in the Shares field but now I can remove this
and leave the field blank, which is neater. However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. Any ideas on that please?


Not quite. The above suggestion gives me extra blank rows. I have
noticed that if on each line I simply have say the Shares field so the
first line is {MERGEFIELD M_1Shares} and the 5th line has {MERGEFIELD
M_5Shares} if the 4th and 5th Shares fields are blank then lines 4 and
5 do not appear at all. They are not blank, they simply vanish. If I
swap the simple merge fields for the complex IF statement then lines 4
and 5 are there but they are blank. Ideally I would like them to
"vanish" also. Hope that is clearer.


  #7  
Old April 12th, 2010, 08:17 PM posted to microsoft.public.word.mailmerge.fields
Lester Lane[_2_]
external usenet poster
 
Posts: 8
Default Text appears when the fields are blank

On 6 Apr, 22:21, "Doug Robbins - Word MVP"
wrote:
It will be easier to sort this out if you can send me the mail merge main
document and some "dummy" records that cover the range of combinations of
data that you are trying to handle.

You can send it to dkr[atsymbol]mvps[dot]org

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

On 1 Apr, 22:33, "Doug Robbins - Word MVP"
wrote:
I am assuming that what you want to suppress is a blank line. *To do
that,
start the field construction at the end of the previous line and insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction


{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName
/f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue }
0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }


--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


....


On 31 Mar, 22:29, "Doug Robbins - Word MVP"
wrote:
I think that your construction should be:


"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
"M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }


But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash " comes.
--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


Hi, I'm not sure if I have the right approach to this problem but
here
goes:


I can have up to 5 sets of fields with each set consisting of 3
fields
per record. *Some records only have say 3 sets. *On the letter each
set is a separate line. *For the 4th and 5th sets rather than get a
supressed row if I simply had one field on its own I end up with
some
of the text buried within the merge formula. *How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed
please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName */f ""} valued
at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued
at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in *valued at


which is that same if I had the text part outside the IF statement


Brilliant, thanks. *I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }


"Remainder as Cash" was in the Shares field but now I can remove this
and leave the field blank, which is neater. *However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. *Any ideas on that please?


Not quite. *The above suggestion gives me extra blank rows. *I have
noticed that if on each line I simply have say the Shares field so the
first line is {MERGEFIELD M_1Shares} and the 5th line has {MERGEFIELD
M_5Shares} if the 4th and 5th Shares fields are blank then lines 4 and
5 do not appear at all. *They are not blank, they simply vanish. *If I
swap the simple merge fields for the complex IF statement then lines 4
and 5 are there but they are blank. *Ideally I would like them to
"vanish" also. *Hope that is clearer.


Thanks for the offer but I can't get your email to work - even with uk
at the end...
  #8  
Old April 12th, 2010, 10:25 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Text appears when the fields are blank

Replace the parts inside the [ ] with the obvious

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message
...
On 6 Apr, 22:21, "Doug Robbins - Word MVP"
wrote:
It will be easier to sort this out if you can send me the mail merge main
document and some "dummy" records that cover the range of combinations of
data that you are trying to handle.

You can send it to dkr[atsymbol]mvps[dot]org

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

On 1 Apr, 22:33, "Doug Robbins - Word MVP"
wrote:
I am assuming that what you want to suppress is a blank line. To do
that,
start the field construction at the end of the previous line and
insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction


{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName
/f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue }

0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }


--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


On 31 Mar, 22:29, "Doug Robbins - Word MVP"

wrote:
I think that your construction should be:


"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
"M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }


But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash "
comes.
--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


Hi, I'm not sure if I have the right approach to this problem but
here
goes:


I can have up to 5 sets of fields with each set consisting of 3
fields
per record. Some records only have say 3 sets. On the letter
each
set is a separate line. For the 4th and 5th sets rather than get
a
supressed row if I simply had one field on its own I end up with
some
of the text buried within the merge formula. How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed
please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD
M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName /f ""}
valued
at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI)
valued
at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in valued at


which is that same if I had the text part outside the IF
statement


Brilliant, thanks. I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName /f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }


"Remainder as Cash" was in the Shares field but now I can remove
this
and leave the field blank, which is neater. However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. Any ideas on that please?


Not quite. The above suggestion gives me extra blank rows. I have
noticed that if on each line I simply have say the Shares field so the
first line is {MERGEFIELD M_1Shares} and the 5th line has {MERGEFIELD
M_5Shares} if the 4th and 5th Shares fields are blank then lines 4 and
5 do not appear at all. They are not blank, they simply vanish. If I
swap the simple merge fields for the complex IF statement then lines 4
and 5 are there but they are blank. Ideally I would like them to
"vanish" also. Hope that is clearer.


Thanks for the offer but I can't get your email to work - even with uk
at the end...


  #9  
Old April 13th, 2010, 10:55 AM posted to microsoft.public.word.mailmerge.fields
Lester Lane[_2_]
external usenet poster
 
Posts: 8
Default Text appears when the fields are blank

On 12 Apr, 22:25, "Doug Robbins - Word MVP"
wrote:
Replace the parts inside the [ ] with the obvious

--
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, originally posted via msnews.microsoft.com

"Lester Lane" wrote in message

...

On 6 Apr, 22:21, "Doug Robbins - Word MVP"
wrote:
It will be easier to sort this out if you can send me the mail merge main
document and some "dummy" records that cover the range of combinations of
data that you are trying to handle.


You can send it to dkr[atsymbol]mvps[dot]org


--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


....


On 1 Apr, 22:33, "Doug Robbins - Word MVP"
wrote:
I am assuming that what you want to suppress is a blank line. *To do
that,
start the field construction at the end of the previous line and
insert a
carriage return (or Shift +Enter) where the ¶ appears in the following
construction


{ IF { MERGEFIELD M_2InvestmentName } "cash" "¶
{ MERGEFIELD M_2Shares /f " shares in "}{ MERGEFIELD M_2InvestmentName
/f "
valued at
£"}{ MERGEFIELD M_2CurrentValue }" { IF { MERGEFIELD M_2CurrentValue }

0

Cash valued at £{ MERGEFIELD M_2CurrentValue}" "" } }


--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


On 31 Mar, 22:29, "Doug Robbins - Word MVP"

wrote:
I think that your construction should be:


"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
"M_2Shares"
/f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
"}{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue}" }


But, I am not sure about the negative result because in your field
construction, I do not see from where the "Remainder as Cash "
comes.
--
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, originally posted via msnews.microsoft.com


"Lester Lane" wrote in message


...


Hi, I'm not sure if I have the right approach to this problem but
here
goes:


I can have up to 5 sets of fields with each set consisting of 3
fields
per record. *Some records only have say 3 sets. *On the letter
each
set is a separate line. *For the 4th and 5th sets rather than get
a
supressed row if I simply had one field on its own I end up with
some
of the text buried within the merge formula. *How can I change my
approach/formula to make sure rows 4 & 5 are totally supressed
please?


{ MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD
M_2InvestmentName }
"cash" " shares in { MERGEFIELD M_2InvestmentName */f ""}
valued
at
{ MERGEFIELD M_2CurrentValue }" "valued at { MERGEFIELD
M_2CurrentValue} }


Correct displays include:
9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI)
valued
at
4,064.75
Remainder as Cash valued at 200.00


Using [] to show field data:
[9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)]
valued at [4,064.75]
[Remainder as Cash] valued at [ 200.00]


Blank lines that should be supressed show:
shares in *valued at


which is that same if I had the text part outside the IF
statement


Brilliant, thanks. *I now understand the /f part and how to edit it!
I ended up with:
"{ IF { MERGEFIELD M_2InvestmentName } "cash" "{ MERGEFIELD
M_2Shares /f
" shares in "}{ MERGEFIELD M_2InvestmentName */f " valued at
£"}{ MERGEFIELD M_2CurrentValue }" "Cash valued at £{ MERGEFIELD
M_2CurrentValue}" }


"Remainder as Cash" was in the Shares field but now I can remove
this
and leave the field blank, which is neater. *However I still don't
have this formulae able to supress itself if there is nothing in any
of the 3 fields. *Any ideas on that please?


Not quite. *The above suggestion gives me extra blank rows. *I have
noticed that if on each line I simply have say the Shares field so the
first line is {MERGEFIELD M_1Shares} and the 5th line has {MERGEFIELD
M_5Shares} if the 4th and 5th Shares fields are blank then lines 4 and
5 do not appear at all. *They are not blank, they simply vanish. *If I
swap the simple merge fields for the complex IF statement then lines 4
and 5 are there but they are blank. *Ideally I would like them to
"vanish" also. *Hope that is clearer.


Thanks for the offer but I can't get your email to work - even with uk
at the end...


Ironically it would seem that your postmaster does not like Word
attachments!! I have put them in a zip....
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.