Mail Merge Help!

Options

I used RE at a different job that ended June 2021. Now I'm back and trying to do a conditional mail merge through Mail. If I click on Merge, it works just fine, but if I click on Send to Word merge wizard so I can tweak the various letters, it just spins and spins and never creates the docs. What am I doing wrong? Is this part of the breakup between Blackbaud and Microsoft? I know I got out just before all of that hit the fan… Thanks!

Tagged:

Comments

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks
    BB and MS never had a break up. If anything, it is working more together.

    The “break up” you are speaking of is Blackbaud disabling the ability to open ANY application on the hosted environment. This is to enhance Blackbaud hosting security (in a sense). Since no application can be “open” other than RE FE and file explorer, you cannot do mail merge directly in RE when it requires RE to “open” MS Word.

    So first question is, is your current org's RE hosted by Blackbaud or self-hosted?

  • @Alex Wong I assume it's hosted. If I click on Merge, it takes me over to Word and I can get the letters just fine. It's only when I try to edit the original source letter docs that I have a problem. (If Send to Word Merge wizard doesn't work anymore, how do I edit those letters?)

  • Dariel Dixon 2
    Dariel Dixon 2 ✭✭✭✭✭
    Seventh Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks Are you opening them on your local version of Word? If you can access them from your local computer and not through Citrix, you shouldn't have any issue editing them.

  • @Dariel Dixon I don't think so. I go to Mail, then click on Send to Word Merge wizard. I go thru the list of letters, editing and then I click on Finish. Then I get stuck with the circle of doom…. :(

  • Dariel Dixon 2
    Dariel Dixon 2 ✭✭✭✭✭
    Seventh Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks I think you'll need to go through the many threads about how this process changed. It's been many years since then and I can't remember how we used to do it. But your current organization had to have come up with a way of doing letters before? Is there a new documented process that you can use, because like you stated these changes happened over 2 years ago.

    I think you'll find a number of threads on it, but many people have adopted a bunch of new ways to do these mail merges. Most of them are going to be exporting and performing conditional mail merges in Word themselves or automation. I would start with this thread here.

  • @Amy Horrocks If you still have a Merge button, you are most likely self-hosted. That said, if it is spinning constantly, you may be better off to export your data to a spreadsheet and merge your letters directly in Word.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks
    Don't assume, that is something you will need to know if you want to better handle your database.

    How are you accessing RE? this will give light to how your RE is hosted.

  • @Alex Wong It's not through Citrix, but something like that, I think. IT put a shortcut to it on my Desktop and I have to login with my computer credentials again – like a VPN or Remote Desktop Server or something? I don't go to blackbaud website to login or anything.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks
    This means you are likely self-hosted. Check with your IT staff.

    This also means the error you are receiving when trying to conditional merge will require your IT team to investigate as well. If you got error message, you can post it here and someone maybe able to help, but this is more on your IT team to investigate the error

  • @Alex Wong
    We are self hosted. Sounds like that means it's an internal problem? Thanks.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks
    It is not definitive that it is something internal. However, you should definitely talk to your IT team first.

    As the same time, you can post the error screenshot and message and see if others here may have hit the same issue (those that are also self hosting) that may be able to help.

  • @Alex Wong Thank you! I am attempting to do some cleanup in hopes that helps with the issue. We currently have 66 letters (!) listed as conditional Mail Merge documents. Before I delete anything, I want to confirm…

    Deleting the Mail Merge letter (let's call it "Letter2015") just removes the merge template doc. It does not affect previous gifts that used that letter. If a gift is entered in 2025, Letter2015 still appears in the drop down. When the letters are created, an error will appear – “there's no doc for Letter 2015.”

    Letter2015 will still be listed under Config>Letters>Gift section. The letter needs to be marked Inactive to remove it as a choice when entering a gift. (None of our letters are associated with a Word Merge Export.)

    I need delete the letter from the Donor Ack process (in the hope of reducing the merge processing time) AND mark it Inactive in the Config section (so it does not appear as a choice in the future).

    Right?? Thank you!

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Amy Horrocks
    if you simply want to “clean up” the selection list, then making the letter code inactive is best way to go.

    I do not know for sure if deleting will affect previously merged one using the deleted code/doc. Maybe ask BB Support will have a more straightforward answer.

Categories