Cross site move missing X500 adress
At a client, we are moving users from 4 Exch 5.5 sites to a fifth site with
Exchange 5.5 and Exchange 2003 servers (users are being move to an Exchange
2k3 Cluster )...
We have done the move for all of mailboxes on these sites, but the mailboxes
that were moved last night, are missing their second X500 address, the new
one created for the new Exchange2K3 server address...
As a result, these users can't get email from outside, since mail flow is
routed trough one of the Exchange 5.5 sites that is being moved...
Wondering if there is a way to add the second X500 address, and if not, ...How do I copy a pie chart (just the circular pie) into powerpoint
I need to copy the circular pies into a powerpoint document (to place on top
of a map) - I can't figure out how to do it without copying the whole chart
(ie the square box surround it with the legend and title - I've deleted these
but don't know how to seperate it from the pie)
Can anyone help??
...Email Time changes when email is moved
I'm using OL2002 w/XP at work. I've noticed that when I
move an email from the server Inbox to a Personal folder,
the time on the email stays the same. But if I move the
email back to the Inbox, it loses 7 hours, but if I again
move it to a Personal folder, it stays the same! Back to
the Inbox, and it loses another 7 hours. I've check OL's
time zone and it's correct. Ironically, I'm in MST, which
is -7 GMT. Not exactly a catastrophe, but very annoying!
Any ideas? Thanks.
...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Copying and pasting a series of cells
When I copy and paste the following cell
to the remainder of the days of the month, what I get is
But what I want to get is
I'd even settle for
whereafter I could just modify the fo...Insert trigger
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...How To Copy Rows without Work Art
I have some Word Art in say Rows 9-23, I use some Macro code to copy cells
9-23 down to 10 grouped rows below 23, but everytime I run the Macro it also
copies a 'New' Work Art over the existing Art below Row 15. My fear is that
my file size will balloon. My code simply states
How can I copy Rows 9-23 without the WorkArt also (which is 'floating' over
Anot...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...installing network service dll (vmnetbridge.dll) fails to copy into system32
Trying to install a network service vmnetbridge.dll fails with err msg. "An
error occured while copying file vmnetbridge.dll. Cannot copy file to
destination directory. c:\windows
User is in local admin group.
UAC is set to OFF.
Driver is digitally signed by Vmware, inc.
Please advice how to rectify.
...How to know what rule have moved an incoming message?
How to know what rule have moved an incoming message to "deleted items"
folder, or because of what IP address in the incoming message header the
message have been moved to "deleted items" folder? There's a rule moving
messages from spam IP addresses to the folder.
Most likely it is the built-in Junk email filter.
You can change the level of sensitivity under Tools | Option | JunkEmail ...
Harvey Yancey [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dmitriy Ko...Exchange Advanced Tab In Users Properties
Hi To All,
I just wondering in my New Exchange 2000 Server when I click the properties
of Users in Active Directory there is no Exchange Advanced Tab in the
properties of Users.
Can I have some TIPS how to activate this.
I believe it is the View menu under Active Directory Users and Computers,
Select the Advanced Features.
"emslan" <email@example.com> wrote in message
> Hi To All,
> I just wondering in my New Exchange 2000 Server when I click the
> of Use...meeting invites moved to deleted folder
Why do the meeting notices I receive in Outlook 2000 get
moved into the deleted items folder after I accept the
meeting? Where can I changes this to leave them in my In
Box until I choose to delete them?
Because once you've accepted the meeting, you have the item in your
calendar. You don't need the meeting invite anymore. What's your goal?
> Why do the meeting notices I receive in Outlook 2000 get
> moved into the deleted items folder after I accept the
> meeting? Where can I changes this to leave them in my In
> Box until I choose to delete them?
Is there a formula for calculating the moving average for a group of numbers
I'm assuming that you want a running average (at least, that's how I am
Assuming your values are in column A and your average in column B
the formula in B1 should be as follows:
then just copy and paste it down the rest of the column and it will
calculate the average as numbers are added.
> I'm assuming that you want a running average (at least, that's how I am
> interpreting it)
I think the OP want...Need fast way to move from cell to home
What is the quickest way to move from a cell to home (A1) in Excel? I
thought you could click on something or hold down two keys in order to
accomplish this, just can't remember. Thanks.
Microsoft MVP - Excel
"Debbie" <Debbie@discussions.microsoft.com> wrote in message
> What is the quickest way to move from a cell to home (A1) in Excel? I
> thought you could click on something or hold down two keys in order to
> accomplish this, just can't remember. T...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Copy an integration
Is there any way to copy an integration created in Integration Manager? It
will be ideal if I can rename an existing integration that will serve as a
basis for another integration.
In the past I have used the Save AS otion int he file menu to creat a copy.
Just remember that teh surce is the same on both copies and it you change one
it effects both integrations.
"Patti Foo" wrote:
> Is there any way to copy an integration created in Integration Manager? It
> will be ideal if I can rename an existing integration that ...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Exporting Excel Charts in Separate Tabs
I have an excel file with different charts on each tab. The Excel file has
at least 20 tabs and I would like to export them into Word as a separate
sheet per tab for a reference guide. Is there a way to export from excel
without having to cut and paste each tab?
I am using MS Office 2003.
...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...How to copy specific columns until end of data
I'm trying to import data from 2 workbooks into a summary (combination)
workbook. The trouble I'm having, is I want to import only certain
columns and have excel know to stop at the last row with data.
For example, from Workbook1 I want to import columns A, B, C, F, and G
(from Sheet2). I want it to copy up to the last row containing any
data--right now that's row 1046, but next month it could be row 1267.
In workbook2 I'm fine with it copying the CurrentRegion--all columns
are important. BUT, it doesn't include the title/category heads in the
first row (Salesperson, ...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...copy and paste macros
I have a workbook that has several macros in it. I created anothe
similar workbook that uses the old workbook and macros as the basi
platform for the new workbook. I copied and pasted the old macros t
the new workbook. When I ran the macros after creating the ne
workbook, everything worked fine. I emailed the program to my hom
computer, and when I try to run the macros there, I get a run-tim
error. What it looks like to me is the new workbook is trying t
access the old workbooks macros. That is why it works on the compute
I created the workbook on and not on my home computer, where I do ...Inbox Email is automatically being moved to Deleted Items
Help - A number of important emails keep getting automatically moved to
Deleted Items. I have not set up any rules like this. Is there some setting
I can change to ensure this doesn't happen
try opening outlook using the resetfolders switch.
If you don't know how to do this, see
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <firstname.lastname@example.org> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...