locked
Multiplication in Mail Merge RRS feed

  • Question

  • I have tried to create an equation in Word 2010 using a 2010 excel spreadsheet. Below is my equation:

    {=<<Product_1_Quantity>>*<<Product_2_Quantity>>}

    When I run the mail merge to PDF it returns:

    {=1*2}

    So it returns the correct fields but doesn't do the multiplication.

    Anyone have any ideas?? Thanks in advance!!



    • Edited by D Reimer Friday, June 15, 2012 3:34 PM
    Friday, June 15, 2012 3:33 PM

Answers

  • Did you type the { and } yourself? That won't work. Field brackets { } should be inserted by pressing Ctrl+F9. After entering the formula

    =<<Product_1_Quantity>>*<<Product_2_Quantity>>

    between the brackets, press F9 to hide the field code and to update its result.


    Regards, Hans Vogelaar

    • Marked as answer by Jaynet Zhang Wednesday, June 20, 2012 1:42 AM
    Friday, June 15, 2012 5:16 PM

All replies