Mail Merge - Trailing Spaces

[osucjb]

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?