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 RepliesI 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]
I have one spreadsheet with a list of materials by material number. I have another with all sales activity. How can I pull into the first spreadsheet the date of the latest activity from the second spreadsheet?
View 2 Replies View Relatedhave a data set with client id and most dates of activity....
I would like to be able to include within a report the date of first activity and the most recent date of activity....
please see attached sample worksheet...
I have a very large spreadsheet with financial information I am trying to graph on a line graph (which I know how to do). I would like to take only the last 48 months of activity and graph that. Is there a formula I can use to select only the last 48 months without reselecting the data everytime?
Example (for simplicity purposes in this example I only want ten months of data
Jan Feb March April May June July Aug Sept Oct Nov Dec
10 12 14 10 9 12 11 12 12 10 9 13
I would like a graph that displays march-december sales figures.
I have a user form with several command buttons.
Is there a way to show that excel is calcutaing when one of the command buttons is pressed?
The button starts a series of calculation that take a while to complete.
It would appear to other users of my spreadsheet that excel or the user form is not functioning correctly.
It would be neat if there is a way to show a % complete bar. but a simple graphic or text will also work.
I run an activity group wherby members have to complete various events such as swimming, cycling, climbing etc..
I have a worksheet that comprises of columns A - P
Column A = Members Name
Column B = Address Info
Columns C - P equals the activities
As each member completes an activity a marker (the word "DONE") is placed in the relevant column C - P
This results in several records being created for each member with a single entry in one of the columns C - P.
I want to consolidate the data into a single row showing the activities completed for each member
The data is sorted by column A brining all like records together
So if the name in the current row = the name in previous row then move entries in columns C - P up one row then delete the current row.
I received a suspicious email from <Excel Help/VBA Help: [forum@ozgrid.com]>. It may be nothing but I am wanting to inquiry about it's origin and content, how would I do this? I of course have received other emails from this site.
I have this table that I put together everyday describing the activity of my department. There is the date displayed as "Num-Date", the day of the week and multiple columns of data. Every day I have to add a new row and update the date, and the data, etc. I have a macro that inserts a new row and auto-updates the date and weekday, I also have a web query set up to fetch the data I want and display it right next to the table, but what I want to do is make the table more intuitive and automated.
View 1 Replies View RelatedI am recording attendance to our various activities as follows (screenshot):
Column A show the activity
Columns B onwards show attendance by day of the week (names gathered from list).
Now I've got a simple formula =COUNTA(Sep!B4:AE51) to count the total attendance for the month, modifying the range to cater for each activity, but it would be better if I could keep the range the same and modify the activity.
Also, I would like a formula to show the attendance at each activity by the day of the week (ie to show the total and average attendances for Mondays or Tuesday etc).
I have Activity data from my production line that details when a job is running "RUN" and when its on stop "SETUP". It looks like this:
Run 0.45 hrs (decimal hours)
Setup 0.1 hrs
Run 1.2 hrs
Setup 0.2 hrs
etc.
I want to be able to graphically present this against a fixed timeline, I have the timeline in a column, (not a row). I have cumulatively summed my times so I have this...
Run 0.45 hrs
Setup 0.55 hrs
Run 1.75 hrs
Setup 1.95 hrs
etc
However I want to be able to establish whether the job was ON RUN or SETUP at each interval of my timeline. For example: if my time line was in 0.01 decimal minute intervals, my chart would look like this:.................
I have a spreadsheet whereby process activities can be attributed to the different staff members who complete the activity. Each activity is on a different row and up to three staff can be assigned to each activity, so for example if a level one employee sorts the mail on four out of five days per week I would attribute 80% contribution to the task to the level one employee. If a supervisor sorts the mail on a Friday I would allocated a 20% contribution to that staff group.
My question is how do I prevent someone filling in the spreadsheet from allocating a combined contribution above 100% to any task. This could be for example either putting a number in greater than 100% into one of the allocation columns or a total across up to three different columns above 100%.
The columns where I assign the percentage contribution are E,H and K. I would like to generate an error which says something like 'Cumulative staff contribution per process activity cannot exceed 100%.
I need to show an information box e.g. "Initialising..." that I can show and remove without user interaction. I can't seem to find this using either a userform or msgbox.
View 5 Replies View RelatedI am trying to sum up the total number of hours consumed on a particular activity within a specified period.
=SUMPRODUCT(($C38:$C176>=$B7)*($C38:$C176<=$C7)*($B38:$B176=$D5))
Unfortunately, the formula above gives me the total number of activity and NOT the total number of hours within a specified period. I attached the file I'm working on as reference.
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 RelatedI 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 RelatedI 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?
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 Relatedi 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.
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]....
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?
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)
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.
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 RelatedI 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 RelatedThe 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 RelatedI'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:
I am trying to find a way of sending an email when a something comes out of date.
View 9 Replies View RelatedVBA 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].....
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.