export single record to word for merge

[bird lover]

I use xp professional and msaccess 2003. Used access for ten years but don't
know programming language.

Problem: Assume ten records in table. I want to export to word information
only from record 3 to then mailmerge into MS Word a specific form. How do I
export one record, so do mailmerge in word only merges the specefic record
data.

The theory is to make it as seamless as possible. One button, the letter
merges.
Help or example would be appreciated.

 

[Albert D. Kallal]

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).

Give the above a try.

 

[Ken Sheridan]

You might also like to take a look at:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


which demonstrates a number of Access to Word automation operations such as
merging, inserting text at bookmarks and filling Word tables. I'm not sure
just how up to date the version in the above library is, but if you want the
latest version mail me at:

kenwsheridan<at>yahoo<dot>co<dot>uk

Ken Sheridan
Stafford, England

 

[a a r o n . k e m p f]

you've used Access for 10 years-- yet you cannot program?

TAKE A CLASS, KID

-Aaron

 

[Ken Sheridan]

Ignore Aaron. He's long since been beyond the reach of medical science, and
seems to be getting more so every day!

Ken Sheridan
Stafford, England

 

[Tony Toews [MVP]]

Regretfully Aaron posts rather obnoxious postings. He is not typical
of these newsgroups. Please ignore him.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Regretfully, Tony spams this newsgroup with his personal opinions.

-Aaron