single record mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt Edwards - 18 Dec 2003 16:30 GMT

I have an Access database that tracks 2500 "potential
donors" using forms. Each form has several subforms,
including one for "donations received."

I'd like to create a button that prints out a thank you
note from a Word doc, filling in variable information
like "name" and "amount received" where appropriate for
people one at a time (which excludes using mail merging as
I know it).

Help!

-ME

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 19 Dec 2003 02:48 GMT

Hi Matt,

If you're looking for a great one-click word merge for ms-access, then
take a look at fellow MVP Albert Kallal's website at the link below.
You can word enable any ms-access form with ONE line of code using his
example (it sends only the one record to the word).

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have an Access database that tracks 2500 "potential
> donors" using forms. Each form has several subforms,
[quoted text clipped - 9 lines]
>
> -ME

Reply to this Message