Tag Archive for 'Microsoft Office'

How to create email distribute list: import contacts into Outlook contacts easily

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.

  1. Open the .csv file with Microsoft Excel or another program to prepare the data for export.

  2. The open file should be similar to the image shown below.
  3. 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.

  4. The Excel file should look like the image shown below.

  5. Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
  6. Click Yes if prompted to retain the format of the Excel file and then close the Excel program.

Continue reading ‘How to create email distribute list: import contacts into Outlook contacts easily’

Related posts

How to organize the large email boxes in Microsoft Outlook

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

Continue reading ‘How to organize the large email boxes in Microsoft Outlook’

Related posts

Cannot use right click or drag/drop of mouse in Microsoft Word and Outlook 2003

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

Continue reading ‘Cannot use right click or drag/drop of mouse in Microsoft Word and Outlook 2003′

Related posts

How to easily enter numeric characters as text strings in Excel

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.

Continue reading ‘How to easily enter numeric characters as text strings in Excel’

Related posts

Google Desktop 5.5 causes problem in Outlook 2003 which cannot open Forwarded Email Attachments

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.

Continue reading ‘Google Desktop 5.5 causes problem in Outlook 2003 which cannot open Forwarded Email Attachments’

Related posts

How to un-protect Microsoft Excel worksheet without password

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.

Continue reading ‘How to un-protect Microsoft Excel worksheet without password’

Related posts

How to resolve “The object could not be found” issue in Outlook 2003

Challenge:

OutlookIn 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 ‘How to resolve “The object could not be found” issue in Outlook 2003′

Related posts

How to play a YouTube movie in PowerPoint 2003

You TubeIf 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.

Continue reading ‘How to play a YouTube movie in PowerPoint 2003′

Related posts

[OUTLOOK] Error in registry for extension Exchange Extension

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.

Continue reading ‘[OUTLOOK] Error in registry for extension Exchange Extension’

Related posts

How to use Automation to send a Microsoft Outlook message using Access 2000

There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

  1. Initialize the Outlook session.
  2. Create a new message.
  3. Add the recipients (To, CC, and BCC) and resolve their names.
  4. Set valid properties, such as the Subject, Body, and Importance.
  5. Add attachments (if any).
  6. Display/Send the message.

Related posts

Play Music automatically in the e-mail with Outlook Express

Original title is Embedding Music into Email

Did you ever open an email and it started playing music? Want to know how it’s done? Here it is in 9 easy steps…

NOTE: This will only work using Outlook Express, not Outlook which I have tried a couple times too. Continue reading ‘Play Music automatically in the e-mail with Outlook Express’

Related posts

View the Message Source in Outlook 2003

Outlook doesn’t have a View, Source option like you’ll find in Outlook Express.It has View, Options which shows you the Internet header in a small text box.

But it only includes the Internet header, not the full message source.

Using Outlook 2003 you can view the header and source together, if you edit a registry key.

Continue reading ‘View the Message Source in Outlook 2003′

Related posts