Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mailmerge switches (2003)

    Hello All,

    I mail merge with Word using Excel data source. I have three issues (all might be able to be solved with single correct switches) and I hope you can help:

    1. Field A contains alphanumeric data (with decimal points), for example: '0.2', '0.35 (T+1)', '0.65', '0.8'. The field is formatted as General in Excel. Strangely, the mail merged data (in Word), randomly produced more decimal places than expected. I hope to produce as they are in the data source, but they become '0.19999999999', '0.35 (T+1)', '0.65', '0.799999999999'. How do I make sure they appear as shown in the data source?

    2. Field B contains alphanumeric data, for example, '175', '3,000', 'Undisclosed'. The field is formatted as Number, Use 1000 Separator. How do I make sure the comma is displayed for data such as '3,000'?

    3. Field C contains alphanumeric data (numeric data with two decimal points), for example, '1.65', '2345.54', 'n/a', '-10.00'. The field is formatted as Number with 2 decimal place in Excel. I used '# 0.00' switch in my mail merge field and works well from <1000 numbers. How do I make sure comma appears in numbers bigger than 1000 and '0.00' is used in place of 'n/a'?

    I try to avoid doing formatting in Excel.

    Thank you all in advance.

    Regards
    Rid

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge switches (2003)

    I'm not sure it'll work for you, but try the steps outlined in <post#=434784>post 434784</post#>.

  3. #3
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mailmerge switches (2003)

    Thanks Hans,

    It indeed solves the problems. However, do you know why I was not given the chance to select different worksheet within the workbook? OLE option allows that.

    Regards
    Rid

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge switches (2003)

    DDE always uses the first worksheet in the workbook, or a named range. If you want another one, you can try the "Microsoft Excel Worksheet via Converter (*.xls, *.xlw)" option. That will give you a choice between worksheets.

Posting Permissions

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