How To Covert Email Macro

Oct 22, 2013

I am trying to insert a macro to send myself an email when ever someone uses my spreadsheet (I'll embed the code in an existing macro).

The reason for this is to not only gauge who/how many people are using it but also make sure no one is using it externally (I suspect people are passing it on to people outside the company which they are not supposed to). I need it to be covert so I don't tip them off and they don't start circumventing this check.

I have found the below which works well, but I wanted to see if there could be some additional checks to better conceal the sending of an email.

Can I also somehow check the Outlook status to make sure it is working "online" so the email doesn't sit in their Outbox if they are not connected to the network/LAN?

Code:

Private Sub Workbook_Open()
Application.DisplayAlerts = False
Dim oApp As Object 'Outlook.Application 'Object
Dim ns As Object 'Namespace
Dim fldr As Object 'MAPIFolder
Dim mItem As Object 'Outlook.MailItem
Dim sendTo As Object 'Outlook.Recipient
Dim bOutlookFound As Boolean

[code]....

View 1 Replies


ADVERTISEMENT

Automatically Unprotect Worksheet Before Email Macro Then Protect After Email Is Sent

Mar 2, 2009

I currently have a button then when pressed automatically sends a summary report taken from the first page of Sheet 1.

Worksheet needs to be protected all the time, but Macro only works on an unprotected worksheet.

I was wondering what additional code and where to put in so that when
protected back again after Macro has been executed?

Here’s the Macro taken from [url]

View 11 Replies View Related

Covert Into A Date

Oct 27, 2008

I have a long list (+1000 entries) of numbers (that actually represent dates) in cells one under neath another.I need to get them into date form so i can arrange them from earliest to latest.

Kind of looks like the following:

Cell1 - 1122005 (which i supposed to represent 1/12/2005)
Cell2 - 10192005 (.......................................10/19/2005)
Cell3 - 9282005 (.........................................9/28/2005)

Right now Excel just sees a bunch of numbers and does not know what to do with them.

View 9 Replies View Related

Covert A Word Document

Jan 25, 2009

I need to covert a word document to excel.

View 9 Replies View Related

Covert My Currency (Rupee) In To Million

Oct 7, 2008

Will some one guide me, How can i covert my currency (Rupee) in to Million?
(2700000 Rs Into Million with formula/automatically)

Secondly,
Can i make in a specific cell 4 colums & 2 rows ? Is it possible. ?

View 9 Replies View Related

How To Covert The Value Of A Checkbox From True/False To 1/0

Dec 24, 2008

I have searched all through the threads but I can't find anything similar to my problem. I am trying to create a checkbox that when the excel file would be saved as a *.csv file, the value for the checkbox would be saved as an boolean value 0/1. I created a macro that would populate the cells with the form control checkbox and linked it to the respective cell, I just need to change the value.

View 9 Replies View Related

Covert Numeric Value To Alpha Code

May 23, 2006

I've tried searching the forum here, but have not seen anything like my problem as follows:

I would like to convert the numeric value in a cell to a coded alpha

the numbers 1,2,3,4,5,6,7,8,9,and 0 would be coded as B,L,A,C,K,H,O,R,S,E respectively.

For example, if cell A1, held the value of 5750, the formula in cell A2 would result in KLOE.

The figures in Col A would be no smaller than 3 digits nor larger than 5 digits.

View 5 Replies View Related

Covert Decimal Number To Minutes

Aug 11, 2006

I would like to convert a number to minutes. For example .48 or 48 as a formula result to 48 minutes. The reason for doing this is I will add the result to a time.

Forumula result = 48 -> convert to {48 minutes + 12:00 = 12:48}

I've tried using just formating but no luck.

View 9 Replies View Related

How To Covert Lower Triangle Of A Matrix To A Single Row

Mar 28, 2013

I have a 22x22 matrix with correlations; I want to extract the lower traingle as a single row; so my matrix is

# r1 r2 r3 r4 r5 etc
r1 1 0.5 0.3 0.7 etc
r2 0.5 1.0 0.5 etc
r3 0.3 0.5 1.0 etc
r4
r5
etc

I want my row to be

r11 r12 r13 r14...r1-22 r21 r23 r24 etc..

View 5 Replies View Related

Covert Space Delimited String To Array

Apr 24, 2008

I have two columns of data, one for Position, and one for description.

The positions are concatenated and separated by spaces. E.g. C1 C2 C3 for each Description. I need to create a separate row for each position

So I need to convert:

Pos Decscription
C1 C2 C3 Cap 100n 10% X7R 0805

to:

Pos Decscription
C1 Cap 100n 10% X7R 0805
C2 Cap 100n 10% X7R 0805
C3 Cap 100n 10% X7R 0805

Or in other words split a space delimited string into an array, so that I can loop through the array, and add new rows

View 9 Replies View Related

Covert Duration Between Start And End Date To Units

Oct 1, 2013

I need to formula to covert duration between start date and end date to units below.

Start Date
End Date
Number of Month
Number of Years
Number of Days

6/1/13
8/31/13

[Code] .........

View 6 Replies View Related

Covert Formula To VBA Loop To Fix 5 And 6 Digit Time

Oct 10, 2013

I use this code in Column M to convert Column N

Code:
=IF(LEN(N2)>

I am looking to loop down Column N & O and replace , insert colon for both column N and O I started with is code

Code:
Sub FixTimeFormat()
Dim TimeNumcol As Integer
Dim ConvertedTimeCol As Integer

[Code]....

View 4 Replies View Related

Covert Number To Date 20131126 To 11/26/2013?

Jan 1, 2014

Covert number to Date 20131126 to 11/26/2013

View 7 Replies View Related

Email Macro

Sep 16, 2008

I need to write an Email macro. It need to check all the dates and mail me the names of the persons whos medical will expire in 30 days.

View 9 Replies View Related

Macro To Email

Oct 26, 2009

I want a macro to take all the headed data from each row and put it on an email with the headed data and the filled data beside it on the outlook email.

View 14 Replies View Related

Macro For Email

Aug 7, 2006

I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?

View 14 Replies View Related

Macro Creating An Email

Oct 17, 2008

I have a workbook with 20 worksheets. I would like to create a Macro on each sheet that when you click a button it creates an email to a list of recipeients for each sheet.

View 14 Replies View Related

Email Sheet Using A Macro?

Feb 26, 2002

i am trying to get excel to email a sheet to a certain address. I have managed to do this, however when i try and record a macro to perform this task, it doesn't work.

Basically all i want to do is send a copy of a filled in sheet to an e-mail address by just pressing a button.

View 9 Replies View Related

Email Pattern Macro

Feb 14, 2008

Need a macro that will autofill in an email pattern from a customer list i recieve. So far i have been having to manually do it.. but when have documents over 3k entries.. ouch.

This is what i got.. hope the way i type it in makes sense
A ..........................B ..........................C
First name........Last Name ............Email Pattern
John ..................Smith ...............First name initial, last name@abc.com
John ..................Smith ...............First name initial, dot, last name@abc.com
John ..................Smith ...............First name, dot, last name@abc.com
John ..................Smith ...............First name, initial of last name@abc.com

Is there a macro i can make that will automatically fill in the email based on the criterea found in column C before the @ symbol? then take the required info from Column a and b?

View 9 Replies View Related

Macro For Email Activity

Feb 26, 2009

I sit possible to run a macro that will record email activity from an Outlook inbox and store it in a Excel file. For example, the date received and the subject line for every email that comes into an inbox would be logged.

View 9 Replies View Related

Macro To Send Email

Mar 26, 2009

I have found the below mentioned code from one of the threads.

Sub EmailDoc()
Dim olApp As Outlook.Application
Set olApp = CreateObject("Outlook.Application")
Dim olMail As MailItem
Set olMail = olApp.CreateItem(olMailItem)
Application.ScreenUpdating = False
With olMail
.To = Range("A1").value
.SentOnBehalfOfName = """xyz"" "
.Subject = "Resources"
'.Attachments.Add "D: estxyz.xls"
.send
End With
Set olMail = Nothing
Set olApp = Nothing
End Sub

The above code works fine but i want to send emails to all the names in my column A in the To field and in the CC field from column D (It shoulds send if there are any values for the CC field)

View 9 Replies View Related

Email Sheet Using A Macro

Feb 26, 2002

i am trying to get excel to email a sheet to a certain address. I have managed to do this, however when i try and record a macro to perform this task, it doesn't work. Could any one help in providing a code for me to do this.

Basically all i want to do is send a copy of a filled in sheet to an e-mail address by just pressing a button.

View 9 Replies View Related

Send Email On VBA Macro

Nov 16, 2008

Is it possible to send an email if an error occurs with all the information regarding that error? I've created a workbook with a lot of macros and a lot of information. It's used by several people and sometimes those people have several other excel workbooks open and running at the same time. I've done my best to fix all the bugs but should one come up I'd like to be able to have the workbook send me an email alerting me of the error and the details surrounding the error such as what the error was, what macro was running, ranges selected, all that useful info. Is this even possible? or is there some sort of work around to at least bring up a prompt or page for the user to fill out then send by email after the error occurred?

View 2 Replies View Related

Email UserForm Macro

Dec 13, 2006

I have cobbled together a userform that works great, it prints, saves and clears as desired. Now i want to email a copy of the userform to a specific email receipiant.

View 4 Replies View Related

Spacing Error With Email Macro

Dec 19, 2009

The email macro I set up didn't work when I referenced the sendto from a cell in sheet 2; I changed it to reference an email address on sheet 1 and it worked with spacing errors. I need to fix the spacing errors, and I need to be able to pull the email from sheet 2. Code referencing sheet 2:

View 3 Replies View Related

Speed Up A Macro (email & Printing)

Jan 11, 2010

I've got a rather involved macro that's running kind of slowly, and I would appreciate any help I can get speeding it up. It's in two parts; the first is to create and email a report, the second is to format so it's pretty for printing. The full codes for both routines is pasted below.

The email part I developed first and it runs pretty quickly. Afterwards, I added the second macro, which is called halfway through the first.

Stepping through the code in the second macro, the problem I see is in this section, the setup for setting the heighth of merged cells in the report:

View 14 Replies View Related

Macro To Send Email Automatically?

Nov 30, 2012

I am trying to find a way of sending an email when a something comes out of date.

View 9 Replies View Related

Macro Code For Adding CC To Email?

Nov 17, 2013

VBA COde for adding CC, BCC to email sent from excel. I already have the below code to send email from worksheet, i need to add a copy email.

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

[Code].....

View 5 Replies View Related

Macro To Send Email In Excel

Mar 20, 2014

Im looking to create a reporting mechanism for a shared worksheet that im putting together.

I am looking to create some that will automatically create an email (either through outlook, or using a userform) and automatically populate with my email address in the 'To' section and automatically populate the subject with 'Error/Info Change'. The user can then populate the main email body with whatever they want to notify me of.

Im then hoping that the code can be run through a macro which has been added to the quick access toolbar.

View 2 Replies View Related

Xl Macro Cant Email Due To Outlook Security

Jul 3, 2002

I've written code into excel that sends workbooks to email recipients. This works fine except for use on one friends computer. Of course it's the friend that needed the code in the first place.
What happens is that when the macro attempts to mail a spreadsheet an outlook popup occurrs warning that a macro is attempting to email a message. And so nothing gets emailed out!

View 9 Replies View Related







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