on my frmCustomer form i would like a button that open up words and
runs a mail merger only with the data on on that form ( as on the mail
merger i just want the customer address for when i write a personal
letter to that customer only)

I know how to put a button to open a run a mail merger but i do not
know how to only make it mail merger the customer details on that form
and no other customers..


I have tried using qry and tables but i end up with all our customer
address mail merging and i only want one customer details to mail
merger


can any one help

Nothing doing. Take the easy way out. Albert did all this for you....

http://www.members.shaw.ca/AlbertKal...rge/index.html

Couldn't be easier.

Do not understand his code and how its done, looking for a simler
verstion


pietlinden (AT) hotmail (DOT) com wrote:

Do not understand his code and how its done, looking for a simler
verstion


pietlinden (AT) hotmail (DOT) com wrote:

"Simon" <S.Dickson (AT) shos (DOT) co.uk> schreef in bericht news:1157994911.164232.281910 (AT) e3g2000cwe (DOT) googlegroups.com...
Hmmm, you will need good eyes ...
simler verstion ?? You are in a hurry ??

IMO you should better ask a question about that code, and what *exactly* it is that you don't understand...

Arno R

Simon wrote:
a car engine works in order to drive? How a telephone works in order
to use one? I don't. Been talking on telephones since I can't
remember when. I don't see how this is any different. If you follow
the instructions Albert gives, there's nothing more to it. But if you
want to mail merge the hard way, have at it.

Did you at least try it and follow his instructions? If you found the
page, he spells everythign out... so what's missing?

"Simon" <S.Dickson (AT) shos (DOT) co.uk> wrote

Actually, that code is designed to be used by people who don't know code.
While that web page of mine is a really piece of junk, that word merge is
download a LOT.

I have received letters from old ladies doing volunteer work for charities,
and they never seen, or written code before. They wrote me letters to thank
me for my solution (I am NOT making this up....I have received many emails
of thanks from people around the world..and they OFTEN tell me that they
don't know code, but were able to use my application with the step by step
instructions on the web page).

If you following the instructions, you can place a button on ANY of your
bound forms,and with ONE LINE of code, it will instantly word merge enabled.

One line of code is ALL you need to write. Behind the button, simple place
the following code

MergeSingleWord

That is it!!!...the merge system will take care of merging the ONE record
you are looking at. It also takes care of the template creation also.

So, I actually do agree that some efforts should be made to learn, and read
the code you use. However, in the mean time, you can use the code, and you
ONLY have to write ONE line of code to word merge enable any form with that
example.

Try downloading and running the sample. The sample has data, and just try
doing a merge with it. If the sample works, then try the step by step
instructions here on how to use this in your code.

You can download the sample here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

And, step by step on how to use this in *existing* applcaitons is here:

http://www.members.shaw.ca/AlbertKal...rge/page2.html

While there is a LOT of solutions that use bookmarks, my solution actually
lets word do the merge (no book marks!!). Not only is this less code, but
this means that my code does NOT need to be modified for each new form, or
application that you use the code in. My code does not actually do the word
merge, and lets word do that part. My code is only a nice easy "wrapper"
interface for the features that exist now, and also just merges the ONE
record you are looking at.

My solution may not be what you are looking for, but you might want to give
the sample a try, since as far as I know, my solution is the ONLY solution
on the internet that allows you to word enable ANY form with ONE line of
code....

When I have time, I really should re-write the whole thing as a wizard..and
then you could word merge a form with NO code!!!

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com