MailMerge Operations (Word.Application) -
Hi all!
I have a problem whith a MailMerge Operation in Word, I have made all the mail merge things from VB whith a txt file buld from VB but allways the word shows the window where I must select the field separator and the rec Separator.
How can I say this separators with parameters? (my separators are $ for field and Return for record) Maybe I must change to any standard for txt files?
Need Help.
Any Help would be apreciated.
Yours.
Joan Josep
MailMerge Operations (Word.Application) -
Hi all!
I have a problem whith a MailMerge Operation in Word, I have made all the mail merge things from VB whith a txt file buld from VB but allways the word shows the window where I must select the field separator and the rec Separator.
How can I say this separators with parame
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
[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
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.
***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,
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
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
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
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
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.
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
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
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
MailMerge -
Hello,
I have a tiny problem.
I'm merging clientadresses from a database into word.
There's no problem until Word-document becomes Visible.
Only the last field is visible.
I need to insert a pagebreak or a space between the fields, but i don't know how to do that.
Can anyon
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
Is it possible to do this -
I am trying to make a system for my user in which it prints out labels. The problem is that now I have my query (it selects everything that my user will need on his label), I want to try the following:
Make a macro (either from Access or Word) that allows him to select only certain
mailmege error 5852 with XP-works fine in 2000 -
I have a VB app that automates Word mailmerge It use an Access database for the input to the maimerge. The application works fine in 2000 and doesn't work in XP.
I get the error 5852 requested object is not available.
I get this message when it tries to execute the following line of
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
MS Word Events -
Hi,
I have a VB application that creates a Word(set win =new word.application) object and add document to it. Finally after add all the documents to the master document it saves the master file and makes the document visible to the user.After reviewing the created document when the
Word Mail Merge Issue -
I have a customer running Windows 98 and Word 2000. She's trying to run a VB application that attempts to do a mailmerge using the odbc driver for the AS/400. She keeps getting the following message:
5922 Word was unable to open the data source
This application works just fine on o
Mailmerge via ODBC -
How can I use an existing ADO recordset to create Word 2000 mailmerge documents?
mailmerge with a recordset -
Hi,
i've seen plenty of examples of doing a Word mailmerge with a temporary table, but is it possible to do it with an ADODB recordset?
I've seen this question asked many times and not answered yet so if anybody has a solution i reckon you would be helping many people out!
Ch
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
opening a Word mailmerge datasource -
I have created a mail merge datasource and open it via the Word object library in my app. If this is done with a PC with office 2000 on, then everthing is Ok. If it is a PC with office97 on, then I get an error opening data source. If I do this manually through word, I get the same pro
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
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
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
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?
word mailmerge from excel data -
is it possible to set which sheet for word to use for mailmerge data, i have tried a few things, but it always uses sheet1, though sometimes it tries to work with a range from another sheet it still uses the data from sheet1
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
access, word and headaches... -
OK, long and comlicated....
basically I'm trying to mailmerge a current record to word. I have a query that finds the current record from the key on the form but when i try to mailmerge it word starts a new session of access and then, no surprise, the query prompts for the form fie
access database, word mail merge... need i say more =) -
OK, long and comlicated....
basically I'm trying to mailmerge a current record to word. I have a query that finds the current record from the key on the form but when i try to mailmerge it word starts a new session of access and then, no surprise, the query prompts for the form fie
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
Talking to lots of WPs -
Hi (Hopefully)
i am writting an application and need to be able to comunicate with mutiple word porcessors for example maybe Ms Word, Lotus Wordpro, Wordpad and Ms Works. The operations i need to be able to complete are things like insert text into the document from a floating too
Query from Access to a Word Mail Merge -
Hey -- I'm trying to create code in Access that will take data from a specific table in Access to a Word Mail Merge doc. I've got it to merge but it merges every record in the table. I have the procedure execute on click from a command button from a form. I want it to only merge the
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
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
Excel Range to Word -
I want to be able to from a Word Macro copy a Range of Cell Values from Excel and paste them back into Word. I can't get word to read any values from excel.
I also want to paste from excel to a word datasource / mailmerge.
When using the saveas code in word, the user is not promp
VB6/Word Problem. -
I have a VB6 Application that open Word documents with mailmerge.
The application works fine where I am (Scotland).
However a copy of the system has been put down to England. When they run the system and try open up a word document, it creates the winword.exe in the task manager
[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 *