You need to sign in to do that
Don't have an account?
Remove blank fields from a mail merged document
Hi,
I'm wondering if anyone knows of a way to remove blank fields of an MS Word mail merged document and replace them with "n/a". The salesforce fields in our mail merge template are all numerical, so I do not think I can use any rules/features of SalesForce - besides, I don't want to put in something like '9999', as this will create false data in our database. I was thinking of some VBA on the MS Word document side, but once a document has been merged, all field properties are lost...and I'm finding it difficult to move the cursor to specific positions with word. Anyone have any ideas?