Hello All Thank you in advance for taking the time to help out. Woody's Lounge is such a valuable resource for me and I am sure many others. It is truly a help.
OK Here is the problem...
I am trying to set up a command button on a form that will allow users to click on the button and merge data to create a letter in Word. Here is the code (I am a novice.... I don't know if this is even close... BUT.. I am trying... <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>)
Private Sub openSHMM_Click()
Dim oWord As Word.Application
Set oWord = CreateObject("Word.Applicaton")
oWord.Visible = True
oWord.Documents.Open ("FataEB DatabaseMail MergeSafe Harbor MemoSH Notice Memo.doc")
oWord.ActiveDocument.MailMerge.Destination = wdSendToNewDocument
oWord.ActiveDocument.MailMerge.Execute Pause = False
Set oWord = Nothing
Any way when I try and test the button I get an error message that says "Run-Time Error '429' Active X component can't create object'
ANY HELP????? This word automation thing seems to be harder than I thought... I have looked thru other posts, been to WendellB's Automation 101 and have gone thru many books.... NO LUCK!!!! Any suggestion is welcome!
Also (just a thought not a necessity) but can Access be set up similar to this to Automate reports to be sent via Groupwise Email?