Thread: [Solved] Mail Merge - Trailing Spaces
View Single Post
 
Old 12-15-2011, 01:17 PM
osucjb osucjb is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2011
Posts: 2
osucjb is on a distinguished road
Default Mail Merge - Trailing Spaces

I am working with a mail merge file, and there are two fields that I need put on the same line. The first one is between 7-10 characters, and the second field is 4 characters. If the first field is less than 10 characters, it needs to have spaces filling the rest. I have tried to write a macro to put the trailing spaces in the field before it is merged but it took off the spaces. Is there a good way to do this?
Reply With Quote