i am trying to create an app that will do an EMAIL mail merge for me in vb(.net) using excel as the data source and word for the template.
I have the following so far which merges the data and template but I have no idea how to send the result out via email.
Private Sub DoMailMerge()
Dim w As New Word.Application
Dim d As Word.Document
[Code]....
I'm developing a small vb application that will enable a user to select an excel spreadsheet as the source data and a word document as a letter template then create a mailmerge from the two.It's all working fine apart from when the mailmerge runs, a dialog box pops up asking for the sheet to be selected. The list of options is blank until the 'options' button is clicked and 'system tables' is selected. This is a word thing but I'd like to turn this off, if possible selecting the necessary options programatically from within my vb application.
My opendatasource code is:
.OpenDataSource(Name:=sourcefile, LinkToSource:=True, SQLStatement:="select * from 'Sheet1$'", _
[code].....
I am using the mail merge of word 2007.
I want to set the 'carbon copy' property of the mail.
is there a possibility to modify the Datasource that is used for a mailmerge in Word VBA? e.g in the MailMergeBeforeRecordMerge- event?I need to delete some unnecessary lines before proceeding with the MailMerge.
View 1 RepliesMy program needs to create a mailmerge with Word using a specific group of clients from the sql database list. I have a datatable set up in the database that stores the clients information on the individual user's computer.
The code below will automate word to create the mailmerge, but I can't figure out how to pull the following from my client table and use the results as a mailmerge datasource[code]...
I am using VB.net 2010 to generate a letter from a Word 2002 template. The template has MailMerge bookmarks where the database values will be displayed (for example the letter receiving company's address). Currently I have:
«Company Contact»
«Company Name»
«Address1»
[Code].....
If "Address2" value is blank, then don't display the bookmark in the letter output (hence avoid displaying a blank line)
I am using VB.net 2010 to generate a letter from a Word 2002 template. The template has MailMerge bookmarks where the database values will be displayed (for example the letter receiving company's address). Currently I have:
[Code]...
What I would like to do is create a command button that launches an email from outlook attaching the current word document to a set email address. I'm not fussed if the word document is saved or not as it is only the email receipent that needs it, likewise I don't mind if the code instructs the email to send of just opens it ready to be sent.I have read through loads of forums and tried loads of codes but cannot get any to work.
View 3 RepliesI've been tryin' to develop macro, that can find table in the word and then copy it into the excel. Now it works, the only problem is, that is only the first row, that get copyed...
example (cell /w three lines in it):
Today is great day
Today is not a great day
Today, it is outrageous day
and with the code bellow, I get only Today is great day
Code:
For Each tTable In ActiveDocument.Tables
n = 1
With tTable
[Code].....
I'm wanting to put a menu on our application like is found in Word and Excel, File -> Send To -> Mail Recipient (As Attachment)Our requirements are to create and display the email with the attachment, just like Word and Excel do, not to send it automatically.We used to be able to save the file to the temp folder and use:Shell.Execute("mailto:my.email.com?subject=File&attachment="c: emp.txt");I've tried the &attach, &attachment in both VB.NET and C# with quotes, double quotes, etc. I've also tried System.Net.Mail but don't see anywhere that you can display the email, it only seems to be able to create and send.
View 4 RepliesI have a Macro that prints Sales Vouchers, is it possible to attach the userform to an Email or write it to a file for later attaching to an email or even send the UserForm to Word again the aim is to transmit the voucher electronically rather than paper. My code at the moment is very simple: UserForm2.PrintForm which prints the form. I tried printing to a file but couldn't get it to work. I am guessing that printing to a file is for Text only and not bit by bit.
View 5 RepliesI have a word file that i need to read all emails from and create an email list.
View 4 RepliesI am attempting to generate the body of an email in Outlook 2007 from the text of a Word 2007 document in VB. I have access to both the Word and Outlook object libraries, and I can read from the Word document to get a string and write it to Outlook, but I need to keep the formatting from the Word document intact. The purpose will be to allow users to edit the word document and always have the emails my program generates be in sync with the document. Does anyone know how to do this?
View 3 RepliesI 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 have a form to email every day that compiles from a VB script I wrote in MS Word 2003. Each day I have text that I need to place in the Introduction area in the email. I usually do this manually by copying the text then pasting it into the Introduction box since the text is usually just snippets of emails and have no common pattern. I would like to have a way to be able to select my text and copy to the clipboard, then run my script and have the contents of the clipboard pasted into the Introduction by the script so the email can then be sent.
Everything works perfectly if I place static text for the Introduction. I just need a way to be able to place the contents of the clipboard into the Introduction.
Has anyone any idea about how to automate mail merge in open office using vb.net?
View 1 Repliessend an e-mail from an excel sheet that will go to the person in column A (e-mail address in column B) that will contain the short message in column D and unique data in columns E and F. once that is done, Id like to go to the next row and do the same etc.
A2 to A20 persons name
B2 to B20 e-mail address
C2 to C 20 = yes or no
D2 to D20 short message
[code]....
I know I havent posted in awhile but you guys have done such a good helping me, my projects have been a breeze lately I have a new challenge though and I cant seem to figure out the solution. This new project Im working on sends a range of cells from an excel worksheet to the body of an email message and attaches two files.
I already have the automation down for the population of the excel file.I just need to copy Range A1:F20 from xlsheet3 to the body of a blank email with a populated subject line.Ive checked out this site already [URL].. but he seems to be accomplishing it with excel where as I (if I can) would like to do it in VB on VS .
I ave a contact form (VS 2010 / VB / .net4), and when the client fills out the form, I get an email -- which I like, but ....
For instance, here's an e-mail I got:
[code]...
But I'm expecting a lot of more emails than I had originally anticipated. Does anybody have any suggestions on what I can do? Is it possible to upload the responses into an Excel file, or something?
I am currently using Outlook 2007 and Excel 2002 SP3 and VBA for OfficeUsing VBA, I want to copy a range from Excel, open a new email in Outlook and then past the range into the body of the email (rather than as an attachment) as a Bitmap (so that the report on the email looks exactly the same a the range that is copied from).I can do most of the above but putting the bitmap into the body of the email is neigh on impossible..I can get VBA to paste the range into an email but then it loses most of its fomatting and looks horrible. Thats why I'd rather put the bitmap into the body of the email.I'm guessing that there is no easy solution to this..
View 1 RepliesSo this is a more refined version of a question I asked earlier. I have been trying to sort this out for quite a while. I found a site that makes sense, but I can't implement it for some reason. I just want to be able to copy information from excel (tables, charts, ranges, etc) into the body of an outlook email.
[Code]...
I have a column in an excel file which contains a string. I need to loop through each row in the excel file and extract an email address from the string.
View 4 RepliesI use VB 2010, Office 2003 and Windows 7.All the office programs have worked fine on their own for several years, but when I try toconnect to Excel or Word via .net coding (That will work on other systems) the program fails because the
View 2 RepliesImports System
Imports Microsoft.VisualBasic
Partial Public Class _Default
[Code]....
this is the code to convert word documents to excel. but i am getting error at underlines portion..the error is name not declared what should i do..I got thios code frm net and i just pasted it in visual studio..
I m new in programming and Im trying step by step to build my first program. I use Microsoft Visual Basic 2008 Express Edition with SP1. All I want to do is to give a button by pressing it, the ability to copy all the text from a word document into excel.
I'm using vb.net to check that certain Excel or Word documents exist in a folder.
EG
strFileFound = Dir("C:TestFolderMyExcelFile.xls")
strFileFound = Dir("C:TestFolderMyWordDoc.doc")
If the documents are created using Excel 97 or Word 97 the files are found. If the the documents are created using Excel 2007 or Word 2007 the files are not found.
I have checked the permissions between the two different versions and they appear to be the same.
why Dir dosen't work with Excel 2007 and Word 2007 files?
Are there any way to do so? I prefer to use VB.NET or Java and try to avoid to use VBA.
View 1 Replieshow to open MS Word and MS Excel in VB2010?
An can you give any site for referrence.
I've looked through some of the related topics to this newly created thread but none have answered my question. Refer to the following code below:
Imports Microsoft.Office.Interop
Public Class Form1
'declares the following Word and Excel variables as public
[code]....
I am creating a WorkSheet from code. I need my columns to word wrap and not run over (see red arrow below). Not really sure how to do it. Tried to set it for the range of columns with no luck. Here's the current output:
Here's where I try to set it:
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Dim xlApp As Excel.Application
[code].....
