send 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 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 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 am sending an email with an attachment using the following Code
Dim msg As New System.Net.Mail.MailMessage(req.EmailFrom, req.EmailTo)
Dim att As New System.Net.Mail.Attachment("C:Documents and SettingsmichaelrDesktop1216259.pdf")
With msg
.Attachments.Add(att)
[code]....
The file size of the attachment is 396KB, upon the recipient receiving the email outlook shows the file size as 543Kb. Strange thing is if I send an email with the same attachment using outlook the file size is 396Kb.I understand that file sizes can increase due to the attachment being base 64 encoded as opposed to just raw binary.What I am failing to see is why outlook send a file which is 396KB in size but in code when sending it, the same file is 543Kb.
how would i implement a way that i would not hard code the email message that the application send to email recipients? how will i also include email message formatting (text in bold, italic, etc.)?
View 2 RepliesI'm trying to get my program to send very simple text email messages. I did do a search beforehand, and found that I was having the same issue as someone else, but the specific question I have was not answered --
I've learned that if you're trying to send mail, you need an SMTP server... I found this list here but every one of them I've tried yields the same "Failure sending mail" error.
Here's my
Dim mail As New MailMessage()
mail.From = New MailAddress("me@mycompany.com")
mail.To.Add("destination-email@whatever.com")
[CODE]...
Is the problem that I need to show "credentials" (i.e. user/pass)? If so, what would those credentials be? Can I use my yahoo email SMTP server with my login info to do it? And is this all I'd need to add to add the credentials?
smtp.Credentials = New NetworkCredential("MyUsername", "MyPassword")
(before the smtp.Send, of course)
A client for our company contains an apostrophe in their email name joe's@joe.com. I was advised that this is the correct and current email for the given client. Below is the Expression string I am using with Regex (which I copied from the internet somewhere) to validate email addresses. How can this expression be modified to allow/accept apostrohe's?
strRegex =
"^([a-zA-Z0-9_-.]+)@(([[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.)|(([a-zA-Z0-9-]+.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(]?)$"
I have to make a basic program that: Create a program with a simple interface that
1. Asks the user type his/her email address into a textbox.
2. When the user clicks the "Evaluate Email Address" button, one of two message boxes pops up: "That is a valid email address!" with an "Information" icon, or "That is an invalid email address!" and on a second line, "Please retype your email address.", with an "Exclamation" icon
3. To be considered valid, the email address must -include an "@" symbol, and -it must end in either ".com", ".net", or ".org" or ".edu" (I don't know how to check a string and test if its last four characters end with any of these and make it say not valid email address. I think I might have to use a case statement)
I'm using the Chilkat add-on to read email from a pop3 server. I can download the headers fine but the headers all download into one column.How can I get my email to put the headers in the appropriate columns?
'Display the From email address and the subject.
ListView2.Items.Add(email.From)
ListView2.Refresh()
ListView2.Items.Add(email.EmailDate)
ListView2.Refresh()
[Code]...
What I am trying to do is to download the "From" person into the "From" columns and the "Date" of the email into the date column, so on and so forth but I'm not able to get them to go into their separate columns.
I am buidling an application that users can use to submit text data and attachments to email recipients. Certain fields, quite a few in fact from the textboxes in the app will be in the email body, and some in the subject line.This is how I am doing it right now, but I figured there has to be a better way. In VB it is one single line of code, not many like it is here. Ideally I would like to be able to better control the positioning in the message body.
mail.Body = String.Concat(Label1.Text, " ", TextBox1.Text, " ", Label2.Text, " ", TextBox3.Text, " ", Label5.Text, " ", DateTimePicker1.Text, " ", Label3.Text, " ", TextBox2.Text, " ", Label6.Text, " ", RichTextBox1.Text, " ", Label7, " ", RichTextBox2.Text)
I wouuld like to open outlook with new email with provided subject line, body message and attachment but no email address. User will enter the email address and click send . How can I do this?
I used following code but it gives me error for to address
Dim SmtpServer
As
New SmtpClient()
[Code]....
I am creating an application in ASP.Net 2.0, the user can choose the service that he want and submit the request after choosing the form and filling the needed details the user should click on the submit button, then two emails should be sent; a confirmation email to the user him/herself and a notification email to his/her direct manager to get the approval on the requested ticket.How can I send the emails using VB language?
View 9 RepliesHere is the problem, I have an Access form and a textbox for an e-mail address. The email address is not required, I only want to check for a valid email address when a value or address has been entered into the e-mail filed. Example: If e-mail is not empty or if email field has a value, then check for the follow elements, matched the email address with the required format. If the e-mail field is empty, do not look for anything, move on.
View 1 RepliesI am development a small app for auto response all new emails with custom responses. My problem is that I don't know how open the email (make click on the subject link) on gmail. I am using web browser control, so I need to know how make click on the email titles for open each emails.
View 3 RepliesWhat 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 followed the instructions from this article http:[url]..... . My only problem is It compiles fine but no email arrives. I have a feeling it's for obvious reasons which escape me. This is my aspx.vb page.
Imports System.Web.Mail
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Const ToAddress As String = "paul.ramirez@att.net"[code]....
im using vb8.net im struggling to make a program that will display email addresses so in other words if im using ms outlook then by the click of the button the program must go in to the windows registry and then look in the place where the email address is and then read that part and display the address in a text box.
View 8 Repliesi can send email through vb.net behind code but how do i implement so that the recipient cannot see the sender email and only the name?i had done alot of research but i can't find any solution about this problem
[Code]...
How Can I EMail RichTextBox Contents By Default Email Client Using vb.net?
View 1 RepliesI am sending an email using VS2010 VB which works fine, except I would like to have the recipient see their name in lieu of their email address upon receiving the email. I've tried different 'To' addresses, ([URL]), but nothing seems to work. It always shows the email address when received.
View 2 RepliesI have a grid view control in my application.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="CPUserID" DataSourceID="GetSelectDelegatesDataSource">
<Columns>
[code]....
And I have a image button
<asp:ImageButton ID="ibtnSendInvites" Visible="false" runat="server" ImageUrl="~/images1/send_button.png" />
If you see above code you can find that there is check box functionality in my gridview. I have email address boundfield in my gridview. I want to send an email to the email addresses which are been checked in gridview.
how to validation Domain and Email Address for sending email in visual basic 2010 i used Code Below
[code]...
But Get Return abc123@xsd.com is a valid EmailID How is Valid The Domain is Not Valid Then..?
make an app for me that just sends an email of text from a textbox. if u have a source to one or anything like that because i have tried over and over and it just doesnt work
View 4 RepliesI wanah found a email password of my actual alternative email, but I can't, because I don't know the codes to make that...
View 11 RepliesI want to send an email using the default email client. If this is not possible, then Outlook will be the client of choice.* I want to be able to send attachments.* I would like to use Read Receipt on outgoing emails if possible.
View 1 RepliesI'm trying to make an ordering app and I'm using a DataGridView with 2 ComboBox Columns (Products & Quantities). After the user has selected the Products & Quantities in the DataGridView it needs to send this order as email. I'm using this code for SMTP mail:
[Code]...