Daniel Curran on July 15th, 2008
(3 votes, average: 5.33 out of 6)
Loading ...
(3 votes, average: 5.33 out of 6) Loading ...
This started off as a family and friends page for family and friends.
I wanted to archive how-to’s and what’s ups here in plain, easy to understand English with concise examples.
I am amazed at how fast the site visitorship is growing and am happy to share my computer and internet knowledge with anyone who asks.
If you have a “How-To” request please fill in the comment form below with as much detail as possible.
I will post the solution and directions as soon as I can get to it and in the meantime, people can respond here as well.
Want to express your thanks? You can buy me a beer or something inexpensive (or expensive!) from my Amazon wish list. Both have links to the right.
Cheers!
December 11th, 2008 at 11:18 am
Enter your How To request as a new comment, reply to other requests
December 11th, 2008 at 11:20 am
Make a "How To" request by selecting POST A NEW COMMENT, reply to other requests by selecting POST REPLY under the comment.
Also check out the "Follow This Discussion" options to see if your question is answered.
December 17th, 2008 at 5:50 am
In outlook go to FILE –> IMPORT EXPORT –> EXPORT TO A FILE –> Select Your Preferred Format –> In the folder tree select CALENDAR
December 17th, 2008 at 5:55 am
Anything is possible with enough time, money and programming skills! What you are looking it takes a whole lot of customization and VB coding – in the end I suspect it would take much more time and effort that it is worth.
If you look at the tutorial: http://danielcurran.com/instru.....dro… there is a section on the developers tab. There may be a function to create an Outlook event – see if that gets your creative juices flowing and I'll come back to this question later
December 17th, 2008 at 6:00 am
Sounds like you are an advanced user – make sure the Developer option is activated (see http://danielcurran.com/instru.....dro…) and when in Outlook, open a contact, select the Developer tab and then DESIGN THIS FORM.
You will see the field names just like you do in Access.
January 6th, 2009 at 11:52 am
http://danielcurran.com/outloo.....e-t… Calendar Printing Assistant
January 6th, 2009 at 11:55 am
In Outlook 2007 Select MAILINGS from the top ribbon – that'll get you started until I do full post on this at some point
January 6th, 2009 at 11:55 am
In Word 2007 Select MAILINGS from the top ribbon – that'll get you started until I do full post on this at some point
January 11th, 2009 at 3:07 am
I have tried the calendar assistant. Did not seem to help.
January 11th, 2009 at 12:03 pm
You need to shrink the "Mail, Comments, Calendar, etc" section. Grab the horizontal bar just above the Mail icon and drag it down. This will expand the calendars in the Navigation bar.
January 12th, 2009 at 11:13 am
I'm with ya – I cant imagine why you can't shrink the Mail, Calendar, Comment section . . the bar above it has 5 "dots". Mouse over and you get the two headed arrow, click and drag the box down.
You can also try right clicking on the "Other Calendar" and select "Remove Group"
January 12th, 2009 at 11:15 am
I don't see a way to just shade a block of time – its a calendar and therefore assumes you are adding appointments. You would actually have to create a calendar entry, make it repeating and give it a category color
January 13th, 2009 at 10:45 am
http://www.indezine.com/produc.....ol/…
So as to not reinvent the wheel . .
January 13th, 2009 at 11:28 am
Reduce the hours printed to "8am – 5 pm" or something else in a 9 hour scale, this will print in 15 minute increments. – Posting this to the main page and deleting this thread soon.
January 13th, 2009 at 11:23 am
That calendar you cannot delete is your primary calendar. The other ones must have been added later. I don't think you can delete the primary one. What you can do instead is move all of your appointments from one of the other calendars to the primary and delete the old calendar.
Kind of a pain in the rear the first time but it will save you headaches down the road! Don't forget you can use the FILE –> IMPORT / EXPORT options to make it a little easier.
January 14th, 2009 at 11:27 am
Thanks very much
January 19th, 2009 at 7:04 pm
Glad to help! Feel free to Beer Me!
January 21st, 2009 at 11:42 pm
I have neither but the answer is going to be to use a go-between. Sync the palm to Outlook, and then sync Outlook to the Blackberry – or something very similar (Windows Live, Google, Etc.)
January 26th, 2009 at 7:33 pm
See this tutorial: http://danielcurran.com/instru.....mic…
January 26th, 2009 at 7:37 pm
There are several ways:
Pick a Calendar entry in Outlook, right click and FORWARD. This will open an email with the calendar file attached. You could email that to someone and when they open the attachment they will be prompted to add it to their calendar.
You could also save that file on a server and link to it. Clicking the link will open an "Import?" box as well. I would guess this iscloser to what you received.
January 29th, 2009 at 6:30 am
Thanks for the info Dan – was very helpful – Luv Ya Work!!!
Disee
February 11th, 2009 at 10:50 am
Hey Daniel, I just like to say that I love your blog. Your How-to's for the iphone were exactly what I needed. You have inspired me to start my own blog. My question is 'what software do you use to maintain your blog'? Maybe you can release a How-to blog post? Thanks
Dan C
February 11th, 2009 at 4:19 pm
I am using the Toodledo and Chromatic Dragon and it works fine except that before it allows syncing with the Chromatic Dragon it states in a pop-up window that "a program is trying to access email address information stored in outlook" I then have to allow access in order for the sync to continue. Is anyone having this same message and is it a concern for security?
February 13th, 2009 at 6:27 am
Yea I'm having the same issue. I choose to live with it but if anyone has found a solution that would be great.
February 19th, 2009 at 3:07 am
I am using WordPress on several sites and love it!
February 19th, 2009 at 3:07 am
Answer is in this post: http://danielcurran.com/outloo.....a-r…
February 19th, 2009 at 3:08 am
Try this post: http://danielcurran.com/outloo.....a-r…
February 19th, 2009 at 3:08 am
Glad to Help!
February 19th, 2009 at 3:10 am
I am using WordPress on several sites and love it! However its not for beginner – beginners. Maybe a "How to Set Up WordPress" is in order! WordPress is easy, its the server side that is new to a lot of people. Setting up the SQL database isnt hard. Good food for thought. Thanks!
February 19th, 2009 at 3:11 am
I'm pretty sure the answer was in the comments of that post. I just have my Outlook security settings lowered because I have a goood virus scanner but htere is a nother setting. I'll try to remember to come back to this
February 19th, 2009 at 3:11 am
I'm pretty sure the answer was in the comments of that post. I just have my Outlook security settings lowered because I have a good virus scanner but there is another setting. I'll try to remember to come back to this
February 19th, 2009 at 3:12 am
Yes – very easy, I'll post it soon
February 24th, 2009 at 12:44 pm
Hi. I'd like to embed an outlook form link into a word document. When the user clicks on the link in the word document, an email with the TO and FROM fields populated along with the form in the body of the email. The user does not have to be logged into outlook (of course when they click the link, outlook will open). Please let me know how I can do this.
Thanks!
February 25th, 2009 at 11:31 pm
Copy the Macro from the Excel sheet here: http://danielcurran.com/outloo.....a-r… and create the button in word!
February 26th, 2009 at 7:46 am
i want to import calender from excel into my outlook calender
March 13th, 2009 at 8:04 pm
I would like to change the default calendar on my Outlook account but can' t find information on how to do this.
March 22nd, 2009 at 10:38 pm
Hello – hope you can help with this Outlook dilema. We operate a small network using SBS 2003. My Outlook calenadr is the primary calendar that my wife has permission and access to so she can add and delete items, The problem we have is that our windows mobile 6.1 HTC phones only sync with your primary calendar. So my wife does not see any of our calendar events but needs to.
In the absents of using something like ADD2Exchange to share the calendars is there a temportary fix we can use so she can access a joint calendar, making changes as needed and use the same calendar as her primary calandar. We both need to see the same calandar.
What if I set up a Google calendar, gave her access, then she could sync with it as could I?
Thanks for any help you can provide,
Colin
March 26th, 2009 at 8:50 pm
I have Outlook 2007 and Google sync on my computer. I have my own calendar and a work calendar in overlay mode on my Outlook. When I sync Google to Outlook, it shows all the appointments in Outlook. But when I sync to my phone, it is not taking anything from Google. I have tried everything!
March 28th, 2009 at 10:06 pm
Recording information in Outlook Journal
I recently found this and it mentions tracking time while working on a project in Microsoft Office Word. However, it doesn't mention exactly how to do this. I've done some searching but haven't been able to find anything. Does anyone use this, or know how it works? The full description is below.
<<In addition to tracking Microsoft Office Outlook items (item: An item is the basic element that holds information in Outlook (similar to a file in other programs). Items include e-mail messages, appointments, contacts, tasks, journal entries, notes, posted items, and documents.), such as e-mail, or other Microsoft Office documents, such as Microsoft Office Word or Microsoft Office Excel files, you can keep a record of any interaction that you want to remember.>>
Thanks!
March 28th, 2009 at 9:21 pm
Сравнительно недавно попал на Ваш сайт, теперь каждый вечер захожу посмотреть, не написали ли чего новенького.
К сожалению только Вы не каждый день Ваш сайт обновляете 
April 4th, 2009 at 11:15 am
How do I set up outlook so that I can send an automatic email to a group on a certain calendar date and time. Basiclly every Saturday at 21:30 an email is sent to remind someone to do something.
April 8th, 2009 at 3:20 am
Need help here. Using Outlook 2007, need to change the username printed when print the calendar in 1 month layout, because PC transfer to another user. How to change the username.
April 8th, 2009 at 5:12 pm
How can I transfer my information fromPalm to outlook
April 8th, 2009 at 5:14 pm
How can I transfer information from Palm to outlook?
April 12th, 2009 at 12:02 pm
I have a list of items saved in Word 2007. I would like to move this list to the notes section of outlook 2007. How do I do this? Thanks,
Jerri
April 18th, 2009 at 4:14 am
I am syncing outlook 2003 with toodledoo.com and my iphone 3G. I noticed today that a task I entered on my iphone did not show up in outlook after multiple phone-to-PC syncs. I clicked on the Toodledo Outlook Sync button and selected manual sync and the task immediately popped into outlook. I have a couple of questions. 1) How/when does info I enter into the iphone get into toodledo.com? 2) Do I always have to use the manual sync button to get the tasks from Toodeldo.com to the PC? I have some setting set to allow syncing every hour and it does prompt me for permission every hour to access my outlook contacts. Thanks.
April 18th, 2009 at 11:07 pm
i would like delete all yahoo messenger 9.0 s if you would please
cause we have eorrors in them 9.0s
thank you for your hlep
April 27th, 2009 at 10:42 pm
You have probably answered this, and if so, could you direct me to that area of your website? I have a work computer, a home computer, and an iphone. I use outlook at work, and would like to sync the folders and subfolders to my home computer and iphone, but there are alot of them. I tried the trial of Mobile Me, but didn't really set up the folders, just let it sync my contacts and calendar, and that was great, but now that the trial has run out, I can't get those to sync to my iphone at all, so I'm looking for an easy way to get all three devices synced.
May 1st, 2009 at 2:59 pm
Hi Daniel,
I was searching around for some vbs macros code to do some automation work but haven come across with any that really work. I stumled onto your site and it is great, I started to work on the tutorial for sending email from excel it is a great piece of work that you did. If you don’t mind that I request a small tutorial from you, So here is what I am looking for.
I would like to have a vbs code or macros that will automatic send an outlook (outlook 2000) mail to a recipients with some sort of attachment file attached on a given date and time. Your help would be very appreciated.
JiMMY
May 5th, 2009 at 12:17 pm
Copy Appointments onto a second Calendar in Outlook:- I wish to make an appointment on say our Central Calendar, visible to all my colleagues & also to copy it to my Personal Calendar [I only wish to copy some Appts, not every one, so synch'ing is not an option here] I can put a Move to Another Folder button in the tools bar, but cannot find a Copy to say My Calendar. Any ideas please?
May 6th, 2009 at 11:09 am
I use Word to record minutes of meeting. How can I assign action items from the Word document directly to tasks in Outlook?
May 16th, 2009 at 5:53 pm
Does anyone know how to populate an appointment with a reminder in outlook with a date from an Excel file?
May 18th, 2009 at 6:29 pm
Use One Note
June 6th, 2009 at 11:32 am
I AM A EXCEL USER. I WANT TO KNOW HOW I CAN ARRANGE DATA AUTOMATICALLY IN THE FOLLOWING CITUATION. I WANT TO TABULATE 10 ROWS OF DATA IN 10 ROWS. IF ANY ONE OR MORE CELLS IS BLANK I NEED TO AUTOMATICALLY ARRANGE THE CELL'S VALUES BY OVERLAYING DATA FROM THE NEXT BOTTOM ROW. PLEASE REPLY
July 3rd, 2009 at 8:17 pm
Daniel nice site. I liked the how to on how to sync outlook tasks. Worked like charm both the free way and the 10 way.
Say is this site Word Press with a plugin for the comments?
David Marks david@dmarks.org
July 6th, 2009 at 3:25 am
Dear Daniel
I tried to install the Toodledosync Download application onto my PC but an error message came appear and it says – "Error 1001. Could not load file or assembly 'sorttbls.nlp' or one of its dependencies system could not find the file specified….
Please help, thanks!
July 8th, 2009 at 11:16 am
I have a Nokia E51 mobile that is supposed to be compatiable to Outlook on my Toshiba laptop but I cannot get it do do what it is supposed to
July 12th, 2009 at 5:57 pm
How do I link a specific Outlook email to a specific Excel cell? I created an Excel spreadsheet tracking my job hunt opportunities and what to link ingoing and outgoing Outlook emails to cells for specific days and specific activities related to a person or company. I read about converting an Outlook email to a Word document, saving the document, and creating an Excel hyperlink to the document. That's inefficient. I'm using MS Office 2007. I thought I could link any object/record from one Office program directly into another Office program. Thank you.
July 13th, 2009 at 11:17 am
How can I save a search in outlook '07 & re-use it? I used to be able to save searches in my Outlook 2003, but these will not now run. Example I had a search for all my Calendar entries which read 'RB out' as I share this calendar with several other people. I can then run off a list of all my planned days off to pin on our home notice board. Now I am unable to get this search with all the filters set up to run. I remember reading that MS had created a system 'update' which changed the Registry settings. Any help please?
July 16th, 2009 at 6:43 am
Hi Daniel,
I'm completely new to Excel forms. I read your tip on how to insert a calendar drop-down in Excel and that is excellent. Thank you.
However, I am trying to create a Userform using VBA as a part of a data entry exercise into a spreadsheet. Do you know how I can insert this same calendar drop-down in a Userform using VBA?
Regards,
kC
July 22nd, 2009 at 7:42 pm
hey Daniel, (Question from Bolivia) is there anyway to have outlook send e-mails with recurrence…. it would be a time saver for the office… i could just ask for reports or any duties once, and make outlook send those periodically.
is there any way to print an e-mail without printing the whole chain of emails before the last email recevied… when you go to print an email you cannot only print page 1 or 2 or 3, it only prints the entire email and it's chain.
thank you!
July 27th, 2009 at 8:06 pm
Per your suggestion I downloaded the Toodledo app so that I could keep my Outlook tasks on my Iphone. I them opened the Sync page and saw a different page then you displayed on your website. How can I use Toodledo as a standalone for my Tasks. Thanks for the help.
July 29th, 2009 at 9:42 am
hi adam i am trying to do the same thing, let me know if you have had any luck, or if you have found another program that will let me do this.
July 29th, 2009 at 1:28 pm
Hi Daniel
I have downloaded your excellent excel worksheet that sends an email alert when clicking on the email button. I have one problem however, as an experiment in row 9 I put in my email address and the email alert successfully came to me – this is fine but is it possible to have the email sent with just the middle row of text (which I put in), without the text stating about the precanned text before and after macros.
July 29th, 2009 at 1:29 pm
Also does the worksheet only send the email alerts on the actual date? What I mean is that I want to put a whole column of different dates in column F, highlight all the rows and then click on the SEND EMAIL button. But I only want the emails to be sent on the actual dates and not all at once on the same day. I did experiment with this but unfortunately it sent the emails all at once. Your assistance would be greatly appreciated Daniel. I look forward to hearing from you in due course.
PS: I’m no PC expert so if you can answer my questions can you kindly answer then as simple as possible. Thanks again Daniel.
Best regards
Darren Evenden
QC Inspector
AngioDynamics (UK) Limited
Building 2000, Beach Drive,
IQ Cambridge, Waterbeach,
Cambridge, CB25 9TE
United Kingdom
devenden@angiodynamics.com
Phone:(+44) 1223 729341
http://www.angiodynamics.com
http://www.venacure-evlt.co.uk/
August 5th, 2009 at 7:53 am
Hello, I own a bus rental company and I am trying to go from a paper system of scheduling to an easier computerized way. When I get a call from a customer, I want to be able to view a yearly calendar or be able to pick a month, then be able to pick a certain day, which would take me to a daily list of times for that day. I want to then be able to see which buses are available and already booked for that day and what time frame they are booked from. I am also wondering if there is a way to calculate automatically how much revenue the bus will bring in based on how long it is booked (each bus has its own hourly fee), I am not a computer guru, but I think I may be able to do it with some instruction. I am not sure if I should be using Excel or Access. Any help you can give me would be appreciated.
August 10th, 2009 at 4:15 pm
Thanks for the "Magic" error How To fix. Beer or book?
August 10th, 2009 at 4:16 pm
WordPress if you're ambitious. Login to blogspot.com if you've just got something to say.
August 12th, 2009 at 3:13 pm
I would like to send an email "automatically" from excel. I reveiwed your site and you provided a template on how to send an email from excel, but the email is not sent automatically, bur rather requires the user to actually go into the excel document and click send email.
I work with the US government, and I manage the access control for a building. I issue access control cards for certain periods of time, such as for 1 year. I want excel to send an email to the card holder a message 1 week before their card will expire. How do I do this? Thank you
Justin Mansfield
justin.mansfield@us.army.mil
justinmansfield@yahoo.com
August 13th, 2009 at 2:40 pm
Hello,
Where is the location of the picture http://danielcurran.com/wp-con.....ing…
It looks so amazing!
August 20th, 2009 at 5:18 pm
I'd like to keep reoccuring appointments (to take a certain medication) on my calendar, so I can sync it with alarm to my Palm phone (important) but I don't want it to show on the calendar in Outlook. I have been reading and referencing for three hours and haven't figured it out. Can you help me?
August 25th, 2009 at 7:56 am
Sharing Outlook calendars, my version is 2007, my partners is 2003. It seems that Outlook 2003 needs to be running on Exchange to be able to share calendars (we dont have exchange). Tried sharing through Google Calendar but Google wont sync my Partners back to my Outlook, – it just syncs mine.
Any suggestions?
September 5th, 2009 at 7:54 pm
Hi – I am trying to import my contacts from an Excel table into Microsoft Outlook. I keep getting a message that says: "An ODBC error has occurred in the Microsoft Ecxel 97-2003 translator while opening a file to build a field map. [Microsoft] [ODBC Excel Driver] too many fields defined."
What do I need to do to get these addresses into Outlook? Should it really be this difficult?
Thanks for your help.
September 9th, 2009 at 1:19 am
How do I embed a Google calendar into a webpage I designed using MS Word? I tried doing embed object and posting the code but it just came up gobled. I appreciate any help you can offer. Thanks
September 18th, 2009 at 1:36 pm
I am still unclear on how to sync my outlook tasks with my new iPhone. I am willing to spend the $10 or $4 or whatever, but I found the instructions in the Nov 2008 article confusing. Have things clarified in the interim?
September 30th, 2009 at 3:32 pm
Good Day Daniel,
HELP!!! I need to create a drop down menu in Excel 2007 that will allow me to select more than one choice from the list in the same cell with a comma separation. For instance, if the names are James, George, Keith, and Bob, I want to have the option to select George and Keith. I attempted to change codes in Visual Basic but was unsuccessful. Is there an easier way to do this?
October 15th, 2009 at 12:17 am
QUESTION: Excel spreadsheet with names and addresses. How do I add these to my Outlook Contacts? I'll buy you a 'Black and Tan' next time I'm there.
October 27th, 2009 at 9:48 pm
Outlook 2007 – This is a minor thing, but really a pet peeve of mine. I would like to change the default settings of an Event in the Calendar. Most of the time I don't want or need a reminder (setting to default to None instead of 18 hours). Also, I'd like it to default to Out of Office instead of Free. It seems like there would be an easy way to do this – but didn't see anything in Options, Customize, or Properties that would change this.
November 2nd, 2009 at 5:48 pm
How do I change the colour of the tabs on the autofilter drop-down menu so I can see more clearly which autofilter is on? i.e. perhaps changing the tab to red.
Thanks in advance
Terry
November 5th, 2009 at 5:18 pm
Do you have any idea of how to wirelessly sync Outlook Notes with the iPhone? The advice on Outlook tasks and the iPhone was right on. I was hoping their is a similar solution for the notes.
November 6th, 2009 at 12:39 am
The new version of Mobile Me Syncs notes. I highly recommend mobile me – worth the yearly fee!
November 9th, 2009 at 7:32 am
Hi daniel, Please help me make a good productivity sheet tracker related to retail sales>basically I need columns like Name, POS code, Invoices acheived, Target invoices over a period of 1 month.I have 10 salesman in each department so please create me a worksheet with all these in it.
Please contact me at mathson.mathai@sharafdg.com
November 24th, 2009 at 3:07 pm
New computer, windows 7,installed microsoft office & excell 2007, transfered programs etc to new computer. shows address book as wba or wab, unable to open. also unable to start new address book in microsoft word. address book appears in light print, will not open.
December 14th, 2009 at 4:22 pm
Any time a co-worker sends an invitation or recieves an invatation through Outlook I receive the invatation.. How do I remove him?
December 14th, 2009 at 7:21 pm
Daniel,
You will most definitely get something on your wish list from me if you can help me with this.
I followed you directions on installing and setting up Toodledo on my iPhone 3Gs and my tasks are syncing up between my iPhone and Outlook just fine. The only thing I can't figure out is getting alerts/reminders on my iPhone when I create a task with a reminder time in Outlook on my PC.
I see that in your instructions you said to go to "Connection Settings" on the Toodledo website and then enter following:
"myphonenumber"@txt.att.net in the address field
"1-2 hours" in the Lead time field
"999" in the Daily limit field.
BUT…I cannot find anything that says "Connection Settings" on my Toodledo page.
December 23rd, 2009 at 5:40 pm
I have a PDA running WinMobile 2003SE and it contains all my contacts and calendar events.
I just installed Outlook 2007 on my home computer that is running on Win XP Pro (SP3) that is permanently online to the internet. With Activesync 4.5 and the 2 machines connected, I am not able to sync my CONTACTS and CALENDAR.
Any suggestions why or how? It looks like I need to specify a SERVER connection (WTF?) to sync those 2 items and I don't know how to do that? ANY HELP would be appreciated! Many thanks in advance!
December 26th, 2009 at 7:11 am
plezase help me in Generating a reminder schedule in outlook through an excel
December 26th, 2009 at 8:30 pm
how do I keep my Mexican Popsicle from melting so fast?
January 4th, 2010 at 5:42 am
HOW TO synchronise Outlook tasks with Google tasks?
Is it even possible?
January 6th, 2010 at 12:38 pm
Hi! I'm a consultant and I contract through several firms that have created e-mail addresses they want me to use for my work with them, so I have four different e-mail accounts that I access through Outlook 2003. It's easy to use the right address when I reply to messages that come in to each address, but I had to pick one address as the default when I start a new message, and when e-mails are flying under deadline I sometimes forget to manually change my From address to match the client. This is bad. Is there any way to have Outlook give me a pop-up before I send asking which account I want to send from? Or any other ideas?
January 9th, 2010 at 5:37 pm
Hi Daniel,
I am an excel novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every friday. (middle east, they like to be different) My dates refer to job start and finish and i need the number of working days to automatically calculate costs on a lower table. I have seen an aray of suggestions but i cant get them to work to suit my requirements. (just calculating 6 out of seven days dosent help as a 3job with a 4 day duration falling over a friday needs to show 3 working days where as a 4 day jod mid week would show 4 working days. My dates are input from a Developer tab 'date and time picker' (thanks to your previous post) and linked to a normal cell in standard date format. NETWORKINGDAYS as you know calculates with SAT and SUN off.
is there any way to add a new formular or modify an existing…??? if not any crack at a solution would be great.
all help greatly appreciated.
January 11th, 2010 at 11:17 am
I have Office 2007 Enterprise running on Windows 7 64 bit. I have followed the instructions to install the Microsoft Date & Time Picker Control 6.0 but cannot get it to work and/or show up in my Developer Tools. Any idea how to accomplish this?
January 13th, 2010 at 8:15 pm
I have installed Outlook 2007 on both my home PC and a laptop, and have networked both via wireless broadband for file sharing. Is it possible to also network both so that the Outlook function on both machines is always in synch? In other words, how do I link Outlook on both machines so that any calendar or contact changes I make on the laptop are also picked-up automatically in Outlook on the PC, and vice-versa?
January 16th, 2010 at 12:35 pm
How to connect hot.mail to iphone?
January 19th, 2010 at 12:32 pm
I just started using toodledo. It synchronizes nively from Outlook to the web to the iphone, but not the other way round. I have added a task on te Iphone, I see this in toodledo on the web, but not in my Outlook list, although I did synchronize. A task I added in Outlook did synchronize well to Toodledo. What now?
January 22nd, 2010 at 3:13 pm
I have a laptop for home use and a laptop for travel. How can I view my outlook calendar both computers? Currently I am only able to view on my home laptop. When I open outlook on my travel laptop, the calendar is blank.
January 31st, 2010 at 6:48 pm
am having a trouble with excel that may sounds simple but is not……
i want to have a drop list with colors…………..
i want 3-4 colors in something like a pallete so the users can choose the colour they want to.
is this possible?
Thanks, i hope someone knows about it !!!!!!!
January 31st, 2010 at 6:53 pm
i forgot to mention that am trying to do the drop list with colours
on excel.
February 1st, 2010 at 5:22 am
Just wondering if you have extensive knowledge of Quicken???
February 2nd, 2010 at 5:55 am
I have opened iTunes accounts in the Portugueses, German & South African apps stores, using 3 e-mail adresses & 2 credit cards. How can I consolidate the accounts into one? (iPhone 3GS)
February 6th, 2010 at 1:28 pm
on outlook 2007, in the to-do-bar, my calendar with appointments doesn't show up. how do i tell outlook which calendar to dosplay in the to-do-bar?
February 12th, 2010 at 4:34 am
I HAVE AN IPHONE AND USE WINDOWS OUTLOOK AND ITUNES TO SYNC AND STORE MY CALENDAR AND CONTACTS. I JUST GOT MY WIFE AN IPHONE. CAN I SET UP OUTLOOK SO THAT HER CALENDAR AND CONTACTS WILL BE KEPT SEPARATE FROM MINE?
February 21st, 2010 at 10:32 am
okay, i sent my computer to a computer tech and now it signs me on my windows every time i restart my computer withoutt the password. i deleted the account and now it tries to sign on toUser namee: Owner Password:******* and an error msg occurs and sayslog inn failed and then i just sign in to windowsnormallyy… how the hell do i get rid of it ? i scanned my computer no worms, no virus… i know its a hack/ crack…. i have windows xp pro… 500 GB mem and ~4000 mb in Ram .. please tell me in the stupidest way possible.. imdyslexicc.. santoramaa
February 24th, 2010 at 6:50 pm
HELLO Daniel
I have been reading your blog about a month now and really find it informative thank you.
i would like to know how to load my owned dvd movies on to a flash drive and view from there is it possible?
thanks again
March 10th, 2010 at 4:59 pm
Here's a good one…How do I sync a shared office calendar through my exchange server so that I can view the shared calendar on my mobile device (iPhone). I can only see the calendars that are physically on my machine right now on the mobile device, but I can't view the calendar that was shared with me on my mobile device. Thanks for your help.
March 18th, 2010 at 7:23 am
Daniel..first just wanted to let you know I have learned more from you than I ever learned from 3 years at Duke and 2 years at Rice! I could've saved a ton of money had I earned my "Degrees from the School of Daniel" instead of the ones from Duke & Rice! However, I am currently suffering from a major brain fart (please excuse my language-I've spend a week trying to prove my boss wrong to no avail! Horrors – beginning to think I'm..gasp…wrong!) I'd bet my life that at one time I was able to insert a calendar into an Excel Workbook w/o using Outlook, which is all I'm wanting to do now. However, I know I was not only able to insert calendars but had also figured out how e-mail conferences I accepted automatically posted to my Excel workbooks w/o being attached/configured to my Outlook in any way. All that aside….how can I insert calendars into Excel workbooks w/o using Outlook? Thanks again for all your great advice and lessons!
April 1st, 2010 at 6:10 pm
I am trying to follow your instructions from your article: How To Create A Reminder Email For Outlook Email From Excel. When I click on 'Send Email' I am getting an error message: Run Time Error '53': File Not Found: shell 32.dll
Then it asks if I want to debug. If I click 'Debug' it has the following line highlighted
ShellExecute 0&, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus
Do you know how I can fix this?
Thanks
April 20th, 2010 at 10:47 am
How to get alerts of tasks without a push-mail ? Simply an alert on my iphone (because we are not always connected to internet)
April 20th, 2010 at 4:35 pm
How do I link a Excel spreadsheet to a Outlook Shared calender… so due dates on a particular task (spreadsheet) atomatically form an event in the calender
(no need for reminder, or email)
April 21st, 2010 at 9:24 pm
Trying to setup a van hire booking calculation (Excel) Need to know when someone select dates how many days are in each season to calculate price.
There are 4 seasons:
Winter1-May30-Sep
Spring1-Oct30-Nov
Summer1-Dec28-Feb
Autumn1-Mar30-Apr
Example: booking from 01/02/11 to 15/03/11 has to result in:
Summer: 28 days
Autumn: 15 days
Cheers, Nick
May 5th, 2010 at 2:54 pm
Daniel, perhaps I am missing a step. I have entered my unique id in Chromatic Dragon sync appl and Toodledo, but my Outlook 2003 and iPhone still does not sync . Could you please list the steps.
Thanks for your help.
-Carolyn
May 14th, 2010 at 5:11 am
Hi Daniel, the help with syncing tootledo with outlook was great. i have a bunch of old todos showing up. ihave 108 new ones in outllook for work that aren't on my iphone. how do i get them to show up? thanks, John
May 26th, 2010 at 11:34 pm
"HOW TO"
i would like to know how to sync google contacts with outlook 2007… your write ups on syncing iphone tasks with outlook via toodledo is awsome! it works great for me… i already have the google calendar syncing with the iphone now i just need google contacts to sync with outlook…
please help… thanks!
June 1st, 2010 at 5:00 pm
Hi Daniel. Thanks so much for these great posts to make life easier and more enjoyable for us all. Are you still committed to ToodHi Daniel. Thanks so much for these great posts to make life easier and more enjoyable for us all. Are you still committed to Toodledo as the best task manager for the iphone that you can sync with outlook? I'm still amazed that Apple didn't build this into the base software like calendar, mail, etc.
June 2nd, 2010 at 8:28 pm
Hi,
I used your sample code to test sending an email from an excel spreadsheet to myself using OUTLOOK. It worked fine. However, I would like to send an automated email that will look at a date and send the email if the current date is equal to the date in the cell. Is this achievable? I'm a true novice at this and have spent hours researching and trying to find the right code for this. Any assistance you can provide would be greatly appreciated. Also, I tried to put a few pieces of code I found in the sample code you provided and it didn't work. Please help….
June 18th, 2010 at 3:21 pm
Hi…
I searched your forum, but didn't see the answer to this particular issue. I'm trying to figure out (since October!) how to get my Outlook (2003) email on my iPhone. I've been told it's not a difficult process…HA! Neither hours on the phone with AT&T nor Apple have gotten it working. It floors me that I was able to set up my work email (we use an exchange server) on my BlackBerry BY MYSELF in about 5 mins, but can't get it working on my iPhone to save my life. My thought was, if there was someone that understood the blackberry & the iphone processes they might be able to help.
Here were my BB setup steps (i've generalized for security's sake):
(now, I always chose – additional settings & Microsoft Exchange – using Microsoft Outlook Web Access)
Below is what it requested:
Email Address: bobs@mycompanyname.com
Email Password: **************
Web Access URL: http://11.11.111.11/exchange
User Name: bobs
Mailbox name: bobs
And it worked like a top immediately.
I've tried several different combinations of the info above to enter into the iPhone Exchange email settings and nothing seems to work.
Any ideas?
Thanks In Advance!
Jacki
June 18th, 2010 at 5:24 pm
Hey Daniel, just wondering if there is a way to sync Microsoft outlook calendar with an iphone? Thanks!
June 29th, 2010 at 10:45 pm
In your 'How to Insert a drop down calendar ' in Excel cell, how do you add the 'Microsoft Date and Time Picker Control' in More Controls if it's not there to select?
July 12th, 2010 at 4:09 pm
I want to know if it is possible to have a drop down list in Excel 2007 witht the capability to type in text and automatically come up without scrolling the list. Example…my list has project numbers and descriptions that start with different letters, A1356A08, T1252A10, N0684B94 or E1915A09. I have it set up as a dropdown list but would like to be able to type in T and get the first T project number to come up from the list and hit enter to automatically have it appear in cell.
Is that possible? I think it can be done in Access but want it to work in Excel also.
July 12th, 2010 at 8:29 pm
syncing outlook 2007 calander with iphone 3
I have tried without results to get my calandar to transfer from my iphone to outlook. Any appointment that I put in my iphone will not go to my desktop, however, if I put the appointment on my desktop it will transfer to my iphone. anyone know how to get this to work both ways.
July 20th, 2010 at 12:20 am
can i sync my outlook email account to my iphone4?
July 28th, 2010 at 3:48 pm
IVia one way syncing, I'm downloading my family's google calendar to my business outlook calendar so that i can have everything in one place. The problem is that once this process is done, I can't tell which item comes from which calendar. Is there a way to color code what comes in from google? I tried creating a new outlook calendar where the google data could be downloaded but wasn't able to figure out how to do that. Any ideas?
July 30th, 2010 at 3:14 am
Hi I tried fixing the sync of Otlook 2010 with Google calendar and it still does not sync. I presime that when you say Launch Google Calendar Sync .exe that you mean double clicking on it or am I missing something? Cheers
August 2nd, 2010 at 3:24 am
Daniel,
Thank you for a great blog. I am still having problems getting Outlook 2010 calendar to synch with Google Calendar. Do you have any additional resources you can point me to?
Many thanks,
George
August 14th, 2010 at 7:59 am
Tasks that I enter on Outlook 2007 on my PC appear just fine in Toodledo and then on my iphone. Taks that I add on my iphone make their way to Toodledo but NEVER show up in Outlook. I seem to have tried toggling different settins but with no luck. I am an emergency/crisis reponder and twice now, this problem has added chaos to already challenging situations. Would greatly appreciate any assistance possible to remedy this. Thanks.
August 19th, 2010 at 3:13 pm
I'm new to ipod and am a non-Mac user. I found your page regarding outlook/tasks/toodledo/appigo.
I rely on outlook for calendar and tasks and so was looking for a way to sync tasks. Not having access to wifi is common throughout my workday.
The following statement on that page confused me:
"ToodleDo is now available as a native application on your iPhone. You can use it as a standalone application, or you can have it seamlessly synchronized with Toodledo.com, so you will always have access to your important tasks, even when you don’t have an internet connection."
Why/how does synchronizing with a website allow access when there's no internet connection? Or is using it as a stand-alone that provides that?
Thanks for your time. Find the right apps for different things has become really frustrating. I appreciate your knowledge.
August 29th, 2010 at 5:59 pm
I would like to know if there is a way how to synchronyze Outlook note between two PCs and Iphone , without duplicate them.
Ty,
Robert.
September 3rd, 2010 at 3:45 am
Hi Daniel, thanks for the info on the Excel calender insert, I however have a problem when I save the document and reopen, the function is corrupt and I must rerun. I am working in Excel 2010 – can you please advise.
September 14th, 2010 at 6:31 pm
Hi. I'm sorry if you've answered this one before – I have Office 2007 and have just connected Outlook with my business and personal hotmail accounts. Having done this I now have 7 calendars in Outlook. Is there any way I can delete 6 of them as I only need one? Either it cant be done or its so easy i'm missing something somewhere! Thanks
September 20th, 2010 at 11:10 am
Hi Daniel,
I followed your advice on how to put a drop down calendar into Excel. It worked well. Do you have any recommendations as to how to make the standard date not today's date but a date with blanks or dashes so that when the calendar is there but not needed it shows –/–/—- or something of the like instead of 09/20/2010 (today's date).
Thanks,
Frank
September 22nd, 2010 at 10:39 pm
My name is LTJG Justan Caesar; I’m the Training Officer onboard USS Mustin (DDG 89) stationed in Yokosuka, Japan. My command uses Outlook 2003 Calendar extensively and the question was posed is there a way to hyperlink events/appointments in Calendar. The premise behind this is that by clicking on hyperlinked event it would take you to a file/doc that had more detailed information on said event; you know the 5w’s. I have unsuccessfully scoured the internet trying to find someone who has figured out a way to do what we want to do. If you have any ideas they would be much appreciated.
September 26th, 2010 at 12:39 pm
I am using windows 2010. I have an iphone and ipad and I cannot seem to sync my calendar! HELP! Is there any hope? If the two don't talk, is there a way to use a google calendar or something else? Thanks!
October 6th, 2010 at 11:48 am
I have Outlook 2010. In it I have two profiles, one for work and one for home. I have a Google calendar and I would like to arrange it so that the edit or new appointment will be shown on all 3, is this even possible? Thank you very much, regards Mac Macdonald.
November 8th, 2010 at 1:26 am
I just added your web site to my blogroll, I pray you’ll consider doing the same.
November 10th, 2010 at 9:44 am
I have an outlook e-mail with side comments and I need to know how to get those comments to print out with the e-mail message. Anybody able to help me here?
November 20th, 2010 at 1:28 am
Hi Daniel,
I am very grateful for your how to info for iphone. When I was distracted I mistakenly hit deny when Toodledo/ChromaticDragon needed access to sync with Outlook. I have reinstalled Toodledo, chromatic dragon and outlook with no success. Toodledo data has the up to date task into, it just wont sync with outlook 2007. Can you help? Thanks
November 30th, 2010 at 8:06 am
I'd like to know if I could send an email on Tues. that places/envokes a reminder on Thursday for the Recipient's?
December 10th, 2010 at 4:12 am
Hi to all
I have a query regarding excel 2003. Actually i have prepared project deatiled data containing Due Date column. When there would be 15 days to get the due date of particular project…. i want an automatic email alert in my outlook. Please reply soon….its urgent. I am pasting that excel below here…. plz reply soon.
December 10th, 2010 at 10:41 am
I have a question about assigning appointments to a specific account. Say i have 3 email address all pop, all defaulting into one .pst file and using one calendar.
When i create an appointment, i want to know for which account this appointment is for. This works fine if i send an invite, since the invite opens up the "Account" button where i can select the email address i want to send the invite from. Outlook then maintains the Account associated with the appointment. However, without an invite how do i accomplish the same thing for my own organization? If this is possible, is there something i can activate in the appointment view/form that easily shows me which account the appointment is associated with?
Thanks much.
Anil.
January 11th, 2011 at 1:33 am
I use Outlook 2007.
When I click on the Calendar button (in the navigation pane) at the midle it
shows 'My Calendars'. Before there was in My Calendars group my own
calendar but now it's missing. How can I add my own calendar to that 'My
Calendars' group?
January 15th, 2011 at 11:55 pm
Hi Daniel,
I have a new ipod touch 4g that I want to start using for todo lists and notes. I would like it to work with my Palm Centro. It's not a smartphone, but I sync all my data to my desktop software called "Palm Desktop by Access". Is there a way to sync my "memos" and "calendar" data stored on my palm centro and desktop software with an app on my itouch? I'm hoping I can do this without too much trouble. Thanks for your advice!
January 23rd, 2011 at 6:29 am
Well isn't this special. I Google an iPhone question and the first hit is a Daniel B. Curran website. This reminds me of the Aloha.net days.
Thanks,
Russell R.
February 10th, 2011 at 7:07 am
My company has a Company outlook calendar, and I have a personal outllook calendar on the same server, how can I sync the two so that when the company makes an update on theirs it automatically updates on my personal?
February 22nd, 2011 at 11:37 am
Until yesterday, I was able to access all internet links from email in Outlook 2007. Now when clicking a link, I receive the message, "This operation has been cancelled due to restrictions on this computer". I remember the problem existed when I first installed Outlook several years age, and eventually I found some instructions on the internet which corrected the problem. I have been looking, but cannot find any suggestions that work.
Thank you,
Steven Braid
sbraid@aol.com
March 15th, 2011 at 11:36 am
Daniel, I just followed your instructions to sync my Outlook to my iPhone. I am not able to sync the folders into Outlook however. And when I am in Account Settings, I am not able to re-open the sync program. I thought perhaps I could map the folders to the Outlook categories to have them appear. Is that possible? Will you please help? Other than this issue I love the program.
April 29th, 2011 at 7:01 am
how to insert a drop down time ( hh mm ) in excel i.e ( 06 : 30 am)
May 4th, 2011 at 1:25 pm
I updated my iphon 3GS to a 4.3.3. When I did my contacts were gone. They are on outlook 03, but don't know how to get them on my iphone.
May 26th, 2011 at 4:58 pm
Hi there.
Is there a faster way to select a worksheet in an excel files? Perhaps there is keyboard shortcu that works similar to "Ctrl+G", so that i can jump to the selected worksheet instead of clicking one by one?
Thanks in advance for your help.
June 16th, 2011 at 12:30 pm
Does this work in Excel 2010?
June 21st, 2011 at 5:29 am
Hi,
I am working on creating an address book in excel.How to send e-mail on individuals birthday throught personal email account automatically ?
June 23rd, 2011 at 7:38 am
in excel i need to get my recieved requirements package column to turn red, yellow, and green depending on the timeperiod in which it took based on pricing
there are 3 pricing categories and each has a different lenght of time in which the purchase must be approved, for instance smaller $ amounts have to be approved faster to be considered green, or on time
June 24th, 2011 at 11:01 am
Is there a way to have two seperate data bases in one outlook package
July 4th, 2011 at 11:06 am
How to sync PC outlook calendars between 2 (or more) computers using iphone 4? Since iphone prefers (strongly) to only sync to 1 computer via Outlook 2007, when I sync w/ Outlook 2007 on a second PC computer I end up w/ iphone info NOT syncing to the other Outlook and/or 5 or 6 copies of the calendar event. Is there a third party app similar to Toodleo?
I do not see Gmail as a solution – the calendar doesn't like syncing w/ Outlook calendar.
July 4th, 2011 at 9:20 pm
Your instructions are great, really easy to understand and follow.
Can you please let me know how to add a drop down selection list in excel?
July 21st, 2011 at 5:50 pm
Dan,
Can you help me properly format an excel spread sheet to do what I need it to do? I can e-mail you the excel workbook I have made and the data that I'm trying to paste in. From the info I'm pasting I need excel to recognize the date in on column and automatic add three days to that date in another column. I read some where that you can make excel send reminders based on a date entry. If this is true it would be a god send to me! Lastly in another column I need it to registrar when I either check complete and it can see the original date and the date that I'm saying the project is complete and in another column show me the total days it took for this project to be compete. Basically I'm a state trooper in charge of a shift. We get a cad (report of all complaints that our officers were sent on during their shift). We then print that sheet out from an online web based word document, and hand check each complaint, each time someone sends a report in for approval we then has to flip through print outs, find the report and draw a red line through it, after that we have to look at the date of each pending report on that print out and send an email to every officer who doesn't have the report turned in in 3 days from the date they were dispatched to it. In the email we have to type in all the information that was original in the online word document. This way of doing it is insane to me. If we start with an electronic document which is laid out in a column entry I would like to just copy and paste into excel. When I paste it I want excel to see the date, add the three, days, send a reminded email if I haven't cleared it out by then, and lastly keep a sum of how many days it took the officer to complete it. I hope this makes sense to you! Please contact me at Nicole.Oldham@state.de.us if you think you can help me. I can you examples and the workbooks I've triied to set up if that helps
Thanks
July 31st, 2011 at 11:04 pm
Clothing and product professional canada goose sale , canada goose jacket committee JiangHengJie,
August 8th, 2011 at 5:41 pm
I like it
September 19th, 2011 at 5:10 am
I just used your send a reminder email macro and I love it. One thing, I am actually using another template to gather the information for the reminder email. In doing so, I am providing a formula of (=’Data Input Sheet’!D3). The funny thing is, everytime I do that it only shows ‘Data Input Sheet’!D3 in the field. All other formulas (which are alike) are working fine but not that one.
Any help would be much appreciated.
Thanks
September 21st, 2011 at 4:53 pm
Yes, this was a really outstanding post.
September 22nd, 2011 at 12:32 pm
Okay, so we have a iMac running Snow Leapard and Windows 7 under Bootcamp. In Windows 7, we are running Outlook 2010 connecting to an account on an Exchange 2010 server. Throw into the mix a Blackberry that can sync with the Exchange server and a Toodledo account.
What do we need to install on the Windows side to get all the task apps (Outlook, Blackberry & Toodledo) to completely synchronize, and what settings are needed to accomplish this, please?
September 29th, 2011 at 12:06 am
can you please make a how to for removing btguard and any scripts and forwarding we did to install it? i no longer use it, and my google redirects to the google home page when i click a link. i can click open in new tab and it works, but this is irritating. its the only problem im having.
October 20th, 2011 at 11:03 pm
I WANT TO KNOW HOW TO INSTAL A DROP DOWN CALENDER IN EXCEL 2010. MORE CONTROLS INTHE DEVELOPER TAB DOES NOT SHOW MICROSOFT DATE AND TIME PICKER 6 WHERE CAN I GET THE DATE AND TIME PICKER
December 3rd, 2011 at 9:36 am
How to migrate Outlook Express E-mail from an XP computer to a new Windows 7 computer ?
December 8th, 2011 at 6:35 am
I have a powerpoint ive made. but it would need updating everyday with the names of people that are visiting. (the names are all saved in my calandar on outlook) is there a way to get powerpoint to aoutomatically look at my calander for the day and add there names to one of the slides. Thus no need to update it daily it magically does it itself.
December 9th, 2011 at 10:39 pm
I will post the solution and directions as soon as I can get to it and in the meantime, people can respond here as well.
December 28th, 2011 at 2:26 pm
Daniel, how can you sync Outlook 'To-Do's' to iPhone if they are not Tasks?
December 29th, 2011 at 11:29 am
Hi Daniel,
Ok, so here is my delema / issue. I have a family calandar (google) and a personal calandar (also google), and an outlook (work, exchange server) calandar.
I have google sync working to sync, and it is working fine. I have my family calandar shared with my personal google calandar. When I put something on my family calandar, it posts the event to my personal google, no problem, but doesnt make it to the outlook calandar.
It all works fine, but the missing piece is the family calandar events making it to outlook. Any advice?
January 9th, 2012 at 11:42 am
How can I create and deploy a screensaver in Server 2008?
January 18th, 2012 at 4:51 pm
Dan, firstly GREAT SITE. I have been building a workflow excel spreadsheet for my company and have solved numerous issues just by using your site. I have one BIG issue realting to conditional formatting I am hoping you can help with, so here goes. The spreadsheet is designed to track the progress of the various stages of our building jobs. Each job has a row and the various stages are tracked via the columns. I have utilised a set up whereby if an item (such as a kitchen) is ordered the date of the order is entered into a cell titled "ordered" and the next cell "installed" is filled red (to indicate outstanding work) based upon the value of the previous cell "ordered" being greater than 0. SECOND COMMENT TO FOLLOW
January 18th, 2012 at 4:52 pm
Then once a date is entered into the "installed" cell it is filled green to indicate completed work (based upon its value being greater than 0) and the next cell is then filled red to indicate the next stage of outstanding work and so on. I have created a "Master Job" row with all the relevant formulas and formatting completed BUT no dates etc entered and my intention was to just copy the whole "Master Job" row and paste in as a new job and then enter dates etc to start tracking the actual job. The issue I have is that when I copy and paste the row the formulas reference the new row (realtive) BUT the formatting of the cells still looks to the master jobs rows/cells (absolute) and not at the new jobs rows/cells and all my formatting is lost and has to be reset tos uit the new row. PLEASE HELP
January 24th, 2012 at 2:34 am
Our co. is planning to make Paperless office and we have entries made in Excel 2007 like Lease contracts with Tenants, Staff Passport validity, Work permit expiry etc…
I, myself being a Document Controller, i would like to send email notification to myself to letting the concern people to follow it.
kindly help me to resolve this issue
thank you
January 30th, 2012 at 1:31 pm
I am working on a massive scheduling spreadsheet for a doctor's office and I have it all ready except for one thing that has stumped me. I have 20 boxes per day that need a time input (7:20am, etc.). I can't figure out a simple way for them to choose the time. Most of the sheet has drop down choices so that would be preferred but That would be a huge list to choose from. Any Suggestions