Email Workbook From Excel Using Range As Address

Mar 2, 2010

I want my macro to be able to mail the active workbok through outlook using the email addressses in Cell R1 and having the body of the email have the text in cell R2:R8?

Dim OutApp As Object
Dim OutMail As Object
Dim ws As Worksheet
Dim range as range

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next
With OutMail
.To = ws.Range("R1:R8").Value
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = ws.Range("R2:R8").Value
.Send 'or use .Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing

View 9 Replies


ADVERTISEMENT

Excel 2010 :: Use Input Box To Enter Email Address?

Nov 3, 2011

I have a macro that will email a link of the worksheet.

the problem is I may have different email addresses to send it to. I want to be able to have an input box come up, and the person to enter in an email address, click ok and have the macro continue to email.

Sub Make_Outlook_Mail_With_File_Link()
'Working in Office 2000-2010
Dim OutApp As Object
Dim OutMail As Object
Dim StrBody As String
If ActiveWorkbook.Path "" Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

[code].....

View 2 Replies View Related

How To Send Excel Invoice To Email Address Using Macro Code

Jan 22, 2013

I have a template invoice in excel. What I want is a macro code that when it is run the open template invoice should be sent to a specific email address !!

View 5 Replies View Related

Excel 2010 :: VBA Loop Code To Automatically Email Range Of Cells And Email Addresses

Sep 16, 2013

I am using Excel 2010. I have been given a task at work that can save my team a lot of time if I can solve the problem. Every month, we have a spreadsheet with about 5000 rows that we have to email. In each row, there is a range that we have to email to a specific email. For example, I would have to copy and paste Range A2-R2 in the body of the email, and then email it to whatever email is in cell S2. I would then continue this for the next 5000 lines, making it a possibility that i will be sending 5000 emails manually.

I have been trying to come up with a solution through VBA that would automatically send these emails. My goal is to automatically send the Range A2-R2 to outlook email, then cell S2 into the "To" email address box, and then automatically send it. So far, i have successfully been able to send one row, but cannot figure out how to loop it for the remainder of the rows.

A couple other key points are that I have column headings as well (Range A1-R1). If possible, I want to be able to include the column headings in the email body as well. Example - first email would be range A1-R2. second email would be range A1-R1 and A3-R3, and so forth. The body of the email would also contain a standard script, such as "Please review the information below."

The goal here is to save everyone from having to send 5000+ manual emails. This would be a big boost for my team.

Code:

Sub Email()
Dim rng As Range
Dim OutApp As Object

[Code].....

View 5 Replies View Related

Using Macro To Find Email Address In Address Book Of Outlook

May 22, 2014

I am struggling to find a macro which can look at a name in column 'BT' and search it in the address book of Outlook to then place the email address of that person in column 'ED'

There are 35,000+ people in the address book and there may be over 5 email addresses for one name, so is there any way a message can appear for the user to select which email address is correct if there is more than 1 contact for that name?

View 1 Replies View Related

Get Email Address From Global Address Book In Outlook

Feb 25, 2014

On a worksheet called "Contact Info" column A starting in row 2 I have a list of names (variable length). In Columns B2-D I need the email address, work phone number, and cell phone number.

View 5 Replies View Related

VBA Code To Send Email To People Whose Email Address Is In Access Table

Apr 29, 2014

I have specified the email addresses in the code to whom the email will be sent when the user presses "Send Email" button but now I want to add all the addresses in the Access table and write down the code that will send an email to those people whose addresses are in the Access table.

[Code] .....

View 5 Replies View Related

Unable To Email Specific Sheet To Email Address?

Jul 3, 2013

I have the below code to email a specific sheet to an email address, however the email stays in the outbox and isn't sent. Is there something missing from the code or is it a setting issue with my email? I'm using Outlook 2010.

[Code]....

View 1 Replies View Related

Send An Automated Email To Typed In Email Address

May 20, 2008

I am trying to send an automated email by use of a "email" button. What I want it to do is to pop up a input box that will ask me who I want to send the email to, and once I hit ok it will send open up outlook and send the email. I have the code to work if I want it to be sent to a specific email address, but I can't seem to get the email address entry part to work. I will attach my code as it lays right now.

Private Sub CommandButton2_Click()'Need to reference: Microsoft Forms 2.0 Object LibrarySet OutApp = CreateObject("Outlook.Application")OutApp.Session.LogonSet OutMail = OutApp.CreateItem(0)strbody = "This is the most up to date copy of EAS Tracking 2.0 as well as the Resource Planning Sheet."attachmnt2 = "C:My DocumentsResource Planning Sheet_External.xls"On Error Resume Next'?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|?|? BELOW IS WHERE I CAN'T GET TO WORK!!!With OutMailDim range As Longrange = Application.InputBox("How many copies do you want?", "Number of Copies").To = range.Subject = "This Weeks Reports".Body = strbody.Attachments.Add (attachmnt2).Display.SaveEnd With'__________________________________________________attachmnt3 = "C:My DocumentsReport DataWork Request Tracking Data FolderEAS Request 2.0.xls"On Error Resume NextWith OutMail.Subject = "This Weeks Reports".Body = strbody.Attachments.Add (attachmnt3).Display.SaveEnd .........

