Hi
I am using the DATABASE field code to get some data from an Access DB
into a document which I am Mail Merging.
For info the DATABASE query is :
DATABASE \d
"C:\\Tempo\\MailMergeSource\\database\\DocumentVariableData.mdb " \c
"DSN=MS Access Database; DBQ=
C:\\Tempo\\MailMergeSource\\database\\DocumentVariableData.mdb;
FIL=RedISAM" \s " SELECT COLUMN_1,' ',COLUMN_2 FROM DOCUMENT_ROWS
ORDER BY DOCUMENT_SECTION_ID " \l "0" \* CharFormat
This returns itemised invoice lines.
COLUMN_2 holds financial figures and I need this column to be
right-justified. Is there a way to do this ?
TIA
dave.
Cindy M. - 22 Sep 2006 10:21 GMT
> I am using the DATABASE field code to get some data from an Access DB
> into a document which I am Mail Merging.
[quoted text clipped - 12 lines]
> COLUMN_2 holds financial figures and I need this column to be
> right-justified. Is there a way to do this ?
In Word 2003 it works for me to use \* MergeFormat (NOT \* CharFormat)
then apply the paragraph format right-align to the column.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)