Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (Word 2002)

    I didn't know how to send you two attachments. So here is what I did. In the attachment - Cells A1 - G10 is my data source. Cells A15 - A23 is my form letter. I copied my form letter into excel so you could see how it was setup in Word 2002. When I do a mail merge - the Apt field gives me a 0 if there was data in the Apt field. If it was empty - nothing shows up. That is my problem. When I open up my form letter I received this funny message - Opening this document will run the following SQL command: SELECT *FROM 'Sheet1$' WHERE ;Apt' IS NULL Data from your database will be placed in the document. Do you want to continue? I say Yes.

    Help???
    Attached Files Attached Files

  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 (Word 2002)

    I don't have Word 2002, but in looking at your Apt column, I notice that the column is formatted for social security number. Try formatting it for text (select it, press Ctrl+1, & choose Text) & see if that helps.
    Cheers,

Posting Permissions

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