I am trying to get data from an Oracle database into an already created Word template which has the fields and OLEDB link already set up in it. I've tried some of the ways i've seen on here but it always seems to come back to the same answer that it pops up a 'Confirm Data Source' window in Word and then fails to connect. Does anyone know why this is happening or have any other way of doing it?
View 1 Replieshow to edit and print mail merged document in vb.net (windows app) i have written the code to open the mail merged document but after the end user edited i want to print the document also.
View 1 RepliesI have a macro where I send a confirmation e-mail per line out of Excel. I can attach a document with a fixed location (let's say a map stored at c:map.jpg) but I have a problem attaching a document that is specific to the recipient. [code]...
Is the code correct? Or is there a trick what to do with the cell content?
I have set up a mail merged XtraReport, and it works fine. Now I want to access one entry in that mail merged report. By entry I mean the text associated with one row in the dataset, i.e. with the values filled in instead of having the square brackets with the field names.So if have an XRRichText in my report with the text "Hi [name]" I want access to the XRRichText object with the RTF value "Hi Sandy"..Added information in example, added VB.net tag
View 1 RepliesI am trying to create a front end to a) add records to a mysql db (without been able to view, or edit or delete) which i have working and press a magic button which sets up a word mailmerge doc so that the venue managers just have to edit the document and click send. The code I have so far for this bit is
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
If Venue.Text = "The Old Tramshed" Then
ConnectDatabase()
[code].....
The idea been, grab the email and firstname from the database. Write them to a locally stored word document which is used as the datasource for the mail merge. It opens the correct template and seems to create the same number of documents as is in the database, but i cannot click send in word (except to internet fax) as the email bit is greyed out.I was expecting the document to be started as an e-mail merge document, which the venue managers would then already have the correct template, put on the details they wish to send and then click finish mail merge and send documents.
I have a word document that has three fields in it (First Name, Last Name, Date) plus a page of common text (text that remains the same for everyone). I want my vb.net project to open the word document, and use the data from a listview (the listview has three columns: First Name, Last Name, Date) to fill in fields in the word document (doing a mail merge so that each row in the listview produces a new page in the document, with the corresponding First Name, Last Name, Date.
View 2 Replieshow to perform a mail merge from VB.Net 2008 to MS Word.
Basically what i want to do:
Open a Word template that contains fields. Replace the fields with certain values Save the document as a new file.
I need help in coding VB 2008 so that it can combine several word document into one to be used for a mail merge template.I need to:
1) combine the word doc (does not work see note 1)
2) use this new doc a for the mail merge (works, only for the rewrite doc)
3) create a pdf. (works, only for the rewrite doc)[code]
I'm trying to develop a Mail Merge using Bookmarks in a word template (1 page doc). It works ok for the 1st record from a datatable (source of data for bookmarks), and then just piles the other records into the same bookmarks. After the 1st insertion I need the code to goto the end of the doc, insert a page break and append a fresh copy of the template for the next insertion. The mail merge could have many 1 page letters in it.
strTemplateDir = Trim(txtDocument.Text)
wrdApp = CreateObject("Word.Application")
wrdApp.documents.add(strTemplateDir) 'open new word doc based on template
'make it the active doc
[Code]....
I am using this editor for the users to enter their text in the database interface environment that will both load/save/show them what they are working on in the form and also mail-merge into a Word document waiting for the content. I can do the first step and it works well, but how do I get MS Word to recognize HTML as formatting instead of just merging in tags and text all as text?
The tool has two relevant properties: one to get just the text (no markup, i.e. no HTML) and one to get the full markup with HTML. Both of these are in text format (which I use for easy storage in the Database).
ideas/directions I can think of:
1) use the clipboard. I can copy/paste the content straight from the editor window to Word and it works great! But loading from a database is significantly different, even when using the clipboard programatically. (maybe I don't understand how to use the clipboard tools)
2) maybe there is a library or class/function in Word that can understand the HTML as "mergable" content?
im having difficulty trying to do mail merge with ms word with dataset. i've tried google to search and i can't find the right solution. with little knowledge in mail merge, i only managed to do this:
[Code]...
the code above will open the document file, merge with 1st record only. what i need is open the template document, but have multiple records. let me give a scenario, i need to print out 10 letters for 10 people, the information in the letter is exactly the same except the name and address. but this should only open 1 word document with multiple records in it, how can i achieve that? then i can print the letter for 10 times with different records.
I have an sql database with client email addresses.I need to send out reminders at certain dates that vary per client. Is there a way for me to draw only the clients that need to receive the reminders out of the database and then send an email to each one of them?From what I have found so far, it looks like I can set up the smtp fairly easily.I just don't know how to get the client's that I need and then cycle through each one.
View 1 RepliesI would like to perform a mail merge between VB.net 2005 and Word 2007 using a dataset from my application, so the user doesn't have to touch word they will just be presented with the mail merged data. I have already created my connection to SQL server and populated the dataset but how can I output the dataset to Word.
View 2 RepliesI have 5 RichTextbox's on my Form. I would like to export the content to either a Word Document or a Mail Merge Word document
View 1 RepliesIn Win7, I am running a service which launches a process which hosts the office-library (Word 2007) for the purpose doing a mail-merge. There is no interface anywhere. When I launch the mail-merge process with the service as the parent, Word cannot create a document using my existing mail-merge Word doc. At first I thought the problem was with UAC so I changed the manifest to run as admin but it seems like that was irrelevant. When I launch the process from explorer or a non-service process instead of the service it works and is able to load Word and a document successfully. I used Process Monitor to see if I could get some clues as to what could be happening. As far as I can tell, when the proc is launched by the service it is using system profile since I see file paths such as c:windowssystem32configsystemprofile and c:windows mp instead of my user profile folders C:UsersUserNameAppDataRoamingApplication etc. My service is running as my username and not localsystem. I check the username using WindowsIdentity.GetCurrent().Name and I get my correct username regardless of service/non-service invocation. I tried changing the Word startup path in the Application object but again it only succeeds in non-service mode. I tried creating the process from the service in both shell mode and non-shell mode and they both behave similarly. I think the problem could lie in the fact that when the proc is launched by the service the user belongs to NT Authority/Service but when launched any other way it is NT
View 1 RepliesI've got a Word doc with insertion fields already created and an Excel spreadsheet with the data for a mail-merge.Does anyone have a code snippet for merging the two into a Word form-letter in VB.net?
View 2 RepliesI want to iterate over all rows of a MS-Word mail merge data source and extract the relevant data into an XML.I'm currently using this code:
Imports Microsoft.Office.Interop
Do
objXW.WriteStartElement("Recipient")
[code].....
I'm editing a vb.net app for a mate and part of the requirements are to copy merge fields from one word document to another. I can copy them across using document.content.text but they come out as text (should've figured this i guess). I think i've got them selected by:
[Code]...
I have multiple <body> tags from an word document. I do this with the open xml sdk. So the new document should generated with openxml The body's comes from
WordprocessingDocument.Open("C:TempTest.docx").MainDocumentPart.Document.Body.OuterXml
I have so different body's in a list. With al different values. Changed some text in the xml. And saved them in a new list. Now must that list in an new word document. How can i do that? I tried altChunk. But my word document is always corrupt.
I have a program in which I am trying to do the mail merge with the word template that I already have.
I have already setup the datasource for the word template in the word itself and it is pointing to my Employee Table which has all the information for the employee. I have also inserted the merge fields in the document where ever I need them. Now I want to print the document (Letter) with all the merge fields filled in from my application but for only employee whose Name or Number I sent from my program not all the employees I have in the datasource.
Now if I have to do it in Word, we have an option called Find Recipient in Mailings -> Preview Results in which I can set the Name or Number of the employee to get all his information to do the merge but how can I do the same thing from my program.
I can send all the fields values from my code like in the code below but I want to use my datasource to provide values. I have employee's Number I want to provide to the template to find the employee - so all the values are filled based on the employee's Number.
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesThe application I support is creating an amalgamted Word document by copying couple of Word documents in one document right after each other. The problem is the format of the some of the fields of the document that gets appended is changed in amalgamated document while the amalgamated document is the copy of AppendDocument (imagine if we have one document to copy in the amalgamated document)
[Code]...
I need to add in mail merge functionality to my application. I don't have MS Office, but I do have MS Works (which does have mail merge functionality, in the word processor application). Can the MS Works Mail merge functionality be accessed from VB.NET code.
View 1 RepliesI'm trying to use a datagridview as the datasource for my mail merge, but I'm having trouble getting all the data to output to the word doc. I've based the below code on the following tutorial:
[Code]...
Is there any way to do nested mail merge in vb.net . i can do only simple mail merge.but not nested mail merge.
My Code gives:
<District1>
<District2>
<District3>
[code]....
I am trying to have letter templates (word documents) that are stored in sql server VarBinary(max) to be accessed via a web application where they will be edited and saved back to sql server by directors of our company. Then various managers will be able to select an existing template (word document), make any additions, and mail merge with a list of customers to print or save the letters.
I am looking to open up word within a web page much like you would an email in outlook, edit it with spell check and the like, and then save it back in sql server. I am able to get word to open from a file but it is outside of the web application in a separate word document. I am storing the word document in sql server but am unable to open it in word without having to save it to a disk (why should you have to go to a disk for viewing or editing?). I am able to programmatically mail merge but that is in a separate word application.
I am finding bits and pieces on the web but nothing that will pull things together such as embedding word but in a windows app not a web app. Mail merge from a file not from a database, converting a byte array to word in a directory but not on a web page.
Here is a sample piece of my code, the problem that I am have is that I can only selected one record at a time to mail merge, regardless if I select 5 rows from the datagrid. Or I can mail merge the entire datagrid, but I want my users to be able to select the data that they want, whethere it is 1 or 5 rows and be able to mail merge based off the selection. I've been pulling my hair out over this, I know it is something simple that I am missing....Please help...I am working in VB.NET visual studio 2008
Private Sub btnMailMerge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMailMerge.Click
Dim objWordDoc As Microsoft.Office.Interop.Word.Document
'Dim objWordDoc As New Microsoft.Office.Interop.Word.Application
[code]....
We are opening a Word document from our Visual Basic 2010 application using the Word object. When we run our application under Windows Server 2008 the document name is truncated in the main window title for the document. This is not the case when we run our application under Windows XP. Is there a way to prevent this truncation under Windows Server 2008?Mary Leathem
View 3 RepliesBasically im at university and we have a motion capture system. you know the sort. silly lycra suits with dots on them used to animate 3d characters for film etc. this system costs upwards of 70,000 and if you use a prop in your take it generates 2 files which you must edit manually which is a pain if you do it wrong.[code]...
View 14 RepliesI have a spreadsheet that contains details of change requests; one row per request. This information needs to be copied into a Word form for sending off to our customer who then completes the response section. To speed up this process I have written some code that utilises the mail merge feature of Word and merges the relevant info from the spreadsheet into a Word form. This runs from Excel when a button is pressed.The problem comes when I go to save the workbook and exit Excel; it stays running in the background as a process in task manager.
[URL]
I'm fairly sure it has something to do with the merge code itself but my knowledge of VB is enough to grasp what is happening but not why it is happening. If I open the Word doc that has the merge fields in it, then open the spreadsheet that houses the info Excel says the workbook is already open.