Move Outlook data to another computer
Purchased a new laptop. How do i backup and move outlook
2003 from my desktop to my laptop.
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, J.J asked:
| Purchased a new laptop. How do i backup and move outlook
| 2003 from my desktop to my laptop.
...Getting appts to print on one page
I am using calendar assistant to print multiple overlaid calendars at once on
letter size paper.
All the appointments show up on the first page, except for one. This one
pushes to a second monthly page duplicating the first.
ie - I get two November 2009s - one with all appts except one and the other
page with only the one rogue appointment
I have a workbook with about 15 worksheets in it. Is there a quick way to
automatically seperate all 15 into single workbooks. or do I have to go 1 by
Try this macro
It will save each sheet in a seperte wornook in C:\
Dim a As Integer
Dim wb As Workbook
Application.ScreenUpdating = False
For a = 1 To ThisWorkbook.Worksheets.Count
Set wb = ActiveWorkbook
wb.SaveAs "C:\" & wb.Sheets(1).Name & ".xls"
Set wb = Nothing
...Setting random number range based on query, not table
I have a "quiz" form that randomly pulls up questions from my table. It
works fine, and I don't mind that it repeats questions. This allows me to
sit and review for as long as I want.
The problem is, that I want to use criteria in a query to limit the
available questions. If I base this form on a query and limit the number of
questions, the code I am using is still setting the maximum number as the
number of records in my table.
In the past, I had a similar database (which I have lost) that would open
the form, set the selector to the last record available to the form,...summing adjacent data in a worksheet
I have a column of data and I need to sum the values in adjacent cells when
they are bounded before and after by cells that contain a value of 0. Then I
need to sum the next group of cells bounded by zeros. So I want a column with
subtotals rather than one total. The number of cells in one group may vary.
I've tried using the sumif function, but what I want doesn't seem to quite
I'm using Excel 2007.
So, you have something like this:
and you want to get something like this:
...Summing instances of text across worksheets
Hello, I have a workbook with separate sheets for each month. The sheets
contain a list client names (entered exactly the same on each sheet). I need
to summarize how many times a client name appears in total. For example, John
Brown may appear Jan & Feb (=2) where Mary Brown may appear Jul, Sep, Dec
I've been trying pivot tables without luck. Hoping someone can help.
Thanks in advance!
Never mind, I consolidated all the worksheet data into one and the pivot
table works fine.
> Hello, I have a workbook with separate sheets fo...How to automatically rearrange data on a worksheet.
I am a noob when it comes to Excel, so I hope there is some of yo
gurus who can help me out with a probably trivial problem.
Thing is, I have a program that automatically logs data to a CSV file
All the data is added sequentally to the file.
If I open it with Excel it looks like this:
VarName TimeString VarValue
Test_tag_00 20-10-2005 13:41 1
Test_tag_01 20-10-2005 13:41 2
Test_tag_02 20-10-2005 13:41 3
Test_tag_03 20-10-2005 13:41 4
Test_tag_00 20-10-2005 13:48 1
Test_tag_01 20-10-2005 13:48 2
Test_ta...display the value of an unbound textbox in a field within a table
I created 3 textboxs to calculate the number of business days between 2
dates. The 3rd textbox contains the value. I now want to have this value
displayed in a table field. I'm sure this is easy but I'm a complete novice
and have spent far too much time on this already. Can anyone help!
The general concept of tables is that they are for storage of data in
the background. They are not for display of data. That is what forms
and reports are for. Therefore, the appearance of the data in the
tables is not normally relevant, and the display of calculated values is
im...lookup and match from another excel file
Curious if someone can help. I have a dispatch log that I made for m
company, I would like to set up a payroll system that will automaticl
pull all rows that meet a certain name and date range. and put it o
another new sheet for that weeks payroll if anyone has some ideas le
me know, I can post an example of my dispatch log if needed.
Sorry Sort of newb to this.
Actually here is the file, I have macros on it for sorting
Attachment filename: new daily log.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63792
Message posted from ht...How to keep display format when exporting XML?
First thank you for taking the time to read about my problem.
My problem is this.
When exporting my xml data, the time/date values loose their display
format. A time of 01:30 am, for example, becomes something like
0.001353 when exported..
What do I need to do to keep the same format as is displayed in Excel?
sure be great if you could help.
...data entry on multiple worksheets
I have a book with one master worksheet and then several other worksheets
with data from the master. Is it possible to have the data I enter or update
on the master to automatically populate the correct information into the
other worksheets, even though the other worksheets store the data on
different rows than the master?
you could use cell links such as
in your target cells
"diosdias" <email@example.com> schrieb im Newsbeitrag
news:A674ACB3-C5F7-477D-954E-561B85FF705E@microsoft.co...Moving Range Problem
I'm trying to build a 6 Sigma control chart into an excel workbook. In
order to do this i need to be able to work out a formula for the moving
I need the following :
Data sample : 210 , 425 , 600 , 550 , 450 , 470
The moving range is the distance from second to the first, third to
the second etc eg
A B C D E F
Data Sample 210 , 425 , 600 , 550 , 450 , 470
Moving Range 215, 175 , 50 , 100 , 20
The problem I'm having is trying to get excel to work it out. If say
210 was in A1 i ...Automatically display set text based on users composition
Hi, im trying to do something really simple, trouble is i
dont know what the feature's called to be able to search
for tips on how to do it.
Basically in outlook messages, when a user begins writing
a sentence e.g. "in the terms of" i need a tag to pop up
that allows the user to press enter and then the
remainder of what they will want to type in will be
inserted in, its a yellow tag that comes up above the
words. i dont know where it needs to be created and
...multiple fies updating one file
How would I setup an excel sheet that needs to collect numbers from other
excel sheets. The rows and fields numbers will keep growing.
I know how to reference a cell in a file but not sure how you can quickly
create a reference to a range of cells and how about when the range keeps
You can select and copy the range you want to link, then go to then go to
the receiving sheet and click the top right cell. Click Edit / Paste
Special and select Paste Link.
This will link the entire range.
If you happen to be running Office 2007 you can right click into the ...SFO CRM folders won't display page
SFO appeared to install correctly. The CRM toolbar buttons work fine in SFO.
But when I click on a CRM folder such as accounts, I get the following Action
Canceled error. I am running CRM 1.2 and this is on a Windows XP client. I
have installed the SP2 and SFO enhancement patches and cleared forms cache in
Outlook. I also uninstalled and reinstalled SFO. SFO works fine on all other
laptops within our organization.
Here is the error which occurs when I select any folder within SFO/CRM.
Internet Explorer was unable to link to the Web page you requested. The page
might ...Range in Bar Graphs
Hi you guys,
I'm making charts for an assignment due tomorrow and I have to add th
range of the values to every bar in my bar graphs (bars showing th
It's supposed to be a line just like the one line that indicates th
average deviation, yet I don't want this line to show the deviation bu
rather the range of values that were the source for the average that i
being shown by the bar.
So for example we have the values 3, 4, and 5. The Average of tha
should be 4.
The bar shows the value four (4 is on the y axis) and drawn across thi
bard I would like to have a vertica...Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook?
Wow! I tried this out, and it seems to work beautifully. It's odd, though,
that I haven't seen this technique mentioned in any of the several Excel
references that I've looked at.
Basically, I have a workbook with several worksheets...one worksheet
contains a large list with all the records.
I wanted to set up the other worksheets to have certain functions...I wanted
them to use only certain columns from the main list, and to contain only
certain records from the main list that met specified conditions.
This is the best solution I have found so far - i.e., creating database
q...Preventing extra Worksheets when drilling down in Pivots?
Is there a way to prevent the creation of a new worksheet for a drill down,
unless I want it to stay in my workbook?
it drives me nuts deleting all those extra worksheets that get
automatically created everytime I double click on the data when I just to
Thanks so much.
Maybe you should use a Userrform with a combobox to store your lists.
> Is there a way to prevent the creation of a new worksheet for a drill down,
> unless I want it to stay in my workbook?
> it drives me nuts deleti...How to display XML string returned by CRM Accountobject.retrive me
Please let me know how i can display the query results fetched from crm
database into Datagrid directly.
Any help is appreciated.
"Vijay Kr. Poriya" wrote:
> Hi All,
> Please let me know how i can display the query results fetched from crm
> database into Datagrid directly.
> Any help is appreciated.
I assume that you are referring to using the CRMAccount.Retrieve method
This method will retrie...Conditional Formatting
I have a spreadsheet with 79,000 cells of information in rows and
columns. On a separate worksheet I have 5,000 cells of information.
I would like any information in the first sheet that is in the second
sheet to turn to red.
Sheet1, column A
Sheet2, column A
I would like the two strings in sheet one which appear in sheet 2 to
turn red, leaving the middle string black.
Is there a way to do a lookup to compare the cell value to a range
using conditional formatting?
Thanks for any help.
-----...Outlook Synch error
I have one user and only one user have trouble going back online with the
The user is connected to our VPN and then when the user clicks Go Online, it
starts to synch then she gets the "the logged-on user does not have the
appropriate security permissions to view the records or peform this specifc
Outlook works fine and the user can use web CRM just fine.
I've already tried changed the user's IE security settings to low, didn't
Could you provide a bit more information about the user, specifica...How do I use text in a cell as a range name in a formula
If cell A1 had the text TEST in it
and TEST is the name I have given to a group of cells using the name box
what formula can I use to give me the sum of TEST, thats is the sum of the
cells in the group called TEST.
I understand that I can simply have =SUM(TEST), but I want the formula to
refer to Cell A1 to get the name ie =SUM(A1) doesn't work obviously
Any help appreciated
In this case, you want to use the INDIRECT function. E.g.,
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Kiwi" &...Display more than 1 month in Outlook 2007?
When I'm in my Calendar view, I'd like to see at least 3 months at a time in
the little calendars in the left-hand pane. There's plenty of room, but only
1 month shows.
I can get more months if I expand that pane wider, but then it moves the
corresponding pane in the Inbox view also, which I don't want.
KathyN <KathyN@discussions.microsoft.com> wrote:
> When I'm in my Calendar view, I'd like to see at least 3 months at a
> time in the little calendars in the left-hand pane. There's plenty
> of room, but only 1 month shows.
> I c...vendors and Items replicated to another company.
My customer has 2 companies under GP
The 2 companies shared similar vendors and items.
they wanted the system which allows vendors and
items created in 1 company to be replicated to the
next company. Anyone know any 3rd party module can manage!
Example: A create a new item01 and it will automatic replicated to company B.
There are 'master trigger' tools sold by Microsoft that can do this for
Vendors, Customers and GL accounts - they're part of the Professional
Services Tools Library. I don't know of a tool for inventory items.
Dynamics GP MVP...Move OL 2007 and all files to another computer.One on XP one on Vi
Is there a detailed "How Do I file" covering moving OL 2007 with BCM from
one computer (that has a damaged or correpted C: Drive ) to another or new
computer. I have have some very helpful advice from an earlier post a few
adys ago but if a How do does exist that would be very helpful.
Thanks in advance. Andy
To backup and restore your Outlook data see;
For backing up and restoring BCM data see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsof...