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 / April 2008

Tip: Looking for answers? Try searching our database.

Skipping a field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ntulley - 22 Apr 2008 15:42 GMT
Here are a few of my columns: NOSUB_Text, NOSUB_FALL, NOSUB_SPRING,
FSSL_Text, FSSL_FALL, FSSL_SPRING.

What I need to do is write an if statement that would allow me to skip one
of these fields and leave it blank if it is not present in the merge document.

Example:  One day I might get all of these fields with information in it,
but the next day I will only get the NOSUB.  So, I want Write and if statment
that would skip the FSSL fields.

I would have to write the statement for each one, so in general what would
it be?

{IF Missing{FSSL_Text} ""}  ??????  The problem is, column will not show at
all in the spreadsheet if that student did not receive an FSSL award, but my
Mail Merge is set-up to catch both FSSL and NOSUB.

Thanks
Doug Robbins - Word MVP - 22 Apr 2008 20:49 GMT
If the fields do not appear in the data source, you will either have to
delete them from the mail merge main document, or have a number of mail
merge main documents each with the one of the possible collections of fields
and then use the appropriate one for the merge.

Signature

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

> Here are a few of my columns: NOSUB_Text, NOSUB_FALL, NOSUB_SPRING,
> FSSL_Text, FSSL_FALL, FSSL_SPRING.
[quoted text clipped - 18 lines]
>
> Thanks
 
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.