Hello, I am running into a problem suppressing a space that is appearing when I do a mail merge. I am using the Raiser's Edge Database's Mail function. Unfortunately, the people at Blackbaud told me they cannot help me, as the problem is in word, not the database.

I work for a school, and when we send messages to people, we include their P Years if they are parents.

This image http://tinypic.com/r/20rpppl/9 shows that I am having the database pull the field if it exists and pull the constituent's ID if it doesn't. After that, I am creating this If...Then...Else function:



IF Acknowledgee_Additional_Addressee = Acknowledgee_Constituent_ID "" Acknowledgee_Additional_Addressee

It worked great for when people had the P Year field, but when they didn't, it creates an additional space, which I can't have because sometimes these are used in the body of the letter.

I tried the following:
IF Acknowledgee_Additional_Addressee = Acknowledgee_Constituent_ID \b "" Acknowledgee_Additional_Addressee

It just left the letter b.

I am using Word 2016. Please let me know what I am doing wrong.

Thanks in advance!