Set Tasks In Outlook..
Jan 20, 2010I want to use excel to update the tasks in outlook. All I have is a due date (from A2) and a task (from B2) Here is the code I have got so far
View 2 Replies
ADVERTISEMENT
Outlook Tasks
Oct 30, 2007I have searched and think I have found what I need to create Outlook tasks from my Excel spreadsheet. I'm hoping that someone here can help me pull it together into something that will be usable in my project tracking spreadhsheet...
I try to keep track of milestones... these milestones are listed in column B of my spreadsheet and are in rows 10 through about 105
For each of my customers I then keep 4 columns D, E, F, G - H, I, J, K - L,M,N,O - etc. Each group of 4 is a different customer....
The customer's first column (D, H, L, etc.) is a Due date of the Milestone that is found in column B.
The second column is a check box that I use to indicate when the milestone is complete
The 3rd column is the completion date
The last colum is just a filler space that helps to separate each customer.
What I would like to do is insert a button at the bottom of EACH grouping of 4 that when pressed would look at the first column for the customer group and for ANY Milestone that has a DUE date process the stuff in the VB below to create an OUTLOOK task for each item that has a DUE date. (It would be conceivable that as it stepped through each row for a customer group of columns that I could have it create 90+ Tasks in Outlook.
A couple of additional things... in row 110 for the first column of the customer I have a DATE or a blank. So for example in D110 it might be blank or a date like 10/29/2007. If it is blank then when I press the button it would loop through ADD the tasks for each row with a due date. If row 110 has a DATE I would get a popup indicating that the tasks are already in OUTLOOK and that they were added on whatever the date is in row 110... This is kind of the safeguard that I don't get the same group of tasks multiple times by pressing the button by mistake.
Integrate To Some Extent With The Outlook Tasks Function
Aug 28, 2008it seems to be possible to integrate to some extent with the Outlook Tasks function....
Is it possible however to 'update' a given task, and have it linked somehow to my workbook project? (Maybe using some sort of reference?)
Create/assign Outlook Tasks From A Range Of Cells
May 15, 2008I have had some help with this (thanks!) but am stuck.
Can someone add to the code below and make it so that multiple tasks, with multiple assignees, can be created from a range of cells, such as:
Column A Column B
Row 1Task SubjectAssign to
Row 2GV LP for AZJohn Brown
Row 3GV LP for COJohn Brown
Row 4GV LP for ILSuzy Smith
Row 5GV LP for INSuzy Smith
Row 6GV LP for KYSuzy Smith
Row 7GV LP for MNSuzy Smith
Row 8GV LP for MSBob Barker
Row 9GV LP for NCBob Barker
Row 10GV LP for NJBob Barker
Row 11GV LP for NMBob Barker
Row 12GV LP for NVBob Barker
Row 13GV LP for NYBob Barker
Row 14GV LP for OHBob Barker
Row 15GV LP for SCBob Barker
Row 16GV LP for WVBob Barker
(Sorry, it didn't translate well. The "GV LP for AZ" is cell A2, "John Brown" is cell B2.)
Here is the code I have so far:
Schedule Tasks ..
Apr 6, 2009Im having trouble with getting a macro to run at a specific time and day (Every Thursday at 7PM).
Here's what I have done so far..
1. I added my excel file to the task scheduler
2. created a class module and place the code below into it.
In testing the workbook opened but it asked if i wanted to enable or disable the macros - how do I get around this? And it does seem to kick off the macro (create_all).
Private Sub Workbook_Open()
If Hour(Now) = 1130 And Weekday(Now, vbMonday) < 7 Then
' TheNameOfYourCurrentProcedureHere
create_all
If Workbooks.Count = 1 Then
Me.Save
Application.Quit
Else
Me.Close True 'save the changes and close the workbook
End If
End If
End Sub
Calculating Duration Of Tasks
Aug 7, 2009I have a worksheet where I calculate the duration it takes for an operation. the format of the worksheet is as folows:
The worksheet is composed of Start and Finish times in this format: 2009/06/02 5:32:19 , so for example,
- Row1 of the worksheet will have "Start" in column H1 and the start time in column B1
- Row 2 of the worksheet directly below has the "Finish" time, with the Finish time information in column B2
So with the help of excelforums I was able to implement a macro to extract the finish time cell found in row B2 and offset it to C1 and do a simple calculation to get the duration in minutes and display it in column D of the same row as "Start".
Calculating Duration Of ALL My Tasks
Feb 2, 2009I have 10 columns (1 through 10) called TASKS and 2 rows for each task
Row 1, has a 'start date' in the form of 1/1/2010
Row 2, is duration
the duration of each task may or may not overlap with other durations of other tasks.
how can i find out the total duration of ALL my tasks.....without any overlaping.
any formula that can calculate this? ( i need one number at the end!)
Distribute Duration Evenly Amongst Tasks?
Sep 10, 2013I'm working on a project that will will have varying tasks & estimating the total duration to complete these tasks.
For example:
If estimating that the min-project will take 90 days & I have 17 tasks, how can I distribute the 90 days evenly amongst the 17 tasks?
Two Tasks, Same Macro? (put A Value In A Single Cell)
Nov 1, 2009I want to put a value in a single cell - A1 is going to be (say) 5.
View 5 Replies View RelatedSchedule A Macro To Run With Scheduled Tasks?
Jan 28, 2003I have a worksheet that runs a query from an external data program. I have made a macro that refreshes the worksheet and this works ok. Is there a way I can get Scheduled tasks to automatically update this workbook eg overnight. I do not want to leave the workbook open either. Can task scheduler open the workbook, refresh the data, then close the workbook again.
View 9 Replies View RelatedOnTime Not Firing Via Scheduled Tasks
Dec 27, 2006I scheduled a task to open excel and when it does (at a certain time), a little sub is supposed to run (couple minutes later) via the OnTime Method located in the Workbook Open Event. There is one weird thing though....
1. When Excel opens automatically through Scheduled Task (and you see the clean white sheet WITH gridlines), Sub does NOT run (that is, my file is NOT even opening).
2. When I myself open Excel manually WITHOUT opening a new workbook (in other words, in front of you there will be grey area without gridlines), Sub runs perfectly (in other words, my file opens automatically and Sub performs whatever it is supposed to do).
Macro Recognize A Number And Then Preform Two Tasks
Aug 24, 2009Over the weekend I had to look at 220 strings of numbers, some strings with as much as 20 numbers and determine if the numbers represented red, green, blue, or yellow and how many of each color from a parent list.
I did it all by hand. After getting help here from JBeaucaire on my tally sheet, which I successfully recreated with their guidance, I thought I might ask this question. How would one go about creating a macro that would when it seen a certain number, it would put the color in the column immediately to the left, and the number of colors in the column immediately to the left.
Identifying Tasks Based On Value Of Preceding Task
Jan 21, 2012I have a project network spreadsheet shown below and in column BT I need to identify each non-critical path task (value in column BS is "N") that has a critical path task (value in column BS is "Y") as one of it's immediate predecessors.
Predecessor tasks are listed with commas separating them in column G. They are also separated out into columns H through Q for another function in the spreadsheet.
Note: Task ID's can be numeric or text
*BGBSBT11Task IDPreceding Tasks * * * * * *(comma seperated)CP?
*12Start*Y*13aStartY*14baY*15dbY*16ebNX17cbNX18fcN*19g*N*20h*N*21ihN*22je,d,i,g,fY*23kjY*24Finishk**250***
Formula Stops Working After Performing Certain Tasks
Nov 21, 2006I was given the following formula by Domenic some time ago that I use along with VBA code supplied by Fin Fan Foom to open do a lookup on a closed workbook:
=If(ISNUMBER(MATCH(MIN(If( Date=D2,If(ABS(Time-E2)<"0:30:30"+0,ABS(Time-E2)))),If(Date=D2,ABS(Time-E2)),0)),INDEX(Contact,MATCH(MIN(If(Date=D2,If(ABS(Time-E2)<"0:30:30"+0,ABS(Time-E2)))),If(Date=D2,ABS(Time-E2)),0)),"")
Everything works fine, until I attempt to…
- cut & paste a block of cells, or
- do a SaveAs, or
- change a worksheet name
The formula will no longer function after performing any of these tasks (the cells go blank), and I have to close the workbook without saving to preserve the original workbook functionality. All other tasks, including even importing of different files into the workbook have NO negative effect.
The formula uses an “INDIRECT” named range. Sheet name changes are reflected in the named ranges, but any change of names somehow causes a malfunction (no sheet names are referenced in the VBA).
I thought that the large lookup workbook (40,000 rows) may be a problem, but even after deleting most of the data and retaining only a few rows, the problem still remained.
After the formula cuts out (after performing the above tasks), if I open up the lookup file, then the lookup will work again, but if I close the lookup file, it will stop working.
I doubt the problem is in the VBA code since IT WORKS, and besides, I have other simple VLookups formulas that also uses the same process (and VBA code) and they continue to work just fine when that one formula gives out. The only thing I can think of is that the complexity of that one formula may be an issue.
Anyway, I the original thread is long, so I’m starting a new one here. The original thread is here (Domenic’s formula, pg 7; FFF’s code, pg 8):
Dedicated Cell To Choose Lookup Table
Drag Down Numerical Value / Repeat 2 Rows And Perform These 2 Tasks In Any Row
Jul 10, 2014I am trying to drag a numerical value down (X4-X10) but I need it to repeat two rows in between, simultaneously keep the numbering in sequence only after the repeats 2 rows in between, and perform the previously mentioned 2 tasks any row in a column. So far, I have to manually enter or when I select cell X4 and X5 together ( having a value of 1 and 2 respectively) and drag, the value does not repeat 2 rows in between and does not keep the numbering in sequence after the 2 rows.
At Present:
X4 1
X5 2
X6 3
X7 4
X8 5
X9 6
X10 7
I need to have
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ] 1
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+1 1
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+2 1
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+3 2
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+4 2
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+5 2
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+6 3
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+7 3
X [nsubscript1, or nsubscript2, or nsubscript3... nsubscript10000 ]+8 3
and so on...
I have a 2000+ rows to manually input and hence it is not practical!.
Employee Schedule Lookup Time Value And Return Name For Daily Tasks
Oct 10, 2013I'm trying to auto input names from my schedule into dailytasks for my servers. Sometimes the amount of servers on a specific day changes(i.e Mondays 3 to 5 servers and Friday - Sunday there is 4-6 servers on) and times could change also as of now it works with
=VLOOKUP("6:00",AC$25:AJ$46,8,FALSE)
Not sure how to set up lookup value and return the name
Excel 2007 :: Populate Table With Tasks Listed On Three Different Sheets Using Date
Apr 16, 2013I am using excel 2007. My issue is i have a front sheet that I want to list all my tasks due within five days of the day of the month the spreadhseet is opened.
All the tasks are on two different excel sheets though and one of them i update with different tasks 2-3 times a week.
IF/VLOOKUP (set Up A Spreadsheet Which Automatically Calculates The Start And End Dates Of Project Tasks)
Feb 1, 2009I am trying to set up a spreadsheet which automatically calculates the start and end dates of project tasks, by looking at the order in which tasks need to be completed. I have attached a spreadsheet to show what I am trying to do.
View 3 Replies View RelatedCollecting Amounts Of Time For Various Tasks And Adding In Separate Page Via Menus
Dec 10, 2013I would like to create a menu representing "tasks" where an amount of "time" can be designated per option for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
So far, I've created a table where a "time" input is nested beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.
For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".
Here's the file, what I'm trying to accomplish [URL] ............
Outlook ... SMS
Sep 6, 2009I was reading http://www.excelforum.com/excel-prog...-in-excel.html And would like to give this a shot. So if you can school me a bit more on it.
Ok my cell provider is Vodafone Australia. (I cant seam to find any info on if they provide this service in australia)
http://www.microsoft.com/downloads/d...displaylang=en From reading this it uses the phone that is concted to the computer(my case USB).
Run An Outlook Calendar
Nov 17, 2008Is there a possibility to run an Outlook Calendar in Excel via code? and share it between users.?
View 2 Replies View RelatedVBA To Refer To Outlook
Jun 18, 2009In Excel, I want VBA to refer to the SENT ITEMS folder in Outlook. I want to loop over all sent items, and if the email address satisfies a condition, then record that fact in Excel. I am good at VBA in Excel, and I have a passing knowledge of VBA in Outlook, but I don't know how to refer to Outlook within my Excel VBA.
View 2 Replies View RelatedMinimize Outlook
Feb 13, 2007I have vba code that opens Outlook so I can run code to send emails...
Application.ActivateMicrosoftApp (xlMicrosoftMail)
But I don't want it to be visible, I want it to be minimized.
If I try:
Set olApp = CreateObject("Outlook.Application")
olApp.WindowState = xlMinimized
I get an error "Object doesn't support this property or method" referring to:
olApp.WindowState = xlMinimized
I've tried:
Set olApp = CreateObject("Outlook.Application")
followed later with code to send emails,
Set objol = New Outlook.Application
Set objmail = objol.createitem(olmailitem)
With objmail
.To = EMTo
.cc = EMCC
.Subject = EMSubject
.Body = EMBody
.NoAging = True
.Attachments.Add EMFile
.Send
End With
But I get an error "You don't have appropriate permission to perform this operation" referring to:
Set objmail = objol.createitem(olmailitem)
Because of the way our network is designed, the only code that works to send emails is:
Application.ActivateMicrosoftApp (xlMicrosoftMail)
Set objol = New Outlook.Application
Set objmail = objol.createitem(olmailitem)
With objmail
.To = EMTo
.cc = EMCC
.Subject = EMSubject
.Body = EMBody
.NoAging = True
.Attachments.Add EMFile
.Send
End With
but Outlook remains open the whole time the emails are being sent until it's closed by code later on.
Is there a way to minimize outlook AND use the code above?
Excel Links To Outlook?
Jul 21, 2014link a date within a Excel sheet to the Calander in Outlook so a reminder can be triggered on said date.
View 2 Replies View RelatedHow To Outlook Email In HTML
Jun 26, 2014Below I have my code that works great. What I would like to do is make it pull the .HTMLBody from a cell value instead of inbeded in the code so users can change, just like to I have it below for who I am sending it to. The issue is if I do it the same way I loose my signature and the font, size and color I have below. How can I do this.
range("P16") would be the 1st line of the mesage
range("P17") would be the 2nd line of the mesage
range("P18") would be the 3rd line of the mesage
All the sendkeys below copy a range and paste it below my message as a picture currently. That is fine.
[Code] .....
Integration Of Outlook With Excel VBA
Feb 2, 2014I'm in search of a VBA macro which will send a mail through outlook automatically with the count of files(.pdf + .msg files) in any given folder.
I work for an organization, where we use Outlook for mailing purpose.
Everyday Inventory(.pdf files and .msg files) will be saved in a folder that is to be processed.
I want a macro which should automatically send the total inventory (.pdf files + .msg files) through my outlook mailbox(say: me@outlook.com) to a my superiors outlook mailbox(say: superior@outlook.com).
If the macro sends that email to my superior before me and my superior logon to computers at perticular time (say: 7:00AM daily), need to plan our day at work.
WorkSheet Pasted Into Outlook
Jul 31, 2009I am having trouble figuring out how to paste an Excel Worksheet into Outlook. I am using '07 versions for both. I currently have code that when a button is selected, Outlook opens and has form text that I have entered. I just cant figure out how to get the worksheet pasted into the body of the email after this text. Here is what I have:
View 3 Replies View RelatedExport To Outlook Calendar
Aug 11, 2009i am using the attached sheet to export data from excel to outlook calendar from last 2-3 months. Now suddenly it stopped working for me (I didn't amend the code)
All the data i have filled in is in the correct format but the code doesn't export the data after ROW 72.
Send A .PDF Of 1 Worksheet Via Outlook
Aug 14, 2009Im searching for a way to send a .PDF of 1 worksheet via outlook. I have seached the forum, and have tried to follow Ron De Bruin's web page on how to do this but fall short. Im currently using his code to send the excel sheet.
View 3 Replies View RelatedCreate Outlook Appointment From VBA
Sep 2, 2009I am probably overengineering my macro, but I would like to setup an outlook appointment in two peoples calendars from my userform. The macro has access to the email addresses of the selected persons, I just want to send date/time and subject.
View 2 Replies View Related