Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mcalex mcalex is offline
external usenet poster
 
Posts: 8
Default Ignore merge field codes when field doesn't exist

Hi, I work at a charity, and we have a template letter document that prints
different receipt letters depending on different donations.

Sometimes, raffle tickets will have been purchased, and we need to add the
ticket range info to the letter. The problem is that letters without raffle
ticket information don't have ticket info fields in the data. Therefore, I
get "Error! MergeField was not found in header record of data source" errors.
Is there a way to display field data only if the field actually exists in
the data source? Something like 'if exists {mergefield firstTicket}' or '{if
{mergefield firstTicket } is not null'

thanks for any help
Using:
Word 2003
Win XP Pro
  #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 Ignore merge field codes when field doesn't exist

There is nothing that you can do as part of the built-in mail merge
functionality that can take care of that situation. However, it would be
possible to create a macro that compared the mergefields in the mail merge
main document with those in the data source and take some action in the case
of those that do not exist in the data source. Determining what that action
should be is something to which you would need to give a bit of thought
however, as just deleting (aka ignoring) the mergefield in the document, may
result in a sentence or paragraph appearing out of context or not making
sense.

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

"mcalex" wrote in message
...
Hi, I work at a charity, and we have a template letter document that
prints
different receipt letters depending on different donations.

Sometimes, raffle tickets will have been purchased, and we need to add the
ticket range info to the letter. The problem is that letters without
raffle
ticket information don't have ticket info fields in the data. Therefore,
I
get "Error! MergeField was not found in header record of data source"
errors.
Is there a way to display field data only if the field actually exists in
the data source? Something like 'if exists {mergefield firstTicket}' or
'{if
{mergefield firstTicket } is not null'

thanks for any help
Using:
Word 2003
Win XP Pro



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mcalex mcalex is offline
external usenet poster
 
Posts: 8
Default Ignore merge field codes when field doesn't exist

"Doug Robbins - Word MVP" wrote:

There is nothing that you can do as part of the built-in mail merge
functionality that can take care of that situation. However, it would be
possible to create a macro that compared the mergefields in the mail merge


Bummer, didn't think it was going to be easy. OK, I'll fire up VBA. Thanks
Doug.

mcalex

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

"mcalex" wrote in message
...
Hi, I work at a charity, and we have a template letter document that
prints
different receipt letters depending on different donations.

Sometimes, raffle tickets will have been purchased, and we need to add the
ticket range info to the letter. The problem is that letters without
raffle
ticket information don't have ticket info fields in the data. Therefore,
I
get "Error! MergeField was not found in header record of data source"
errors.
Is there a way to display field data only if the field actually exists in
the data source? Something like 'if exists {mergefield firstTicket}' or
'{if
{mergefield firstTicket } is not null'

thanks for any help
Using:
Word 2003
Win XP Pro




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
Switches/field codes to fix zip code in merge MrsMac Mailmerge 8 December 30th 07 06:48 AM
Field codes: MergeField field RTF format problem Amdious Mailmerge 4 September 17th 07 02:38 PM
Merge Field Codes accessing Content Controls Peter Tippett Microsoft Word Help 0 January 12th 07 01:47 AM
Saving word document with field results not field codes Cambdoc Microsoft Word Help 2 July 14th 06 10:51 AM
Field Codes disapearing During a mail merge Ernie Microsoft Word Help 2 April 28th 06 08:35 PM


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

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"