Word read from Access 1

[GP]

I have a word template for invoicing which a secretary uses to type invoices.

I have an access database with names and addresses.

Can I get Word to open a connection to Access, load the 'tblAddress' and find a single record based on a 'strRef'. Then take the record and enter it in the word document.

 

[SpankYou]

Hey,

This page has an excellent example to get data from access to Word, it might give you a starting point...

http://www.helenfeddema.com/CodeSamples.htm

Hope this helps

Sam

"You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling machine." - Homer

 

[GP]

That is just what I was looking for, thanks.