Outlook Tasks

Oct 30, 2007

I 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.

View 11 Replies


ADVERTISEMENT

Set Tasks In Outlook..

Jan 20, 2010

I 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 View Related

Integrate To Some Extent With The Outlook Tasks Function

Aug 28, 2008

it 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?)

View 9 Replies View Related

Create/assign Outlook Tasks From A Range Of Cells

May 15, 2008

I 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:

View 14 Replies View Related

Schedule Tasks ..

Apr 6, 2009

Im 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

View 9 Replies View Related

Calculating Duration Of Tasks

Aug 7, 2009

I 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".

View 12 Replies View Related

Calculating Duration Of ALL My Tasks

Feb 2, 2009

I 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!)

View 9 Replies View Related

Distribute Duration Evenly Amongst Tasks?

Sep 10, 2013

I'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?

View 5 Replies View Related

Two Tasks, Same Macro? (put A Value In A Single Cell)

Nov 1, 2009

I want to put a value in a single cell - A1 is going to be (say) 5.

View 5 Replies View Related

Schedule A Macro To Run With Scheduled Tasks?

Jan 28, 2003

I 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 Related

OnTime Not Firing Via Scheduled Tasks

Dec 27, 2006

I 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).

View 7 Replies View Related

Macro Recognize A Number And Then Preform Two Tasks

Aug 24, 2009

Over 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.

View 6 Replies View Related

Identifying Tasks Based On Value Of Preceding Task

Jan 21, 2012

I 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***

View 7 Replies View Related

Formula Stops Working After Performing Certain Tasks

Nov 21, 2006

I 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

View 9 Replies View Related

Drag Down Numerical Value / Repeat 2 Rows And Perform These 2 Tasks In Any Row

Jul 10, 2014

I 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!.

View 11 Replies View Related

Employee Schedule Lookup Time Value And Return Name For Daily Tasks

Oct 10, 2013

I'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

View 4 Replies View Related

Excel 2007 :: Populate Table With Tasks Listed On Three Different Sheets Using Date

Apr 16, 2013

I 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.

View 9 Replies View Related

IF/VLOOKUP (set Up A Spreadsheet Which Automatically Calculates The Start And End Dates Of Project Tasks)

Feb 1, 2009

I 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 Related

Collecting Amounts Of Time For Various Tasks And Adding In Separate Page Via Menus

Dec 10, 2013

I 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] ............

View 1 Replies View Related

Outlook ... SMS

Sep 6, 2009

I 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).

View 6 Replies View Related

Run An Outlook Calendar

Nov 17, 2008

Is there a possibility to run an Outlook Calendar in Excel via code? and share it between users.?

View 2 Replies View Related

VBA To Refer To Outlook

Jun 18, 2009

In 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 Related

Minimize Outlook

Feb 13, 2007

I 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?

View 9 Replies View Related

Excel Links To Outlook?

Jul 21, 2014

link a date within a Excel sheet to the Calander in Outlook so a reminder can be triggered on said date.

View 2 Replies View Related

How To Outlook Email In HTML

Jun 26, 2014

Below 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] .....

View 1 Replies View Related

Integration Of Outlook With Excel VBA

Feb 2, 2014

I'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.

View 3 Replies View Related

WorkSheet Pasted Into Outlook

Jul 31, 2009

I 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 Related

Export To Outlook Calendar

Aug 11, 2009

i 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.

View 11 Replies View Related

Send A .PDF Of 1 Worksheet Via Outlook

Aug 14, 2009

Im 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 Related

Create Outlook Appointment From VBA

Sep 2, 2009

I 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







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