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  

suppress invalid merge field word 2003



 
 
Thread Tools Display Modes
  #1  
Old December 7th, 2004, 05:17 PM
Mike
external usenet poster
 
Posts: n/a
Default suppress invalid merge field word 2003

My users had created several generic mail merge documents in Word 97, now we
have upgraded to Office 2003. Remember, these are generic mail merge
documents - not every field is used for every merge

On 97, if there mail merge field was not used for this particular merge, the
document printed fine. Now, on 2003, they receive an "invalid mail merge
field" error. Yes, they can get past it and everything prints fine, but it
is annoying.

Any suggestions on how to suppress this message?

Thanks,
Mike
  #2  
Old December 8th, 2004, 01:30 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

Hi =?Utf-8?B?TWlrZQ==?=,

My users had created several generic mail merge documents in Word 97, now we
have upgraded to Office 2003. Remember, these are generic mail merge
documents - not every field is used for every merge

On 97, if there mail merge field was not used for this particular merge, the
document printed fine. Now, on 2003, they receive an "invalid mail merge
field" error. Yes, they can get past it and everything prints fine, but it
is annoying.

Any suggestions on how to suppress this message?

When you say "not every merge field is used" what, more exactly, do you mean?

The fields are in the document and in the data source, but contain no data?

The fields are in the document, but not in the data source?

If the problem is the latter, then there's nothing you can do. The field is in
the merge document and Word will look for a corresponding field in the data
source. You'd have to make sure the data source contains all the fields, even
if the content is null (best is to pass an empty string).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

  #3  
Old December 8th, 2004, 09:03 PM
Mike
external usenet poster
 
Posts: n/a
Default

Cindy,

Thank you for the response, see below.

"Cindy M -WordMVP-" wrote:

When you say "not every merge field is used" what, more exactly, do you mean?

The fields are in the document and in the data source, but contain no data?


I believe this is the case - the fields are in the document and data source,
but they are null.

Thanks!
  #4  
Old December 9th, 2004, 11:13 AM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

Hi =?Utf-8?B?TWlrZQ==?=,

When you say "not every merge field is used" what, more exactly, do you mean?

the fields are in the document and data source,
but they are null.

What's the data source? Any chance you could pass an empty string "" rather than
null?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exchange 2003 - Outlook 2003 - Word 2003 mail merge Micheline Mailmerge 1 December 2nd, 2004 11:51 AM
Word 2000/2002 - Proper Mail Merge steps for ODBC? Tony_VBACoder Mailmerge 7 September 2nd, 2004 09:21 PM
word error mac General Discussions 1 May 6th, 2004 08:14 AM
Mail merge data source can't be saved word 2003 richie Mailmerge 3 April 29th, 2004 09:24 AM
Word 2003 is adding duplicate records to my mail merge Doug Robbins - Word MVP Mailmerge 0 April 24th, 2004 03:58 AM


All times are GMT +1. The time now is 09:44 PM.


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