Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge changes data (Office 2000)

    I'm merging a spreadsheet that has some columns with mixed values; most are financial values, but some are text ("priceless"). Another column has mostly text, with a few cells containing dollar values. I started out formatting these as "accounting".

    However, when I merged them into a Word document, the values in these columns changed. Some fields that should be "priceless" are instead picking up a value from the cell above or below. In another column, cells containing the word "none" merge just fine, but those containing dollar values show up as a blank field.

    I changed the format in just the affected cells to Text, but that didn't fix it, so I changed the format for the entire column to Text. That didn't fix it, either. Any idea why this is happening and how I can fix it?

    Elena
    elena@enerjazz.com

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Mail merge changes data (Office 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Elena

    When you say Merge into word, are you using the mail merge facility of MS-Word or do you mean you have fields setup in the document that refresh from the MS-Excel workbook?

    Or re-reading your post, I think you are copying and pasting into a MS-Word table?

    Which of these cases is true?

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge changes data (Office 2000)

    No, I'm using Word to do the merge. Deleting "MERGEFIELD" from the field definition brings over the data as shown in Excel, but then it also carries the Excel formatting -- not what I want. I want the data to come over uncorrupted, then to take on the formatting I created in the Word merge formatting file.

    The latest bug is that now the merge process is adding ".0" to the numerical fields, even if they're defined as "general" or "text". One of those fields was compiled using Excel's data fill function, so I figured the trailing zero was related to that function. However, now the same thing is happening with a typed (not computed) field.

    Aaargh!

    Thanks for your help--
    Elena

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Mail merge changes data (Office 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Elena

    My suggestion to you is to paste the table from Excel into Word as an Excel Object and do the formatting that you want in Excel.

    But I guess you would get better help in the MS-Word Lounge.

    Best of luck

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Mail merge changes data (Office 2000)

    Can you post a sample worksheet? Change your data if necessary.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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