How to generate a batch of letters???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurel - 07 Dec 2007 18:42 GMT

I've generated a lot of labels but putting in a bunch of bound text boxes
that have table values as their source, but now that I want to generate a
whole letter, with bound text boxes for the salutation and some embedded
text, I find I'm stuck. If I create a large text box and/or label, and
paste in the text of my letter, I get a "too long" or "contains invalid
characters" error. Even if I solve that, how would I do something like
this in the middle of the text?

Thank you for your gift of <tblContributions.Amount> this year.

I said I'd produce this before Saturday night..... so early help would be
greatly appreciated. I'm sure there's a simple solution! This has got to
be one of the most common things anyone does, right?

Reply to this Message

Albert D. Kallal - 08 Dec 2007 02:43 GMT

Can you consider using word, and mergering from access?

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html

Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message