View 9 Replies View Related

Email & Use Cell Data For Email Address

Oct 18, 2006

I need to email a page from a worksheet to a series of people and am currently using the following

Worksheets("Report").Activate
ActiveWorkbook.Save

Dim wb As Workbook
Dim strdate As String
strdate = Format(Now, "dd-mm-yy h-mm-ss")
Application. ScreenUpdating = False
ActiveSheet.Copy
Set wb = ActiveWorkbook
With wb

however, I also need the worksheet to be email to the person currently running the macro (i.e. when they email it to the others, a copy is sent to thier own inbox too), is there any way in which this can be done?

The user's email address could be formed from data in the spreadsheet, if there is an easier way to do this (i.e. email address is based on a cell in the spreadsheet).

View 3 Replies View Related

Send Excel Workbook By Email

Oct 10, 2011

I have a macro that will send an excel workbook by email when an image is 'Clicked on' however, I need the attachment to be renamed as the text used in cell B9 of this worksheet.

So far I have the macro below which auto populates the 'email to' address and the 'subject' line which is great but how do I get to rename the attachment?

Sub SendIt()
Application.Dialogs(xlDialogSendMail).Show
arg1:="test@test.com", _ arg2:="test 1" End Sub

View 2 Replies View Related

Email Via Excel (Format Not Workbook)

Jan 4, 2012

I have a format and i want to put information in the format and send email only format not all workbook . i use also outlook for Email

View 9 Replies View Related

Copy Range Of Cell From One Workbook To Another And Email

Nov 3, 2013

I need to copy a range of cells from one workbook paste into another and email that new work book.

View 3 Replies View Related

How To Attach Current Excel Workbook To Email

Sep 19, 2013

show me the visual basic codes that allow me to attach the current saved workbook to an email (just attach, but not to send the file). So basically, just open the Outlook, send to, and attach the file.

View 6 Replies View Related

Force Single Instance Of Excel When Opening New Workbook From Email?

Aug 28, 2013

I have multiple buyers that use an Excel workbook containing several macros to perform edits on other workbooks they receive via email. Generally, they have the workbook containing the macros open, and they can double-click the workbooks they receive in the email messages to open them, and the macros are available from the "master" workbook.

Recently, however, some of the buyers have been getting new computers running Windows 8 and Office 10. Now when they have the "master" workbook open, and double-click the attached workbook in an email, (Outlook 10), the new workbook opens in a new instance of Excel, and as a result the macros are not available to run on the newly opened workbook.

The work around has been to right-click the attachment and save it to their desktop, and then use the File/Open command from the "master" to open the new file. This is a hassle and takes extra time.

I'm sure I am overlooking a setting somewhere that tells Excel to always open new workbooks using the same instance of Excel, (there are two people using the new systems that aren't having problems, and two that are), but for the life of me I can't find where to set these parameters.

View 6 Replies View Related

Excel 2010 :: Send Workbook In Email With Subject And Message?

Nov 29, 2012

I did this 10 years ago so I admit I am rusty at this but here are what I had in my notes that worked with Excel XP. I am currently using Excel 2010

With ThisWorkbook
.HasRoutingSlip = True
With .RoutingSlip

[Code]....

The last line will send the workbook but I need a Subject and Message to go with it.

View 9 Replies View Related

Excel 2007 :: Save Files XLS In Macro Workbook And Send Email

Sep 3, 2012

I am using 2007. This may be something simple but I can't seem to find a solution to this, I have an excel macro enabled workbook which produces a daily report the final task is to save and send an email but I need the file to save as an xls rather than xlsx as some of the recipients are unable to open the file here is the code used for the tasks in the

workbook:Sub Step1_Refresh()
'
' Step1_Refresh Macro
'
'
ActiveWorkbook.RefreshAll
End Sub
Sub step2_save_close()

[Code] ........

View 1 Replies View Related

Excel 2007 :: Save Files XLS In Macro Workbook And Send Email?

Sep 3, 2012

I am using 2007, I have an excel macro enabled workbook which produces a daily report the final task is to save and send an email but I need the file to save as an xls rather than xlsx as some of the recipients are unable to open the file.

Here is the code used for the tasks in the:

workbook:Sub Step1_Refresh()
'
' Step1_Refresh Macro
'
'

[Code]....

View 7 Replies View Related

Email Excel Range Using Lotus

May 27, 2009

I have yet to find ANY information online relating specifically to emailing any given range in Excel via Lotus Notes. The codes that do exist out there either fail to fully copy the range or relate to attaching an excel file into a Lotus Notes Memo.

Below I have copied the code the I am working with, but I keep getting the following error: Error # 438, Object doesn't support this property or method. After making some minor tweaks, it might then give me another error, Error 424 Object Required, but the range then doesn't copy into the Lotus Notes memo at that point.

I have highlighted the area that I think the code is failing at, that being the actual act of copying/pasting the range selected into the Lotus Notes Memo. With the current code, the selected range does get fully copied into a new memo in Lotus notes, but these errors populate in Excel.

