Hi, I have a 2 part question I'm hoping someone can help me with or at least point me in the right direction please.
Please keep in mind my knowledge on this stuff is very minimal. I read a bunch of the posts on here trying to see if this has already been answered but I think I'm even more confused now
I went to tasks and modified how I want the columns to look but when you open a new task, the form doesn't have most of what I want on it. I have attached a sheet that shows the form and what columns I would like to have also represented on the form. So my first question is how do I modify the form? I saw a few links that speak about modifying other forms, and notes that the task form is complicated. Does anyone have the procedures in such a way that I can understand them?
My second question, and I'm sure I am now biting off more than I can chew but... I was hoping to use outlook tasks to replace an excel sheet I had created and am wondering (hoping) if it is possible to replicate some of the things I had in excel into this form, such as:
Can this be done in outlook? Is it fairly easy? It took me a couple of months to learn how to do it all in Excel, I couldn't grasp the concept of doing any of it in VB. Those are my questions, If anyone can help or let me know of a link that even someone like I could follow it would be greatly appreciated.
I could not attach the screen shots. It said It can only be up to a 19.5K file. Even zipped it is 43K
Dave
Please keep in mind my knowledge on this stuff is very minimal. I read a bunch of the posts on here trying to see if this has already been answered but I think I'm even more confused now
I went to tasks and modified how I want the columns to look but when you open a new task, the form doesn't have most of what I want on it. I have attached a sheet that shows the form and what columns I would like to have also represented on the form. So my first question is how do I modify the form? I saw a few links that speak about modifying other forms, and notes that the task form is complicated. Does anyone have the procedures in such a way that I can understand them?
My second question, and I'm sure I am now biting off more than I can chew but... I was hoping to use outlook tasks to replace an excel sheet I had created and am wondering (hoping) if it is possible to replicate some of the things I had in excel into this form, such as:
- I have a column labeled account. I only have 10 accounts. I also have a column labeled contact. There are 5 or 6 contacts per company. If I choose an account, let's say IBM from a drop-down menu, then only the 5 or 6 contact names for IBM are listed in the contact column. If I had chosen AT&T then only the AT&T contact names would show in the drop down box for customers.
- For the accounts, I have the background of the cell a different color based on the customer. AT&T always Red and Pepsi is always Blue... easier for me to manage, I usually have 50 to 75 open task at any one time.
- Then I have another 6 columns that I can pick from drop-down menus.
Can this be done in outlook? Is it fairly easy? It took me a couple of months to learn how to do it all in Excel, I couldn't grasp the concept of doing any of it in VB. Those are my questions, If anyone can help or let me know of a link that even someone like I could follow it would be greatly appreciated.
I could not attach the screen shots. It said It can only be up to a 19.5K file. Even zipped it is 43K
Dave