Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail Merge

Status
Not open for further replies.
scottsanpedro

scottsanpedro

Programmer
Apr 26, 2002
97
GB
Hi,
Trying to access an already made mail merge document through Access.
I am using the following code.

Set objWord = GetObject("C:\DatabaseMailMerge\BBOffer.doc", "word.document")
objWord.Application.Visible = True

The problem is the dialogue box that comes up saying 'Opening this document will run the following SQL statement' says in the background and therefore does not open the document. Access waits as if waiting for something to happen.

I am using Access 2007.

Any help would be gratefully accepted

Thanks

Scott
 
Status
Not open for further replies.

Similar threads

aleenkhan
  • Locked
  • Question
Access Form to be mailed on submitting.
Replies
2
Views
74
Andrzejek
Andrzejek
codrutza
  • Locked
  • Question
Notification Expire Date E-mail
Replies
3
Views
71
Andrzejek
Andrzejek
kdschool
  • Locked
  • Question
Email from Form hardcode mail address
Replies
8
Views
137
Andrzejek
Andrzejek
primagic
  • Locked
  • Question
Merge record to Word
Replies
1
Views
50
Gammachaser
Gammachaser
Artois27
  • Locked
  • Question
Send form attachments via Outlook e-mail?
Replies
2
Views
65
Artois27
Artois27

Part and Inventory Search

Sponsor

Back
Top