inicio mail me! sindicaci;ón

welcome to my space

Word Mail Merge Problem

March 13, 2010 at March 13, 2010 · Filed under enart.nnxj.comedit

  • I'm using Word XP and Access XP (2002)

    I have an access database that contains First Name, Last Name, Address, City, State, Zip, Amount, Date Entered, etc. Those are just some that are included, but the one that I'm going to focus on is Amount.

    I have my Table created and also a Query so that I can eliminate all record except for the records that were entered today Date(). I use this for creating receipts. In both the Table and Query I have my Amount field formatted as Currency and set to 2 decimal points.

    I then go into Word where I have a document already created. I enter the fields to be merged, Date, First and Last Names, Address, City, State, Zip, Amount, etc. When I display the merged information, the Amount field no longer has a currency format. Ex. $2,240.00 Displays as 2240. or if cents are involved $2,240.50 Displays as 2240.5 I cannot understand what the problem is. If I could get some help it would be greatly appreciated.

    I have attached a generic database and word document so you can see what i'm talking about.

    Thanks:)


  • I finally got it to work today. Here's what I did.

    I read at a website, that like you said, I needed to use the DDE. I was unable to get that to work, but they also said that Word 2002 didn't use that type of connection anymore so they showed me what to change to make it work the way I wanted.

    Currently displayed: <>

    Press "Alt+F9"
    That then displays {MergeField "Amount"} in place of the <> Field.

    I added this # "$#,000.00" to the field and it worked perfectly.


    Currently displayed: { MergeField "Amount" # "$#,000.00" }

    Press Alt+F9 back to the way we started ---> <>

    Fields now look like below after the merged data is displayed
    $4,500.50
    or
    $ 500.50


  • see what happens when you change the connection method.

    Go to the mail merge wizard and get to the "open data source" part, and choose DDE as the connection type if you can.


  • Alternative:

    Take your Access query and put this in another column:

    =text(format([fieldname],$0.00)

    or something similar. I forget the exact syntax.


  • I went into the open Data source part of the mail query, and under filetype looked for DDE. Nothing fount there. So I saw a tools drop down menu in the top right corner of the prompt and selected MS Query which said I didn't have DDE installed, but asked if I wanted it. I installed and went through the whole series of thing to do the way I thought they should be done and then merged the data with my table, and it removed the decimal from my Amount field now. Ex. $4,100.50-->4100.5-->4100 5

    I'm going to try somemore stuff and see what happens.

    Thanks







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Word Mail Merge Problem , Please add it free.