Mailmerge - suppressing my spaces

[MikeL91]

Help!

I received a print ready dbase file with fields called line01, line02 etc. on some of these the data is indented a few charaters with spaces to line up some totals. mailmerge is stripping off the leading spaces, how do I change that?


thanks in advance

 

[SkipVought]

Hi,

Would it help to RIGHT JUSTIFY those fields?

...and maybe ALSO change the FONT to a FIXED FONT like Courier New???

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[MikeL91]

I am using courier, and unfortunatly right justtfication real makes it worse. I have it so it shows spaces as periods on screen, and it seems like it's alltriming the field as it brings the data in because I dont see the periods at all.

 

[dcompto]

See if this will work...

ALT+F9 to toggle field codes ON
Add \* MERGEFORMAT to end of the merge fields (within the right curly bracket)
Should look like

{ line01 \* MERGEFORMAT }
{ line02 \* MERGEFORMAT }

Merge to see if it left in the leading spaces

If you have lots of fields to which you want to add \* MERGEFORMAT, use the following code...

With Selection.Find
    .ClearFormatting
    Do While .Execute(FindText:="^d", Forward:=True, _
            Format:=True) = True
    'Selection.Find.Execute
    Selection.MoveRight Unit:=wdCharacter, Count:=1
    Selection.MoveLeft Unit:=wdCharacter, Count:=1
    Selection.TypeText Text:="\* MERGEFORMAT "
    Selection.MoveRight Unit:=wdCharacter, Count:=1
    Loop
End With

Make sure your fields codes are visible (ALT+F9) before you run the macro or it will not work.

HTH

 

[macropod]

This problem sounds as if the data are numeric. If so, putting a numeric picture switch into the MERGEFIELD can be used to restore\insert leading and/or trailing 0s and/or spaces.

Suppose, for example your MERGEFIELD is:
{MERGEDIELD line01}
and line01 has a value of 1.5. If you want to make sure that line01 will be displayed as ' 1.5 ', change the MERGEFIELD to:
{MERGEDIELD line01 \# ###.##}
Similarly, to make sure that line01 will be displayed as ' 1.50', change the MERGEFIELD to:
{MERGEDIELD line01 \# ###.00}
Or, to make sure that line01 will be displayed as '01.5', change the MERGEFIELD to:
{MERGEDIELD line01 \# 00.0}
and so on.

Cheers