My friend asked me to take a look at a weird issue on her Word application. No matter what she did, her words are somehow splitting onto new lines. Which left the half of her words at the first line, and the rest was at the following line. Continue reading
The small company I support bought 5 computers and each comes with a product key for the Microsoft Office 2013 Home and Business. For some reason, I put a same key for the second Office installation. And I didn’t find out till the activation process gave me the error indicating that the same product key has been activated in some place else. Continue reading
In Office Excel 2007 and 2010, there are three Freeze Panes options (Freeze Panes, Freeze Top Row, Freeze First Column) in View tab Window Group. It is easier to just freeze the first row and the first left column with the last two options. But when I select the first two rows and hit the Freeze Panes, by default Excel freezes four equal panes starting from the middle point. Then how can I just freeze the top two rows?
Just place your mouse or click the cell A3, then View / Window group / click on Freeze Panes / click on Freeze Panes. In this way, your top TWO (2) rows will be freeze.
The option Freeze Panes will freeze all rows above the currently selected cell and also all columns to the left of selected cell. So if you want the 2 top rows and no columns, then put select cell in A3 and select freeze panes. Similarly, if you want 4 top rows freeze, then click to select the cell A5, and click Freeze Panes. Or, if you want 2 left columns and no rows, then select the cell C1.
[Updated on 2008-12] This post can be treated as one of the “how-to” serials on Outlook tips.
I know we can export Contacts from Outlook directly into .csv (Comma Delimited) files, but not the same case in Distribution list. That is understandable since Distribution lists are not creating any new Contacts, just grouping these existing contacts.
But I need to export these Contacts into different .csv files based on the Distribution Lists I already created before. So I had to do extra steps to make the export happen.
Step 1: Save Distribution List as Text file
I need to post a serial how-to in Outlook for some of my clients. This one is part of “how to create email distribute list” and copy & paste from this website.
If you have e-mail addresses or other contact information in a program and want to import the data into Microsoft Outlook, follow the steps below.
Export and Convert the Data
Use the program’s export or save as feature to save the data into a “Comma Separated Value (.cvs) file to enable it to be imported to the Outlook Contact list.
Open the .csv file with Microsoft Excel or another program to prepare the data for export.
- The open file should be similar to the image shown below.
To successfully import these addresses over to Outlook proper labels must be assigned to the enteries in the Excel file. Insert a row above the current list of entries. Name the three column headings as Nick Name, Full Name and E-mail Address appropriately.
The Excel file should look like the image shown below.
- Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
- Click Yes if prompted to retain the format of the Excel file and then close the Excel program.
Last Friday, I spent half of my day on helping my friend to clean up its Outlook files. The main reason was that he kept all his emails since day one and the mail box was too huge to accept any new incoming emails (not sure the limitation on PST file from Microsoft is now still 2GB or not). I understand the importance of archiving correspondences between clients and my friend, so my strategy was to split all emails into a few PST (Personal Folders File) files which would be under the size limitation. And at the meanwhile, I set up an auto archive mechanism to move old emails to other pst file in the future automatically.
I know I was supposed to send him a detail instructions on how to do such things as my promised. But I could not get close to the computer during my busy weekend. So I am publishing all my steps here today, for him it will be a instruction via URL; and for all of you (include myself), a future reference post.
Today I tried to copy and paste an email in Outlook 2003 but found out the SELECT ALL function of my mouse did not work. I could not highlight any texts in the mail body, and I could not even see the copy & paste options and the whole context menu by right clicking my mouse.
Since I know I configured in the Outlook to use Microsoft Word 2003 as the primary email compose tool, I opened a new Word Window to see how things do in the Word. Same thing happened in Microsoft Word 2003, I could not use all my mouse right clicking.
This tips came from my mailbox as a training company’s newsletter, and I would like to share with you all since I feel it might be useful to you too. Based on the email, it should be working on versions of Excel 97/2000/2002/v. X/2003.
You’ll occasionally find that seemingly simple entries cause problems because Excel tries to interpret numeric values as a date. For instance, say that you have a column of product codes with values like 9-12, 10-22, and 8-2099, or you have data labels that describe the age ranges 1-3, 4-6, 7-9, and 10-12. Excel automatically converts the codes to 12-Sep, 22-Oct, and Aug-99. Likewise, Excel converts the range labels to 3-Jan, 6-Apr, 9-Jul, and 12-Oct.
Since last week (at least I think from then) I could not open any attached emails in my Office Outlook 2003 any more. When some one forwarded an email to me with the original emails as an attachment, I clicked the attached email but nothing happened. Even I saved it as a msg file, but I could not open and read it in Outlook 2003 by double clicking as I used to.
I did not relate this problem with my Google Desktop till I checked on the web. It Seems that anyone who enabled latest version of Google Search add-in in Outlook 2003 would have the similar problem. Besides the attached emails, they could not open the added email items in the Calendar appointments. The version of Google Desktop Personal could be 5.5 beta, or similar version of Google Desktop Enterprise. I checked mine, which is Google Desktop 5.5.0709.30344-en-pb.
Today one of my co-workers in Finance department asked me to take a look at an Excel worksheet. He needed to add something in but all modification options like Insert, Delete were grayed out. He mentioned he was not the original guy did this worksheet and the guy who did this worksheet had left.
In my Outlook 2003, I could not use my right click with all mail/calendar items, and whenever I tried to open a recurring event I got an “object not found” error message. Any new event setup after my issue was fine. Continue reading
If you like a very interest video clip from the YouTube and want to share with your co-workers in your next presentation, you should be able to play it in a PowerPoint presentation using a specific ActiveX control and the Macromedia Flash Player. Since videos on YouTube are almost flash-like files, you can add an ActiveX control to the PowerPoint slide and create a link from it to the video clip.
Please make sure you can play flash file on your computer before you proceed.
- The ActiveX control, called Shockwave Flash Object, must be “registered” on your computer for you to play the YouTube video clip within PowerPoint. If it is not registered, download the latest version of the Macromedia Flash Player from the Macromedia Web site; this will register the control on your computer.
- Older versions of the Shockwave Flash Object may be registered on your computer. To guarantee that complex animations run properly, we recommend that you install the latest version of the Macromedia Flash Player.
Today when I started Microsoft Office Outlook 2003, I received the following error message:
Microsoft Office Outlook
Error in registry for extension “Exchange Extensions”.
The syntax or format of the registry entry is incorrect. Check the registry settings and compare the registry for this extension to other extensions in the registry.
There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:
- Initialize the Outlook session.
- Create a new message.
- Add the recipients (To, CC, and BCC) and resolve their names.
- Set valid properties, such as the Subject, Body, and Importance.
- Add attachments (if any).
- Display/Send the message.