Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
tinkerbelle tinkerbelle is offline
external usenet poster
 
Posts: 3
Default Punctuating properly when mailmerging

I am currently writing a letter which includes for example, up to 3 different
deductions and rates. I have made the three mailmerge if formulas to only
bring through the ones that should be deducted but when I read the letter it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Punctuating properly when mailmerging

Yes, it should be possible with the use of If...then...Else field
constructions. However, if the data source was an Access table, I would be
more inclined to use IF() functions in an Access Query to get the result
rather than do it in the mailmerge main document.

--
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

"tinkerbelle" wrote in message
...
I am currently writing a letter which includes for example, up to 3
different
deductions and rates. I have made the three mailmerge if formulas to only
bring through the ones that should be deducted but when I read the letter
it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
tinkerbelle tinkerbelle is offline
external usenet poster
 
Posts: 3
Default Punctuating properly when mailmerging

Hi I am using excel for the data, please could you explain the if..then..else
funstion as it is one i am not familiar with.

Thanks - Sarah

"Doug Robbins - Word MVP" wrote:

Yes, it should be possible with the use of If...then...Else field
constructions. However, if the data source was an Access table, I would be
more inclined to use IF() functions in an Access Query to get the result
rather than do it in the mailmerge main document.

--
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

"tinkerbelle" wrote in message
...
I am currently writing a letter which includes for example, up to 3
different
deductions and rates. I have made the three mailmerge if formulas to only
bring through the ones that should be deducted but when I read the letter
it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Punctuating properly when mailmerging

{ IF { MERGEFIELD Tax } 0 { IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax }, { MERGEFIELD Ni } and { MERGEFIELD
Pension }" "{ MERGEFIELD Tax } and { MERGEFIELD Ni }" }{ IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax } and { MERGEFIELD Pension }" "{ MERGEFIELD
Tax }" }{ IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD Pension } 0 "{
MERGEFIELD Ni } and { MERGEFIELD Pension }" "{ MERGEFIELD Ni }"} { IF {
MERGEFIELD Pension } 0 "{ MERGEFIELD Pension }" "" }}

You must use Ctrl+F9 to insert each pair of the field delimiters { } and you
use Alt+F9 to toggle off their display.

--
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

"tinkerbelle" wrote in message
news
Hi I am using excel for the data, please could you explain the
if..then..else
funstion as it is one i am not familiar with.

Thanks - Sarah

"Doug Robbins - Word MVP" wrote:

Yes, it should be possible with the use of If...then...Else field
constructions. However, if the data source was an Access table, I would
be
more inclined to use IF() functions in an Access Query to get the result
rather than do it in the mailmerge main document.

--
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

"tinkerbelle" wrote in message
...
I am currently writing a letter which includes for example, up to 3
different
deductions and rates. I have made the three mailmerge if formulas to
only
bring through the ones that should be deducted but when I read the
letter
it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
tinkerbelle tinkerbelle is offline
external usenet poster
 
Posts: 3
Default Punctuating properly when mailmerging

Hi Doug, Thanks for you help, however after turning your message below into
the fields in word, I got an error, i think this is because there are
different amounts of Open brackets to closed brackets.

I have tried to make it work but i just get errors.

Any chance you could have a quick look at where the other brackets should be??

Thanks for you time and help - Sarah

"Doug Robbins - Word MVP" wrote:

{ IF { MERGEFIELD Tax } 0 { IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax }, { MERGEFIELD Ni } and { MERGEFIELD
Pension }" "{ MERGEFIELD Tax } and { MERGEFIELD Ni }" }{ IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax } and { MERGEFIELD Pension }" "{ MERGEFIELD
Tax }" }{ IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD Pension } 0 "{
MERGEFIELD Ni } and { MERGEFIELD Pension }" "{ MERGEFIELD Ni }"} { IF {
MERGEFIELD Pension } 0 "{ MERGEFIELD Pension }" "" }}

You must use Ctrl+F9 to insert each pair of the field delimiters { } and you
use Alt+F9 to toggle off their display.

--
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

"tinkerbelle" wrote in message
news
Hi I am using excel for the data, please could you explain the
if..then..else
funstion as it is one i am not familiar with.

Thanks - Sarah

