Fund Statement PDF Files have Extra Spaces and do not Match the MicroSoft Word Formatting Results

When using the EAdvisorStatements2007 MS Word macro to create PDF fund statement documents to upload to Donor Central the PDF documents have extra spaces in each cell, how can I delete these spaces in the PDF and make the results look more the like MS Word results?

In order to remove the extra spaces in the cells in the pdf document and other changes, you will need to edit the Normal.dotm template. The spacing is determined from the Normal.dotm document which is typically located under C:\Users\<username>\AppData\Roaming\Microsoft\Templates. You can open this document and change the line spacing options under the Paragraph section of the Home tab. When on the spacing dropdown, you can choose Line Spacing Options and select Single spacing and click the Set As Default button. This should take care of the spacing issues on the PDFs, after saving the changes to the Normal.dotm document.

You may want to create a backup copy of the normal.dotm template first just to be safe. Here is some documentation on editing the Normal.dotm template:

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.



Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.