?
Solved

Migrating from Office 2003 to 2010

Posted on 2012-03-19
6
Medium Priority
?
390 Views
Last Modified: 2012-07-08
I’m in the midst of migrating to a new computer and from Outlook 2003 to 2010.  I didn’t upgrade from Office 2003 to 2010 on the new computer, I installed 2010 as a new install.

I’m looking for solutions for migrating the following from 2003 to 2010:

1.      How do I copy my Outlook email signatures?
2.      How do I copy my Outlook email address auto-fill?
3.      How do I copy my AutoText?
4.      How do I copy my Excel macros?

Thanks!
0
Comment
Question by:GregMcKim
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 8

Accepted Solution

by:
thomasdavis earned 1500 total points
ID: 37739546
0
 

Author Comment

by:GregMcKim
ID: 37740018
thomadavis,

Thanks for your prompt response.   I visited your suggested sites and here are my results:

How do I copy my Outlook email signatures?
It appears these have to be copied and pasted individually.  I have about 20 email signatures.  It will probably take less time to copy and paste these then to continue searching for a solution to copy them en masse.

How do I copy my Outlook email address auto-fill?
I competed this successfully.

How do I copy my AutoText?
I successfully copied my AutoText from Word 2003 to Word 2010 with a Normal.dotm file.  I also created a NormalEmail.dotm file, either AutoText nor the Building Blocks feature is not present in Outlook.  I activated Macros in Word and Outlook.  Any ideas for this one?


How do I copy my Excel macros?
I activated Macros in Excel.  The macros I’ve recorded over the years are working fine.  A macro I wrote many years ago is not working.  When I try to run it, the following message appears:

“Could not load an object because it is not available on this machine”.

This is confusing to me considering the fact this macro is located in my macros list along with all of the others.  Any ideas?
0
 
LVL 8

Assisted Solution

by:thomasdavis
thomasdavis earned 1500 total points
ID: 37741832
For signatures
Usually these files are stored in C:\Documents and Settings\User\Application Data\Microsoft\Signatures or similar directory.
Each of the Microsoft Outlook signatures you have are backed up as signature.txt, signature.rtf, and signature.htm, where 'signature' is the name of each of the signatures you have.
Once you have located them, select each of the signatures you wish to backup and copy to your backup destination.
For auto text in outlook since outlook 2010 doesn't use work as html editor you can refer here for help with auto fill. Building bock feature is in word
http://answers.microsoft.com/en-us/office/forum/office_2010-office_install/can-autotext-from-outlook-2003-be-imported-into/ebe00eac-c428-41a5-b019-225d539ed702
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 8

Expert Comment

by:thomasdavis
ID: 37741941
For the Macro Did you Export from 2003

Press "Alt" + "F11" together from within Excel 2003 to open the Visual Basic Editor (VBE).
Click on a macro name in the left sidebar to open the module window.
Click "File" > "Export File."
Click the "Save In" drop-down folder to choose a location to save the file, then click "Save."

Then Excel 2010 Import

Open Excel 2010.
Press "Alt + "F11" together to open the VBE.
Click "File" and then click "Import."
0
 

Author Comment

by:GregMcKim
ID: 37745393
Here’s my status:

Email signatures:  I created them individually in Outlook before reading your suggestion.  Rats!

AutoText:  I successfully copied my 2003 AutoText entries to Word 2010 using several sites I found online.

Excel macros:  I spent about two hours trying your suggestions unsuccessfully.  I don’t have time to continue this, but will work on it again later this week.  I may end up writing the macro from scratch.

Thanks for all of your help!
0
 

Author Comment

by:GregMcKim
ID: 38064805
i've not had time to try all of these solutions but want to keep this question open
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question