mailmerge, data format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam A - 13 Oct 2004 19:35 GMT

We're running a mailmerge from Excel into a Word document that is a Statement
reporting activity to licensors. This includes a column with a couple of
rows of amounts payable, followed by a total. We've formatted the mailmerge
field with "\# ##,##0.00", but the data in the column does not align
perfectly. Is there a way to ensure that it presents with all the numbers
and decimals aligned?

Reply to this Message

Doug Robbins - 14 Oct 2004 01:05 GMT

Have you tried using a decimal tab and a tab space before the mergefield?

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> We're running a mailmerge from Excel into a Word document that is a
> Statement
[quoted text clipped - 4 lines]
> perfectly. Is there a way to ensure that it presents with all the numbers
> and decimals aligned?

Reply to this Message

Adam A - 14 Oct 2004 02:06 GMT

Thanks, this was helpful in at least partially tidying up the appearance.
I'm still finding that if the amounts are of different magnitude, they don't
line up well: e.g. $1,500.00 extends further than $0.00

Adam

> Have you tried using a decimal tab and a tab space before the mergefield?
>
[quoted text clipped - 6 lines]
> > perfectly. Is there a way to ensure that it presents with all the numbers
> > and decimals aligned?

Reply to this Message

Doug Robbins - 14 Oct 2004 10:01 GMT

Maybe you need to adjust the position of the tab

Signature

> Thanks, this was helpful in at least partially tidying up the appearance.
> I'm still finding that if the amounts are of different magnitude, they
[quoted text clipped - 15 lines]
>> > numbers
>> > and decimals aligned?

Reply to this Message

Adam A - 20 Oct 2004 19:33 GMT

The tab seems to be positioned correctly. The solution that I ultimately
used was to run the mailmerge (having incorporated your suggestion of the
decimal tabs) and then edit the individual statements manually to line up the
numbers correctly. It was OK for this particular exercise, but I would like
to work out a more automated solution in the long run. I suspect that Access
may offer me a better answer, but I am not familiar enough with it yet.

Thanks for the advice.
Adam

> Maybe you need to adjust the position of the tab
>
[quoted text clipped - 17 lines]
> >> > numbers
> >> > and decimals aligned?

Reply to this Message