Link to home
Start Free TrialLog in
Avatar of Dale Fye
Dale FyeFlag for United States of America

asked on

Word mail merge line spacing for multi-line values

I've got an Access database application which performs mail merge operations with numerous Word documents and then either saves, or emails the resulting pdf files.

In the document I'm working with now, I've inserted several Word tables to assist with alignment of several columns worth of data, some of which wrap to 2 or more lines.

In the document layout, I have two of these fields displayed as below.

User generated imageEach of these values returns two lines of text, separated by a carriage return, chr$(10).

I've set the line spacing within this table as single with 0 spacing before and after paragraphs. But when the mailmerge is implemented, the line spacing converts to 1.5 spacing, which looks like:

User generated imageI know that's not great with the blurring, but what it should look like is:

User generated imagewith no additional space between lines.

I've tried saving the line spacing for the tables and the paragraphs above and below them to single spacing. But when I save that layout and then re-open the document, the 1.5 line spacing returns. 

Any ideas how to resolve this?

Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial