Inserting into Microsoft Word

[lewando_bria]

Hey what's up...I have a random question...is it possible to take data from a database and insert it into a specific part of a Word Document that serves as a template...i am working with forms where information is very redundant...but the kicker is that I cannot change the form templates or make my own new reports because they are required by a different entity...

I was just wondering if this is possible...i dont need a lot of details if it is possible...yet..hehe...because i am only thinking about doing it if it is possible...just lookin for a little feedback...

thanks!!!

 

[UniqueTII]

If you do a search on MailMerge, you should come up with plenty of answers to your question. I have only done it once, otherwise I'd help you.

 

[Shep]

Yes. I once found an example that shows basically how to insert text into a Word template. I don't remember exactly where I saw it. I think it was in Access help.

Here's a little something to get you started inserting text into a new Word document. For working with a template, you'll have to do some legwork.

Private Sub Command1_Click()
Dim objWord As Object
Set objWord = CreateObject("Word.Basic")
objWord.AppShow
objWord.AppMaximize "", 1
objWord.FileNew
objWord.Insert "Test of Insert."
objWord.EditSelectAll
objWord.FormatFont "22"
End Sub

Above is just basics, I know little more offhand. It is not difficult to open an existing Word document and 'Insert' into it. If you decide to go for it, you'll find that you'll be doing a fair amount of research. You've been warned.