Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
crimsonkng
 
Posts: n/a
Default Mail merge erroneously ignores populated fields in my MS-SQL datab

I can perform a successful mail merge (labels) using Word 2003's mail merge
function against my Microsoft SQL database. I get about 1,000 labels.

But when I add a "Skip Record if I_ADDR1 is blank" formula, Word skips
addresses in which I_ADDR1 is NOT blank. (It correctly skips records in
which I_ADDR1 is actually blank, too.)

I tried the same thing with ZIP. When I add the "Skip Record if I_ZIP is
blank," it gets rid of about 500 addresses when, in fact, only about 20 of
the addresses don't have a ZIP code.

Why does Word think that the fields are blank ... and how do overcome this
issue?

Thanks, in advance.

Dan
 
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
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
Mail merge and blank fields Lely Mailmerge 2 February 10th 06 02:24 PM
mail merge and text form fields Miss Su Mailmerge 1 February 4th 06 09:29 PM
Empty Mail Merge Fields Meggan Microsoft Word Help 1 January 13th 05 05:22 AM
Empty Mail Merge Fields Meggan Microsoft Word Help 0 January 13th 05 12:43 AM


All times are GMT +1. The time now is 06:15 PM.

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

About Us

"It's about Microsoft Word"