Thread: Mail Merge format both Rt & Lf align on same row

OFFICE 2000

I have an excel macro that organizes data, opens Word so a Mail Merge can be performed.

(I haven't been able to figure out how to automate the Tools > Mail Merge > Merge > Merge so the user must click thru these steps manually.)

I'd like to add another field to my label but there aren't any lines available so I must add it adjacent to an existing field.

LABEL LIKE:
«Field1»
.....«Field2»............«Field3»
«Field4»......«Field5»


Fields 2 & 3 row is okay because they always both same number of digits, so 12 spaces between works

Field 4 is varying length I would like Field 4 Left Aligned and Field5 Right Aligned
LIKE:
«Field1»
.....«Field2»............«Field3»
«Field4».................«Field5»