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
Solved

Migrating from Office 2003 to 2010

Posted on 2012-03-19
6
384 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
  • 3
  • 3
6 Comments
 
LVL 8

Accepted Solution

by:
thomasdavis earned 500 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 500 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
My experience with Windows 10 over a one year period and suggestions for smooth operation
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 two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

839 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