Can anyone offer any suggestions to resolve this issue? I have spent hours on this and I'm sure there are many others out there that might be able to benefit from a solution as well.

Function LotusEmailQuote() ....

View 9 Replies View Related

VBA Not Detecting Email Address?

Jun 20, 2014

It worked well at the time and continues to work well.

The problem I have is that I've copied it for use in a new workbook and for some reason it's not picking up email addresses and storing them in the string "stemails", so that when the email is created there are no addressees. Column BA does have email addresses in it however.

[Code] .....

View 2 Replies View Related

Extract Name From Email Address?

Jan 3, 2007

I have a list of email addresses. Most of them are in the format of: firstname.lastname@domain.com

There are about 200 of them. I wish to extract the firstname and lastname into seperate columns so i end up with:

Code:
A | B | C
--------------------------------------------------------------
Firstname | Lastname | firstname.lastname@domain.com

I am sure I came across something before that did something like this. but I was not able to find it. Any macro or script to perform this extraction.

note that some of the addresses are in the format: name@domain.com In those cases I would like just everything before the @ put into column A. I will then manually figure out how the value is to be broken up into firstname / lastname.

View 9 Replies View Related

How To Get Company Name From Email Address

Mar 18, 2012

sort out the email address as per the company name using Vlookup or any other formulae other than using text to column on "Email Adress" and then doing a Vlookup from the reference table.

Reference table:

Email AddressDomainCompanyxyz@gmail.com@gmail.comGmailabc@hotmail.com@hotmail.com
HotmailAlpha@facebook.com@facebookFacebook

Result Required

Email AddressCompanyxyz@gmail.comGmailabc@hotmail.comHotmailAlpha@facebook.comFacebook

View 2 Replies View Related

Separate Out Email Address?

Jun 18, 2012

I have a combined sentence with email address at the end. There is a space between email and other part. For example, in Cell A1, it's: PO Box 132, Washington Ave, dennis789@yahoo.com. In cell A2, it changes to: 12 DW Road, georgeyiui@hotmail.com. How can I separete these emails out?

View 7 Replies View Related

Extract Name From Email Address

Jan 3, 2007

I have a list of email addresses. Most of them are in the format of:
firstname.lastname@domain.com

There are about 200 of them. I wish to extract the firstname and lastname into seperate columns so i end up with:

A | B | C
--------------------------------------------------------------
Firstname | Lastname | firstname.lastname@domain.com
I am sure I came across something before that did something like this. but I was not able to find it. Please let me know if you can provide a macro or script to perform this extraction.

Please note that some of the addresses are in the format: name@domain.com
In those cases I would like just everything before the @ put into column A. I will then manually figure out how the value is to be broken up into firstname / lastname.

View 9 Replies View Related

Email: Reply To Address From VBA

Apr 28, 2009

I am currently trying to automate a receipt system. I have successfully managed to create an email based on calculated Excel data. The email is created using the following routine.


callref="12345"
strbody = "The main text of the email"

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next
With OutMail
.To = "John Smith"
.BCC = ""
.Subject = "Test email receipt - " & callref
.Body = strbody
.Display 'or .Send - still developing!!!
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing

My problem is that there will be several people using this system so I would like to include a reply address which is different from the sender. Alternatively, I would like to send the email from a different account (but I have to assume that the users will have their own email accounts open).

View 9 Replies View Related

Turning Name Into Email Address As A Rule

May 20, 2014

Is it possible to create a rule that every time I type my name, for my e-mail address to pop up in excel instead?

For example, if I type "purple1686", I want "12purpleexample@domain.com" to show up as a hyperlink to my default e-mail program.

I am also curious if I was to write "my website" is it possible to make it a hyperlink to "www.purple1686example.com"?

Those two first may be easy to answer, so here is the challenging part for me:

Can I make that happen as a rule on every spreadsheet I open?

I don't know if I should make a template, or use a formula? The ideal scenario would be if there was a way to do it through conditional formatting.

I have used conditional formatting to change the color of a word every single time I open a new template and paste the words into it, or even by typing them out.

View 1 Replies View Related

Convert Names To Email Address?

Mar 28, 2014

I've two columns, one being the first name and the second being the last name. Is there a way that I can convert these two columns into the correct format for the email address ? Rather than having to manually do this.

View 4 Replies View Related

Importing Names And Email Address

Jun 11, 2014

I have quite a number of names & email addressees that I received by email.

I wish to import them into excel, what is the best way to do this ?

Preferably I would like the names in one column and email addys in another.

View 3 Replies View Related

Typing EMail Address Without Hyperlink

Jul 26, 2009

When I type a eMail address, such as: " myemail@hotmail.com " into any cell and then touch enter, it automatically becomes a hyperlink coloring it blue and underscored. I do not want it to be a hyperlink, for when it is a hyperlink, I have to click on remove hyperlink.

View 2 Replies View Related

Pull Email Address Only From Cell

Jan 6, 2014

How do I pull only the email address from a cell that is like this:

annavstone22@yahoo.com,anna,stone,,,,,,,,,,,2011-10-20 17:31:08

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved