Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Address Block, no zipcode, 0 is output (word xp)

    Please help.
    I have foreign addresses in my access database and some have no postal code. When I do a Mail merge the output is 0 even though my query has no output. (Null? Or zero length string) how can I change the properties of the postcode in the mail merge wizard to allow null values or if the value is null have a blank space as output?

    Thank you in advance

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Address Block, no zipcode, 0 is ou

    I haven't used XP, but if the zip is blank, the result in Word should be blank. Would using the field with the numeric picture switch work?

    { MERGEFIELD PostalCode # "#####-####";"#####-####";# }

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •