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 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 RepliesI'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesI'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've searched for this everywhere, but can't find a solution after trying for two days. What I want to accomplish is creating a table in Word (n-rows, and 3 cols,) (which I successfully have) and for each row that has a new date, I want to merge all three column cells just for that one row with the date. For every other row, above and below, I still want to preserve the 3 columns structure. What happens with the Merge() method is that all the rows merge, not just the row I'm currently on. I did a macro and noticed that there is a Selection.MoveRight() option I can do, but I can't yet figure out how to put all these statements together to accomplish this. When I do the MoveRight, trying many variants like the following:
oDoc.ActiveWindow.Selection.Tables(1).Range.Cells(wordRowIdx).Select()
oDoc.ActiveWindow.Selection.MoveRight(12)
I get a member cannot be found for the first statement.
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.
Details: I want to compare these above two table1 and 2 . The unmatched records should be save in a new table .
objectives
1 Should take input the table and fields we want to match each other.
2 Then after searching or reading the record from table and selected fields save the unmatch records in a new table
My intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI need to build a rather simple form for collection some information from our membership. It has 4 Text boxes and one Submit button. The contents of the text boxes need to be emailed to a fixed Address and a fixed Subject. Before I got to fancy I tested the form to see if the email portion worked which I did get the email but not all the data. I am trying to stick with VB as I had experience with it years ago.
My problem seems to be in building the string for the body of the message. Trying to use StringBuilder but my syntax is messed up somewhere. The Fields that I have are: Name, Phone, Email Address: and Comments. They are named in the form as txtName, txtPhone, txtEmail and txtComments. [Code]
I am selecting a directory and then I want to loop through the files and check which xls and which docs are password protected and drop their names into column A in excel. I haven't gotten to the part of inserting into excel yet.I am trying to figure out how to check for password protected. I don't want to have to open each file separately.I am currently testing with excel, in a test directory i have one password protected xls and the other one is open. When i run my app both of them give me the message that they are password protected.I am not trying to crack password here...i am trying to enter the file names of the password protected xls and then remove them from the directory.
Tha
Function IsProtected(ByVal filepath_x As String) As Boolean
IsProtected = False
[code].....
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim oWord As Word.Application
Dim oDoc As New Word.Document
[Code].....
i got this from m$ site as well
any one see whats wrong?
[URL]
I'm trying to update some older software which uses the now-declared-obsolete System.Web.Mail classes.Unfortunately, I don't really know a heck of a lot about email, so I'm looking for advice.
Here is the fragment of code I'm looking at revising:
[Code]...
From what I can tell, this should be configuring some kind of sending option. I can kind of work out what's going on, but I don't know how I should go about re-implementing it.It's looking like the place to be putting this stuff is now in the System.Net.Mail.SmtpClient.Credentials class, but the information in there doesn't seem to bear any resemblance to what I have here.I'm almost certain I'm making some obvious error, here, but I can't see it. Can someone tell me what I should be doing?
is there a way to extract all the text from a Word Document in VB.NET without actually openning the file? I'm asking since it is a very time and memory consuming operation to open a word document, select all, assign it to a variable and the close the file.I have a routine the opens all emails in a mailbox and analyses the body and subject object for regular expressions. I would like to do the same for the attachment, if it's in Word. if it's not possible to extract without openning the file, can anyone give me the best way to do it so that the routine doesn't destroy my server memorywise?
View 2 Replieshow do i use the webbrowser to display the word or excel docs. just like the pdf viewer... i tried the webrowser1.navigate but it didnot work, if it does its opening a new window, im using office 2010..
View 4 RepliesHow do I use the webbrowser to display the word or excel docs. just like the pdf viewer. I tried the webrowser1.navigate but it didnot work, if it does its opening a new window, I am using office 2010.
View 1 RepliesI am exporting text to a worksheet with fixed column widths and there instances where the text in the cell does not fit and will obviously overlap to the cell on the right.
I'd like to prevent that overlapping by reducing the font size of the cell if it is necessary. The problem is how to check if the text does not fit.
I have a Excel file and I want to write some code to adjust it. What I want like this: Each cell in column E, if E6 and E9 have the same value, ROW9 should become ROW7 (old ROW7 became ROW8), and then E6 and E7 merged.I knew how to merge cells but I didn't know how change the whole row.
View 2 RepliesI have this Text: Hello <<FirstName>> <<LastName>> in which the <> and <> are merge fields in a document, and I have a list of customers in an array which I want to allocate them to these fields. How do I do that?
View 2 Repliesi'm using vs 2005 vb.net language windows application. i finished my program but i found a problem that when i add a new customer and the first name textbox1 is empty a msgbox appear but if i press ok it will continue and an empty customer is added to my database i want to know how to stop the to continue until the user enters first name i want the user not to be able to go to next step until filling all the required fields.how can i do this?
View 12 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 RepliesI was developing my own project in the university so what i am stack is to have save button which firstly validates what the user enters the form. for instance if the user skips the text fields, i wanted to restrict the user to fill all the form and when he completes, the save must be accomplished.
Here's the code i was trying to put but i was having problem saying the windows.forms.etc is unable to convert the save as Boolean and something like that.
Dim success As Boolean
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click
[CODE]...
I've made Add-in for Word 2007 in VS2005.It worked well with Word 2007 and now it works well with Word 2010 32 bit.However it doesn't work with Word 2010 64 bit. The installation is successful, but the ribbon button doesn't show up.
Do you have any experience with add-ins for Office 64 bit?
how 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 am trying to populate a web from from a SQL table.
Public Class userDetails
Public address1 As String
Public address2 As String
Public city As String
[code].....
however, there are like 50 fields in the User db, and it seems like a lot of retyping...
I have a table with many fields when I drag the details from the data sources tab to the form some fields do not show, and they go beyond what I can grab with a "blind group select" (I marquee beyond the bottom of the form and catch fields that I cannotsee). What can I do to place all fields on my form.
View 16 RepliesI am trying to write an Afterupdate Event code that will automatically update one field if a corresponding value is selected in the other field
View 3 RepliesI've created a formregion which is attached to a mail item (through the wizard). so now, whenever I look at a mail item, in the reading pane or when I open it, I can see my form.
How can I get the properties of the mail message I am looking at? for instance:
Who is the sender? what is the subject? when was it sent? etc.
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]....