"Doug Robbins - Word MVP" wrote:

Yes, it should be possible with the use of If...then...Else field
constructions. However, if the data source was an Access table, I would
be
more inclined to use IF() functions in an Access Query to get the result
rather than do it in the mailmerge main document.

--
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

"tinkerbelle" wrote in message
...
I am currently writing a letter which includes for example, up to 3
different
deductions and rates. I have made the three mailmerge if formulas to
only
bring through the ones that should be deducted but when I read the
letter
it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah








  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Punctuating properly when mailmerging

I believe that there are a couple of missing closing }} at the end of what
I posted, so that the field construction should look like:

{ IF { MERGEFIELD Tax } 0 { IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax }, { MERGEFIELD Ni } and { MERGEFIELD
Pension }" "{ MERGEFIELD Tax } and { MERGEFIELD Ni }" }{ IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax } and { MERGEFIELD Pension }" "{ MERGEFIELD
Tax }" }{ IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD Pension } 0 "{
MERGEFIELD Ni } and { MERGEFIELD Pension }" "{ MERGEFIELD Ni }"} { IF {
MERGEFIELD Pension } 0 "{ MERGEFIELD Pension }" "" }}}}


However, if you used Ctrl+F9 to insert the field delimiters, they will be
balanced as each time you use Ctrl+F9, a pair of field delimiters is
inserted.

Another thing however is that it is necessary to have a space either side of
each operator.

--
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

"tinkerbelle" wrote in message
...
Hi Doug, Thanks for you help, however after turning your message below
into
the fields in word, I got an error, i think this is because there are
different amounts of Open brackets to closed brackets.

I have tried to make it work but i just get errors.

Any chance you could have a quick look at where the other brackets should
be??

Thanks for you time and help - Sarah

"Doug Robbins - Word MVP" wrote:

{ IF { MERGEFIELD Tax } 0 { IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax }, { MERGEFIELD Ni } and { MERGEFIELD
Pension }" "{ MERGEFIELD Tax } and { MERGEFIELD Ni }" }{ IF { MERGEFIELD
Pension } 0 "{ MERGEFIELD Tax } and { MERGEFIELD Pension }" "{
MERGEFIELD
Tax }" }{ IF { MERGEFIELD Ni } 0 { IF { MERGEFIELD Pension } 0 "{
MERGEFIELD Ni } and { MERGEFIELD Pension }" "{ MERGEFIELD Ni }"} { IF {
MERGEFIELD Pension } 0 "{ MERGEFIELD Pension }" "" }}

You must use Ctrl+F9 to insert each pair of the field delimiters { } and
you
use Alt+F9 to toggle off their display.

--
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

"tinkerbelle" wrote in message
news
Hi I am using excel for the data, please could you explain the
if..then..else
funstion as it is one i am not familiar with.

Thanks - Sarah

"Doug Robbins - Word MVP" wrote:

Yes, it should be possible with the use of If...then...Else field
constructions. However, if the data source was an Access table, I
would
be
more inclined to use IF() functions in an Access Query to get the
result
rather than do it in the mailmerge main document.

--
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

"tinkerbelle" wrote in message
...
I am currently writing a letter which includes for example, up to 3
different
deductions and rates. I have made the three mailmerge if formulas
to
only
bring through the ones that should be deducted but when I read the
letter
it
doesnt entirely make sense as it has not commas or "and"

At the moment i get

#% Tax #% NI #% Pension

What I would like is;

#% Tax, #% NI and #% Pension
or
#% Tax and #%NI
or
#% Tax and #% Pension
or
#%NI and #% Pension

Please could someone tell me if this is possible??

Thanks for your help - sarah








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerging Hettie143 Mailmerge 1 June 2nd 06 08:20 PM
Mailmerging graphics .... Ian P Mailmerge 0 May 14th 05 03:15 AM
Mail Merge not running properly from Access Function but runs properly when opened manually Brian Alley Mailmerge 1 February 22nd 05 12:58 AM
mailmerging question ap2sweet Mailmerge 2 December 30th 04 07:59 AM
mailmerging question indmax21 Mailmerge 1 December 28th 04 04:16 PM


All times are GMT +1. The time now is 12:47 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"