can i auto export stuff from word to access

[buachille]

we run a family business and i do all the quotations.

i have an access database in which i record these quotations and whether or not we got the job or not, and i have to input all the data manually.

i wondered if i could set a word document so that it would automatically export certain areas of the quotation (like the date, who it was to, what work we are quoting for, how much it would cost, etc) into the correct fields in my database.

can it be done??

any replies will be much appreciated.

thanks

 

[RV]

Why not doing it the other way around:

- enter your quoations in Access
- merge them into Word

RV

 

[buachille]

so i just set up fields in word with mail merge and then access will chuck them in there yeah. anywhere you can get good easy instructions on this. i spose there is a faq on this site, but i haven't looked yet.

thanks for quick reply by the way.

 

[buachille]

hang on. i think i just saw the potential of access for the first time here.

i already have another database of contacts, which i think i could merge with my quotation database (make it a sub database if you like) and then import the correct addresses into the quotation database, enter the details, and merge it to word. is this what it's all about.

 

[buachille]

Welcome to the amazing world of the database You're going to love it here. Just a little hint on automation. When you want to automate a product to do something from Access, such as have Word print a mail/merge document, use the help from the target application to find instructions. So, Access help will contain help on automating Access from Access or from some other application, but if you want Access to do something with Word, you need to find the directions in Word's help file.

thanks for your reply.

i figured out how the mail merge and access work together and i pretty much know what i'm doing there now. waahhhaayyyy

anyway, i have just imported my quotation table and form into my contacts database and renamed the whole thing under the company name. i didn't realise before that i could put all the tables into one database!!!

what i would really like to do is set up my quotation form so that i could have a drop down list or search box somewhere in it (maybe in each of the address boxes that i have in the quotation form), that would allow me to find and import addresses from my contacts form (or table).

now how in the name of god would i do that!! - or can it be done? i assume i don't have to copy and paste the address from contacts to quotations??


heres hoping

cheers

<<<edit>>>

no worries. sorted it. a little wee list box from the little wee control toolbar. stumbled upon it and hit the jackpot!!