Formatting a Table generated thru a DATABASE Switch

C

cleech

Hello All:
Please let me know if anyone has encountered this situation or has a
solution for it. We are using a DATABASE Switch to fill/generate a
table withing a Mail Merge letter. The table varies in the number of
records it produces for a particular letter. Specifically, we are
trying to right align the second column. (2 column table) Below is
the code being used.

{DATABASE \d "I:\\Letters.mdb" \c "TABLE tblCAPs" \s "SELECT [Name],
[Amt] FROM [tblCAPs] WHERE CD = {CD} \h}

When using this code the table is formatted automatically and left
aligned. I've tried using /*MERGEFORMAT and right aligning the
column. This works until the number of records starts changing.

That's pretty much the gist of it. Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top