I whan to use a report as a quote letter using part of the information of a query I would like to import a word tempate into access to use to set up the report I have to be able to add/edit the notes on the report.
Any starting points would be most welcome.


Down by not out
Pirate :confused:

Pirate,

I really think you are taking a backward approach to solve your issue.

Consider merging your data to the Word document. I know you said you want to be able to edit the Notes on the report, but you can provide the necessary notes in your data while still in Access before merging the data with the Word template.

Using VBA you can accomplish exatly what you need to do. Take a look at this link:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
Scroll down on the page looking for "Super Easy Word Merge". Albert Kallal had developed this code and it really is Super Easy to use and does the merge to Word using data you provide. He has some explanations and the code is downloadable.

Will Give it a go just have to find out how to merge

Thanks

Pirate

Pirate,

I did not ask, but are you farily competent with VBA?

That is the key to doing the Merge.

Simply 'No' I use macros to do every thing I have tried with a lot of help and have had good results I must learn the codes any tips on what to study.

Pirate

Ok, no problem. LOL

NO, really, it is not a problem not to know something. Everyone of us here have "been there, done that". The problem comes when some folk do not want to learn. I can't understand that. Enought of my soap box!

I would suggest that you start with simple things at first. You can use the wizzard to help you create code for simple things. Then once the code has been created, go behind the control in the event and take a look at the code. You will start to see just how it works. Then as you expand your knowledge, you can search here for answers where questions about how to accomplish things and see the code that has been provided. If you do not find what you need to know, just post here, asking your questions and I feel quite sure that someone will be able to help.

Good luck with your project.

G'Day Mr. B,
I used the link that you supplied and the solution is working, just have to modify it to my database. The only problem tha occured is that the pictue I inserted into the template will not show up when it merges into a word.doc.
But I have learnt how to write code to shut a form with a button.

Thanks once again

Pirate from down under

Pirate,

First, congrats on making it work. Your way ahead at this point.

As for the picture issue; are you attempting to actually insert the picture or did you consider having a Word template with a picture control in place and simply replace the path to the picture you need. Just thinking outside the box.

Sounds like you also took my advise about learning to write code. Now that you have started and have been successful, all you have to do is just expand and start using some If statements and then some For loops, etc. See you are already expanding what you know. LOL

Well Mr. B,
I have over come the Logo issue by placing the Logo in a form header, and have the whole merge thing working off my database forms. Yippie :D :cool: :D Now :mad: When I merge the fields that contain $ amounts, it does not bring over any zero's that is in the cents part ($1234.50 to $1234.5, $1234.00 to $1234 ) also if there is a comma it leaves this out too($123,000.00 to $123000). It will however bring over the value $0
I have changed the decimal places from auto to 2 places but it still does'nt change the result.

Is this a normal thing??

Thanks
Pirate

Did you format the merge location in your Word document? Try that first.

This wont be the last time but you have lost me with "format the merge" could you please explain what to do. :confused: :confused: :eek:

Pirate

A merge field in Word can be formatted. Do a serace in the Word Help for: "format merge field". This will let you control the look of the merged data.

Thanks for your help all is working fine now

Pirate

Your welcome. Glad to help.

Good luck with your project.