locked
Excell/Word Mail Merge Error RRS feed

  • Question

  • Hello!

    I work for a nonprofit which uses Excel as a mailing database. When someone donates, we enter the amount into a column next to their name and address and use mail merge to create a receipt.

    We recently did this but the donor (and board member!) contacted us that the donation amount showed up as $75 instead of $200 on the printed receipt sent. The Word document we have saved showed the correct amount ($200) and the Excel file shows the correct amount ($200) but the donor scanned a copy of the printed receipt they received and it definitely shows $75, the wrong amount.

    We are unsure of how this occured, how to prevent it in the future, and if more letters in this mailing were affected. Can you please help us? On our end it looks like everything was correct, yet the receipt sent showed the wrong amount.

    Thank you!

    Friday, October 7, 2016 7:34 PM

Answers

  • Hi,

    Generally, the mail merge feature is using the default Mail programs in your computer to send out the messages.

    If you are using Outlook client as the default programs, please go to your Outlook Sent Items folder, confirm if the donation amount is displayed correctly in sending items or not.

    If the amount is displayed correctly in Outlook Sent Items, please go to the recipients side, check the amount number in their Inbox folder. It helps to narrow down the issue to sender side or recipients side. Also make sure there is no currency converting in the Printed Receipt.


    Regards,

    Winnie Liang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, October 10, 2016 8:44 AM
  • For testing purposes, try sending the mailmerge output to a new document, so you can confirm it is generating the correct output - you may have a mismatch with the data columns being used for the merge, or there may be more than one record for the recipient and both need to be taken into account.

    Cheers
    Paul Edstein
    [MS MVP - Word]

    Monday, October 17, 2016 7:53 AM

All replies

  • Hi,

    Generally, the mail merge feature is using the default Mail programs in your computer to send out the messages.

    If you are using Outlook client as the default programs, please go to your Outlook Sent Items folder, confirm if the donation amount is displayed correctly in sending items or not.

    If the amount is displayed correctly in Outlook Sent Items, please go to the recipients side, check the amount number in their Inbox folder. It helps to narrow down the issue to sender side or recipients side. Also make sure there is no currency converting in the Printed Receipt.


    Regards,

    Winnie Liang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, October 10, 2016 8:44 AM
  • For testing purposes, try sending the mailmerge output to a new document, so you can confirm it is generating the correct output - you may have a mismatch with the data columns being used for the merge, or there may be more than one record for the recipient and both need to be taken into account.

    Cheers
    Paul Edstein
    [MS MVP - Word]

    Monday, October 17, 2016 7:53 AM