Well, none of those methods are really adequate, or they require more time to
set up than is worth the effort.
The first suggestion won't work well for me as I'm working from a CSV
exported from an online database program, so I'd have to create a database to
go that route, and I might as well create a report in Access. Also the Leigh
Weber example link is non-functional.
The second suggestion is how I set up the document to begin with, and so is
not helpful with the table dilemma.
The third suggestion again seems to be best lined up with an existing Access
database which this is not.
The fourth suggestion again seems more labor intensive than importing into
Access and creating a report.
Thanks for the suggestions, I think I'll just try to find an acceptable way
to format the Word document without tables or temporarily import into Access
and set up a report.
Thanks, Amanda
"Cindy M." wrote:
Hi amanda,
In the mail merge FAQ on my website you'll find a summary of the "one-to-many"
(complex document) problem with links to sample files/articles. Look at the one
for using a DATABASE field.
I am creating a document for a nonprofit that will create letters for our
donors and show a summary of their donations. I've created a Directory Mail
Merge that prints a letter for each donor and uses an IF statement to
detemine whether to print another donation for the current donor, or move on
to the next donor. This worked well on just a text basis, but I would like
to print 4 different fields from my database for each donation, and really
need a table format to pull this off attractively.
The problem is that I need to create a new row in an existing table for each
additional donation, and my IF statement does not see quotation marks from
inside a table. How can I instruct Word to create a new row?
For more info on the IF statement structure, my document was created as per
this Word article example: http://support.microsoft.com/default.aspx/kb/294686
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 :-)