Solved

Migrating from Office 2003 to 2010

Posted on 2012-03-19
6
388 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 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
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.

 
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
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…

705 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