Merge data into single Word doc from single Access record

I am building a database to store numerous customer records, each holding
numerous different pieces of data. I am fine with that part of the project.
I will want to use various Word docs (templates) for different purposes,
each of which should pull data from an individual customer file on Access,
i.e. just the current record I am in, producing a certain letter and merging
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13251-merge-data-into-single-word-doc.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251
the relevant data into it. Not a mass mailmerge process.
Just one particular letter at a time, from one particular record.
I am familiar with the concepts of templates and data-merging and have done
some work in the past on ready-built databases, but haven't built these from
scratch myself before.
Could somebody walk me through this please, step by step?
Many thanks
CW

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Hi CW,

To be honest, it's too big to walk you thru. You will need to do alot of
reading, especially on opening data sources.

You will also need to include Word's and and possibly Office's libraries in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251
your references to get the MailMerge commands.

To pick a specific record you will have to learn to write WHERE clauses.

If you go thru your object browser after including the Word and Office
libraries, you will see your choices. Click ? you get the info on that
object.

Hope this helps some.


"CW" wrote:

> I am building a database to store numerous customer records, each holding
> numerous different pieces of data. I am fine with that part of the project.
> I will want to use various Word docs (templates) for different purposes,
> each of which should pull data from an individual customer file on Access,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251
> i.e. just the current record I am in, producing a certain letter and merging
> the relevant data into it. Not a mass mailmerge process.
> Just one particular letter at a time, from one particular record.
> I am familiar with the concepts of templates and data-merging and have done
> some work in the past on ready-built databases, but haven't built these from
> scratch myself before.
> Could somebody walk me through this please, step by step?
> Many thanks
> CW

I have a excellent step by step here...in fact, I have a whole working
library of code you can use:

you will find it here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251

Give the sample download a try. (do that....first). If you like what you
see, then read the folwling part

http://www.members.shaw.ca/AlbertKal...rge/page2.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

As you are creating a single word document from one record, rather than
undertaking a mail merge I'd suggest filling bookmarks in the Word template
document with the Access data. I've posted a demo which includes this, along
with merges and filling Word tables and form fields, at:

http://community.netscape.com/n/pfx/...g=ws-msdevapps


You could use the merge facility in the demo to do what you want if you
wished, but the 'Create Letter' facility in the demo does it with bookmarks.

Ken Sheridan
Stafford, England

"CW" wrote:

> I am building a database to store numerous customer records, each holding
> numerous different pieces of data. I am fine with that part of the project.
> I will want to use various Word docs (templates) for different purposes,
> each of which should pull data from an individual customer file on Access,
> i.e. just the current record I am in, producing a certain letter and merging
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251
> the relevant data into it. Not a mass mailmerge process.
> Just one particular letter at a time, from one particular record.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13251
> I am familiar with the concepts of templates and data-merging and have done
> some work in the past on ready-built databases, but haven't built these from
> scratch myself before.
> Could somebody walk me through this please, step by step?
> Many thanks
> CW