Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2004

Tip: Looking for answers? Try searching our database.

Complex mail merge - help required!!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Marshall - 24 Jun 2004 13:05 GMT
Dear all,

I am trying to create a mail merge in Word that will format references
list for reports and papers. I think I need to use IF fields to get
the required result but am having trouble.

I will try and explain what I need. I have a database that can hold up
to 15 authors per reference. The punctuation that follows each author
will depend on whether there are other authors for that reference.

For example the punctuation for a solo author referece would be as
follows:
1st authors surname, 1st authors initials. Year.

The puncutation for a reference with two authors would be:
1st authors surname, first authors initials. & 2nd authors surname,
2nd authors initials. Year.

The punctuation for a reference with three authors would be:
1st authors surname, first authors initials., 2nd authors surname, 2nd
authors initials. & 3rd authors surname, 3rd authors initials. Year.

and so on . . .

So what I am trying to achive is a nested IF field that says

IF no second or third authors punctuate as in example 1, IF a second
but no third author punctuate as in example 2, IF a second and third
author puntuate as in example 3

Hope this makes sense and somebody out there can save me from
attempting to write my 3000th unsuccesful mailmerge!!!

Many thanks in advance

Paul
Graham Mayor - 24 Jun 2004 14:50 GMT
You will not be able to nest 15 conditional fields of this type. So you need
plan B. Use a selection of conditional fields all on the same line to insert
the fields and their punctuation. eg something along the lines:

{Mergefield Author1Surname}, {Mergefield Author1Initials}{IF{Mergefield
Author2Surname} <> "" " & {Mergefield Author2Surname},  {Mergefield
Author2Initials}"}{IF{Mergefield Author3Surname} <> "" " & {Mergefield
Author3Surname},  {Mergefield Author3Initials}"}{IF{Mergefield
Author4Surname} <> "" " & {Mergefield Author4Surname},  {Mergefield
Author4Initials}"}{IF{Mergefield Author5Surname} <> "" " & {Mergefield
Author5Surname},  {Mergefield Author5Initials}"} etc

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Dear all,
>
[quoted text clipped - 32 lines]
>
> Paul
Dan - 25 Jun 2004 20:25 GMT
This was helpful. Where can I find the documentation on these mailmerge options? HELP provides squat except for a few cryptic lines on IF in mergefields. I haven't seen the & concatenation operator used that way and can't find guidance on it either.

> You will not be able to nest 15 conditional fields of this type. So you need
> plan B. Use a selection of conditional fields all on the same line to insert
[quoted text clipped - 44 lines]
> >
> > Paul
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.