We use SharePoint 3.0 for quite a bit of document collaboration. Unfortunately, when using Internet Explorer 8, an error is thrown when we attempted to upload multiple documents within SharePoint. The error details mention Library Not Registered.

Luckily, there is an easy fix:

• Open up any MS Office 2007 product. In my instance, I used Office 2007.
• Go to Help>Office Diagnostics.
• Run diagnostics. This took about 5 minutes to complete.
• Return to your SharePoint site. the multiple document upload tool should now be working. Apparently, this fix re-registered any .DLLs that were causing the error. I love easy fixes!

Thantos Office 2007

We have to convert a lot of Microsoft Excel sheets to PDF format.  Unfortunately, multi-column sheets (for example, 5 columns of contact information: names, addresses, email addresses) take up a lot of real estate, so Adobe PDF usually breaks the sheet into 2 or more pages of columns.   One easy way around this is to enable WORD WRAP in Excel, then resize the columns; use Print Preview to remove any borders/padding, and you can get most things to fit across one page.

Here is how to enable Word Wrap in Excel (2003 and 2007 version):

• Hold Control and then click on the top column header (usually has a letter next to it) for each column with content.  You want to get all of your columns (with data in them) highlighted.
• Press CONTROL and the 1 key;  this will open up the FORMAT CELLS menu box.
• Choose the ALIGNMENT tab, and then put a check next to WRAP TEXT.  Press OK.  Here is what the menu should look like:
  

  Choose Wrap Text from the MS Excel FORMAT CELLS menu.

  Don’t forget to use the PRINT PREVIEW (FILE>PRINT>PRINT PREVIEW) to take a peak at your sheet before printing.  You might have to edit  the margins to get everything to fit as needed.  (Put a check next to SHOW MARGINS at the top menu).

  You should now be ready to print to PDF!

Thantos Office 2007

Microsoft Excel is a great program, especially when you are created delimited files to import into MySQL databases. However, when you have commas within data columns, using commas as the delimiter will ruin your day. A better approach is to use semi-colons as the delimiter…But Excel does not give you this option. So, the easiest approach is to make this change in the Windows settings.

To do so:

1. Go to START>SETTINGS>REGIONAL AND LANGUAGE OPTIONS
2. Click on the CUSTOMIZE button
3. Next to LIST SEPARATOR, type in a semi-colon (;)

This will set the default delimiter value to a semi-colon.  So, when you save a file in Excel as .csv, you will have semi-colons to separate the row data.

Note: I used Windows XP for the above settings.   A different flavor of Windows might have different options.

Thantos Office 2007

I have a ton of messages in my Personal Folder in Outlook 2007. However, I want to quickly add them to my gmail account. After a bit of research, I found an easy, straightforward method to do just that.

First, we will need to enable IMAP in Gmail:

1. Sign in to your Gmail account.
2. Click on Settings (the link should be at the top of the page)
3. Choose Forwarding and POP/IMAP.
4. Choose Enable IMAP
5. Choose Save Changes

Now, we need to configure Outlook to connect to the Gmail account:

1. Open Outlook.
2. Click on Tools>Account Settings.
3. Click New.
4. Enter your display name, email address (including ‘@gmail.com’), and password.
5. Select the ‘Manually configure server settings or additional server types‘ checkbox.


Step 1 of Configuring Outlook to connect to Gmail.

6. Select Internet E-mail.
7. Settings: name, full email address (including ‘@gmail.com’ or ‘@your_domain.com’)
   • In the Account Type dropdown menu, select IMAP; enter the incoming and outgoing server names shown below.
   • In the ‘User Name’ field, give your full Gmail address, including ‘@gmail.com’ or ‘@your_domain.com.’
   • After creating these settings, clicking Next takes you to the end of the setup.
   

   Step 2 of configuring Outlook to communicate with Gmail.

8. In the Tools menu, select Options then Mail Setup. Under ‘Email Accounts,’ click E-mail Accounts.
9. Select an account, and click Change above the list of accounts. Click More Settings, then the Advanced tab.
   • Incoming server must be 993, and must use SSL encryption.
   • Outgoing server can use 587, TLS encryption.
   

   Configuring Incoming and Outgoing information for communication between Outlook and Gmail.

10. Click the Outgoing Server tab. Make sure that ‘My outgoing server (SMTP) requires authentication’ is selected. The  button ‘Use same settings as my incoming mail server‘ should also be selected.


Internet Email Settings for communication between Outlook and Gmail.

11. Click OK > Next > Finish > Close > OK.

You can now drop and drag folders/messages from Outlook to your newly created Gmail account from within Outlook. When you create new folders, this will create new labels/folders in your Gmail account. One note: sub-folders do not seem to display within Gmail, so you might need to create new folders for each of your sub-folder. Once you have copied everything over to Gmail, you can simply remove the new account from within Outlook.

Thantos Office 2007

If you are like me, you get a lot of email messages with attachments in your Outlook email account.  Wouldn’t it be nice to automate the migration of these attachments to a folder of your choosing?  Well, you can, and we will show you how. Read more…

Thantos Office 2007