o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

open a mailmerge document -

Hello,I have searched the forum but couldn't find a solutuon to my specific problem.Actually I have created a mailmerge using microsoft word and as data source, i use a table from microsoft access.Every time i try to open the word document,I am given a msgbox telling me that opening this document will run the following sql...When i click yes, the mailmerge works fine.but by default, the No button is selected.My problem Starts when I use a form in VB, with a command button which has the following code attached:

Sub OpenWorddoc(strDocName As String)
Dim objApp As Object
Set objApp = CreateObject("Word.Application")
objApp.Visible = True
objApp.Documents.Open strDocName
End Sub

Private Sub cmdanual_Click()
Call OpenWorddoc(Me.txtpath1.Text)
End Sub

When clicking the button,The worddocument opens.But the mailmerge toolbar is disabled.It's as if the msgbox i used to get has been bypassed and the default no button selected.Please help.

 

Replace MailMerge -
ok this is my first stretch into vb.net so be gentle.... I want to open a word document that could look like something like this: Dear <CompanyName>, blah blah blah. I want to open this word document and replace the <CompanyName> tag with a mailmerge field. I can


Merge two tables into one document -
I have two tables. One is a list of clients, and one is a list of data to be sent to all clients. I want to use Word to mailmerge the two together, except that there doesn't seem to be a way to do it! Any ideas on the best way to go about this? Should I create a multipage documen


open a mailmerge document -
Hello,I have searched the forum but couldn't find a solutuon to my specific problem.Actually I have created a mailmerge using microsoft word and as data source, i use a table from microsoft access.Every time i try to open the word document,I am given a msgbox telling me that opening th


