Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Migrating from Office 2003 to 2010

Posted on 2012-03-19
6
Medium Priority
?
392 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

636 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