Solved

Migrating from Office 2003 to 2010

Posted on 2012-03-19
6
375 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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 Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now