• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Microsoft Word Mail Merge

Please see the attached files.

I am trying to using word for a mail merge. When I start importing data, my formatting messes up. I would like to have 3 columns. Please see the "5-4-15 Before" as an example before the import takes place. And the "5-4-15 After" to give an example of what happens after the import.

I would like the sheet to be nice and clean after import with everything lining up.

Thank you!
VEHICLE-FLEET-INFORMATION-5-4-15-Before.
VEHICLE-FLEET-INFORMATION-5-4-15-After.d
0
wrt1mea
Asked:
wrt1mea
  • 2
1 Solution
 
GrahamSkanRetiredCommented:
You have several tabs and tab stops spaced 1.27 cms apart between the merge field and the first check box in each of your paragraphs.
You should remove all but the last one to be positioned at about 7.6 cms so that you only need one tab character.
You only have one stop between the two check boxes in the paragraph, but the tab character is padded out with spaces. The same thing applies to the way that the underscores are separated from the second checkbox.
I have tab stops at 7.72, 10.16 and 11.75 cms which seem to work OK.

Note that it might help to show non printing formatting marks via the Show/Hide(ΒΆ) button.

I have changed it in the first paragraph of the attached file.
VFI-5-4-15-Corrected-tabs.docx
0
 
wrt1meaAuthor Commented:
AWESOME!!!!!!!!!!

THANK YOU!!!

Especially for the explanation, as I use Word so infrequently, I was unsure about the tab stops.
0
 
wrt1meaAuthor Commented:
Boom!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now