Daniel Curran on July 15th, 2008
(2 votes, average: 6.00 out of 6)
Loading ...
(2 votes, average: 6.00 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 13th, 2008 at 11:18 am
I use Access 2007 as a rolodex. it has over 6,000 names. I filter down to about 500 cutting and adding names regularly. Then I use a query and export the data from the created table into Outlook 2007 contacts. I have to delet all the contacts first or my contact folder will grow too fast.
How can i get the "picture" on the business card to automatically update, either through Outlook itself or by mapping it from Access?
Thanks
December 16th, 2008 at 8:03 am
Hi,
Is it possible to import events from excel into outlook, or to have outlook automatically generate events from an excel spreadsheet without manually entering all the information?
Thanks
December 16th, 2008 at 10:36 am
I am trying to sync OL2007 with my Blackberry. I use OL connector so my addresses and contacts are in the hotmail folders. Bberry only recognizes the folders in Personal folders so I have tried to copy my data from my hotmail folders. No prob with contacts cos I can copy and paste but I can only copy the whole calendar folder and that generates a calendar sub folder, which the BB does not find. How do I copy the calendar data into the root personal folder calendar?
Or am I being stupid and missing a much simpler way to do the whole thing.
Thanks for your help
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.....rt-a-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.....rt-a-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.
December 25th, 2008 at 7:03 am
How do I insert a name & address, part of an Outlook 2007 contact, into a Word 2007 document
January 5th, 2009 at 12:05 pm
I would like to sync two outlook [calenders/tasks/contacts/notes..] each installed in a separate computer with my windows mobile 6.1 phone. I have no problem sync'ing with between the notebook and the phone. Then I installed outlook on a desktop and the problem is that while the vast majority of the info syncs to the desktop, not all of the info syncs to the desktop. Due to privacy paranoia [per my friends], I do not want to use google calendar or anything that would put the info on any servers… Thank You, Steve
January 6th, 2009 at 6:48 am
Outlook with Vista. Dailey calendar. Time interval 15 min. Looks fine on calendar but print preview and print revert back to 30 min. interval. How do I print calendar with intervals less than 30 min.
January 6th, 2009 at 11:52 am
http://danielcurran.com/outloo.....ap-the-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 10th, 2009 at 3:04 am
How do I make Outlook 2007 show 3 calendars in the navigation pane? This month and the next two months. I accidently made it happen once while trying to do something else and cannot remember how now.
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 11th, 2009 at 12:47 pm
OK, this is on the right track. I cannot resize the Mail,Comments, Calendar section. On pointer on bar it shows two headed arrow, but I cannot make any changes. I did remove Tasks and calendar two appeared. There is a section between My Calendars and the bar of Mail, Comments, Calendar that contains links to "How to Share Calendars", "Search Calendars Online", "Add New Group", and three other links. It appears that if I can either shrink that or remove it I will have the calendars I need.
How do I do that?
January 12th, 2009 at 7:03 am
I have 2007 Outlook. Can I shade a time frame of 11:00-2:00 as a background feature. I know about catagories and do not like that view. I simply want to "shade" a time frame everyday as a reminder. Thank you for any help you can offer.
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 5:51 am
I have a calendar I wish to delete from out look 2007, but when I right click on itto delete it, the option is greyed out, while for my other calendars, the option is there. I would just rename it but that too is greyed out. Please help!
January 13th, 2009 at 10:03 am
How do I make an excel worksheet 'live' in a powerpoint presentation – ie demonstrate a calculation when doing a presentation. I've followed instructions for embedding excel worksheet object into powerpoint but when I display as a presentation the excel worksheet opens as a 'fixed' image – and I want to do simple demonstration of what happens if you alter one figure to a whole load of other numbers.
Thanks very much
Geraldine
January 13th, 2009 at 10:45 am
http://www.indezine.com/produc.....nt/cool/...
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 5:09 pm
Daniel's comments on i-Phone synchronization with Toodledo are spot on! I did the Toodledo / Chromatic Dragon "thing"….works flawlessly. A perfect solution. Thanks Daniel. My i-phone now more valuable thanks to you, Toodledo and Chromatic.
January 19th, 2009 at 7:04 pm
Glad to help! Feel free to Beer Me!
January 21st, 2009 at 6:04 am
How To Sync Palm contacts and calender with Blackberry curve
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 24th, 2009 at 5:24 pm
"Embedding An Outlook Calendar Event in an Office Document" is not the approach I am looking for…
I was sent an e-mail that when I clicked on the "add this event to your calendar" the event was automatically placed on my calendar – there was no need to save it to my calendar – How is this accomplished?
January 25th, 2009 at 2:14 pm
How do I sync my Office 2007 calendar on desktop to my laptop?
January 26th, 2009 at 7:33 pm
See this tutorial: http://danielcurran.com/instru.....-two-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 27th, 2009 at 8:25 pm
Outlook 2007. I like to start a new outlook.pst at the beginning of each new year. I rename the old outlook.pst outlook2008.pst and can access last years e-mail if necessary. My problem is that I want to migrate my calendar just like it it to the new year. I can make a "CALENDAR1" which is a copy of the last years calendar, but I still have CALANDAR which does not carry over my previous entries. I can not delete CALENDAR and rename CALENDAR1 to CALENDAR. It won't let me. What can I do when I start a new year?
I figlured out a way to copy all my contacts from the previous year and have no problems with CONTACTS.
January 28th, 2009 at 6:39 pm
ok, I have looked all over Google and Microsoft's page but just can't find the answer. Here's my problem. I have a calendar that is located in our public folders and I copied it so that it would show up under my calendar for easy access. I have added many, many appointments, etc to the calendar that is under my calendar but it is not synchronizing up with the public folder calendar (which is technically the same calendar). How can I accomplish that? BTW, I'm using Outlook 2007.
January 29th, 2009 at 5:24 am
Generate a weekly calendar reminder with content details from a monthly calendar. Currently using an excel template pulled off of the microsoft template site and need to create a weekly email reminder
January 29th, 2009 at 6:30 am
Thanks for the info Dan – was very helpful – Luv Ya Work!!!
Disee
January 29th, 2009 at 4:32 pm
Hi, My question is regarding Inbox and Sent folders in Office 2007. I have a laptop that I take with me on the road and a desktop at home. Both are running Office 2007. Is there a way to sync or combine the contents of the inbox and sent folders so that they each show the combined total of both? Thanks.
February 3rd, 2009 at 8:21 am
How do I link date field in Excel to Outlook reminder so that i get reminderson lthe dates specified in the excel file
February 3rd, 2009 at 11:17 pm
can i merge portions of different outlook profiles on the same computer? for example, i have a work e-mail account and a personal e-mail account on one computer. i don't want to merge the mail i receive between the two accounts but would like to see only one calendar, one tasks list, one address book, one set of notes. thanks
February 5th, 2009 at 6:58 am
how to make a document that can be used in word and converted in excel and powerPoint
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.....eate-a-r...
February 19th, 2009 at 3:08 am
Try this post: http://danielcurran.com/outloo.....eate-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 8: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.....eate-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 8: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...../Amazing...
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.