[FAQ's: OD] How do I automate a Word MailMerge document -
Using the MailMerge object in the Word Object Model we can modify or execute a mailmerge on an existing mailmerge document. You may want to do this for reasons like filtering an output of records, sorting, changing a datasource (keeping the same fields), batch processing, etc. F


[WORD] Execute MailMerge in VB6 -
I am trying to use VB6 to open a MailMerge document. This Word document is connected to a Text file as datasource. When I try to open c:\source\letter1.doc, a message box will pop up: Quote: Opening this document will run the following SQL command: SELECT *


Word Mailmerge problem (VBA): new name for merged document -
How to give a merged document another name than the one that's been attributed automatically by Word (Office 2000)? According to me the Mailmerge Object doesn't possess a name property for the merged document. Is it possible to use code to determine the name Word attributed to the me


Data Types, and File Saving -
I am doing a forced mailmerge from access to a word document, the table in my database I am using to do the merge from has a currency field in it. When I look in the field it has the $0,000,000.00 format, however when I do the mailmerge it formats it to the text of 0000000 how can I s


Word MailMerge and VB 6 problem. -
Hello I am trying to send a mailmerge document to the printer after attaching the datasource file. See Code below. Code: Option Explicit Public WithEvents objWord As Word.Application Private Sub objWord_DocumentOpen(ByVal Doc As Word.Document) With Doc


MailMerge problem. Urgent! -
I am having a problem that is how to reserve the marco after mailmerge. The situation is I have a template which contains the macro for later use. But first the fields in this template needs to be merged from an Excel file. After I merged the file and send it to a new document using


Try & figure this -
I have a general Word2000 document with fields linked to a dbf (dbase) file via MailMerge. I've now saved the Word document as an htm file. The fields still merge to the dbf file with IE's 'Edit with MS Word for Windows'. OK so far. But now I would like the htm page to MailMerge wi


Help with Word and Visual Basic -
Hi I am new to Visual Basic and here is the project I must compelte. We currently have a Word document (that we mailmerge a flat file too). This document contains information for new hires. The users have asked that we add a couple of dropdown list boxes to the word document for t


mailmerge from outlook to word -
can anyone tell me where i can get a simple code to setup an automated mailmerge from outlook contacts list ( select by category say ) to a single word form letter document. many thanks


Mailmerge & VB -
Hi everybody, Now, I try to use Word Mailmerge via VB. Basically, I have to create a main document which I already accomplished and setup the datasource which I can't. I want to create a datasource in VB code and want to connect the database via an ODBC. Is there anyone know how to


Outlook Mailmerge using VBA -
Hi I have tried posting this at various other outlook forums, but never had a single reply (maybe that says more about my Q than the people in the forums. I am trying to produce a macro with VBA in Outlook (to assign to an outlook toolbar) to do the following: - when outlook i


***Resolved*** Mailmerge Problems Again -
I am trying to do a Word mailmerge from VB taking the Receipt data from an Access 97 Table. The code that I am trying to use opens my mailmerge document allowing me to view it in Word before printing it. Although I'm sure the code has errors in it and has lots of room for improvement,


Mass Mail Merge Problem - Is there a limit on the MailMerge document size -
Hi, I am using VS 2005. In the initial process of mail merge, if we want to merge 100 records, we will send it one by one for which the windows application stays open throughout the process and the documents will open and close for each record. Now we are trying to merge all 100


Help Required Urgently:In Continuation of thread Id=234230 -
Please refer to thread following thread http://www.vbforums.com/showthread.p...hreadid=234230 The problem is whenever I try to open the .doc file for mail merge, it's throwing an error that word was unable to open datasource. wrd.Visible = True wrd.Documents.Ad


Word and Excel from VB -
I know how to open and Excel spreadsheet from VB and then save it with a new filename. Also I can open a Word document as a template but does anyone know how I can get information from the Excel spreadsheet(certain cells) into my Word document in a specific position (like a mailmerge)


Access Mailmerge Automation -
Can anyone tell me how I can perform a mailmerge by opening up word from access and performing a mailmerge automatically without opening access again as the datasource? I've copied the script below, if anyone has any suggestions please help!!! Dim objWord As Word.document Dim mywd


Microsoft Word Mail Merge -
Hi, I am facing problem in MS Word Mail Merge.Below I create a document for mail merge and open the datasource. The problem is that every thing works fine except the database[gstrdatabase] entered, opens in MSAccess which is visible. I want to let the user see only the Word Document


[FAQ's: OD] How do I create a Mailmerge -
Using Word 2003 as an example... There are several easy steps in creating a MailMerge document: Step 1 - Setup a new Word document and add your verbiage and any images needed in the document as shown in Fig. 1. Note: I have added highlighting and brackets as placeholders for w


MailMerge Problems -
I have started having problems with MailMerge in my database - it has worked before but now I get this error: Runtime error 5922 "Word was unable to open data source" Here is my code: Code: Function MailMerge(strMMTemplate As String) Dim objWord As Word.Appl


SOLVED closing word once opened in vb6 -
I have an app that has to open a word 2003 document, merge it with a database, then print it, and close word. It opens, merges, and prints without a problem, but it is screwing up. First time I run the program, it errors and says that the merge file has no data or no data that matc


Is it possible to send mailmerge word doc through IE -
Hi, I was wondering if it is possible to send a mailmerge word file through the internet. What I'm doing is as follows: - user logs into website - user enters information and submit - website takes information and mailmerge with existing template - sends user end result No


Automating Mail Merge with Word through VB 6 -
I have several Word 2000 Mail Merge Templates that I need to automate through my VB 6 application.# The code I'm using at the moment is: Dim wrdApp As Word.Application, wrdDoc As Word.Document, wrdMerge As Word.MailMerge ' create an instance of microsoft word.


send query data to word doc via mailmerge V's Bookmarks -
i have searched but cannot find the best method of exactly how to achieve (Access not VB6) from a custom menu, send data from a query to a word document with either mailmerge or bookmarks. how can i do this and wich is the best method?


MailMerge with C# example -
I have been hunting for a mailmerge example using C#, and all I can find ix examples using VB, has anyone seen a C# example?


MailMerge Loses Table Formatting -
I have a draft ammount in my Microsoft Access database tha automatically calculates currencies for me(the table is formatted for currencies). So the table stores numbers like this: 1921.2 as $1,921.20... But when i press the mailmerge key on my word document, the draft ammount look


MailMerge to Web Service -
Hello, I would like to start a regular mail merge process, design my document, add a recipient list and merge fields. Then I would like to click a button which will cause Word to generate each document as a seperate one and for each document make a SOAP web service request that will


Pls Help : VB macro in word - hanging word -
Hi, I am not basically a VB developer and trying out my hand due to one requirement that actually invokes the winword from my process in macro mode. I have written a macro and I expect a result as to give me the two documents: 1. word document - gebog578_1009_GEMBout.doc 2. prn fi


trying to create a macro that prints records -
ok, I'm trying to create a macro to print a record in work, then go to next record and then print it... and do this till the last record... what's wrong with my code? Help...... ************************************ Sub DoUntil() Check = True: ActiveDocument.MailMerge.DataSour


Using Word to Mailmerge in VB 6 -
Hi All, I want to use VB6 to mailmerge, but can't find much help on the matter. There seems to be different ways to declare word and document objects. I have noticed that you can declare a word object as follows:- Dim wrdApp As Word.Application, wrdDoc As Word.Document, wrdMerge


MailMerging Problem -
I am having a problem with mailmerging word documents from Vb. I am creating a template document Name :<<Name>> And I am merging the destination document with data Name,Address John,22 First st The merged document from some systems are like the following 1


Open a document -
Hello, How can I open a document (a word-document, image, txt-document, ...) whithout knowing the path to its application. For instance: I have a document 'test.doc' How can open this document? I don't know where Word.exe is located? The same problem is it with all the o


MS Word Integration (Revised Question) -
I have a Word document with MailMerge set up, using an Access table as the datasource. In my VB program, once I have instantiated Word and open the doc, I will have the "merge results" of however many records are in my Access table. The question is, how do I "do someth


VBA - mailmerge -
Hi, Im workin on a mailmerge-thing which merges with the Exchange addressbook and Im a little stuck... right now I have this code: Code: ActiveDocument.MailMerge.UseAddressBook Type:="olk" ActiveDocument.MailMerge.DataSource.QueryString = _ "


MS Word mailmerge automation -
Can anybody provide me with some sample code to automate the mailmerge function offered by MS Word from a Visual Basic program. Thanks for your help in advance.


mailmerge and recordset -
Can anyone tell me how to connect a loaded template doc with a mailmerge to a recordset ? im using the MSword9 object and vb6 sp4 Thanks anyway!!!


Access -> Word -
Can Anyone advise me of a good source of info to show me how to transfer a filtered table to a Word Document with a specific template used. I tried to use the mailmerge wizard but it only seems to work on an unfiltered table/ query but I want to open a single record that is specifie


Mailmerge via ODBC -
How can I use an existing ADO recordset to create Word 2000 mailmerge documents?