company name change
Our company has recently changes names. We already have two email domains
currently in use, one set as primary for everything and another which was
used in the past. We have one defined SMTP address, which is primary for all
users. We also have another which was used int he past, but is not listed as
a SMTP address in EXCH system mgr, recipients policies.
Of course, I have a new domain to add as our primary smtp address and will
need to make the current smtp address secondary for users.
In EXCH system mgr, I do see CCMAIL and MS properties which appear to be our
old email domain...Filtering on originators NAME
Outlook 2003: Is it possible to create a rule which operates on the
originators stated name, as in: From: _this_bit_ <email@example.com> ?
I don't know anyone whose *name* contains Xanax, Cialis or Valium, but they
sure are sending me a heck of a lot of mail! (Which I'd love to filter out)
http://www.ringers.org.uk (Personal Webpage)
http://hedgehog.farn.uk.ibm.com (IBM Internal - restricted)
You can create a rule that scans he message header for these names. Isn't
your Junk E-mail Filter catching these already? They are filtered out for me
I have a worksheet with a large number of named ranges.
Is there any way I can print a list of these together with their references.
Thank you & Regards
Insert a new worksheet.
Copy, paste and Run this macro (with the new worksheet active).
Dim NamedRange As Name
Dim x As Integer
x = 1
For Each NamedRange In Names
Cells(x, 1) = NamedRange.Name
Cells(x, 2) = NamedRange
x = x + 1
Ian Bull wrote:
> I have a worksheet with a large number of named ranges.
> Is there...Empty cells at start of x axis
I have two charts that are the same size and I want to print them separately
and compare data by physically laying one above the other on a table.
The x axis on one has dates, i.e.
Oct. 1 Oct. 2 Oct. 3 etc
The x axis on the other has numbers starting at #1,
1 2 3 etc
How do I get two empty cells at the start of "number" chart so that the
number 1 starts in the third cell from the left?
When the two charts are laying one above the other, their x axis would look
Oct 1 Oct 2 Oct 3 Oct 4
...Vary colors in area chart by x-axis value
I have an area chart that displays electricity usage (y-axis) for each hour
of one day (x-axis). I want hours 1-7 to be blue, 8-12 green, etc.
There is a 'Conditional Chart Formatting' sample workbook at
>I have an area chart that displays electricity usage (y-axis) for each hour
> of one day (x-axis). I want hours 1-7 to be blue, 8-12 green, etc.
> Deirdre M.
...HTML_Control Range name
I have a problem with one of my macros where I am copy an entire worksheet
(not by range) to another workbook.
However, every other worksheet it seems comes across with an message
indicating that that range name HTML_Control already exists.
I had run a piece of code in my worksheet to outline all range names and it
appears to be some kind of range name....and to my surprise there are a whole
bunch of other names as well.
Can someone tell me if there is any specific purpose for it?
Do you have controls on the worksheet? If so try renaimng
them to something other than commandbutton1...Horizontal Time (X-axis)
I am attemping to graph a horizontal 24 hour time period in Excel. At the
left side would be 08:00 and at the right side would be 07:59
On that bar I am attempting to plot the start and ending times of 14 batch
jobs that run in order to track them over time and adjust the schedules to
be more efficient.
I have run through all the graphs that are built in and the closest I have
come is a diagonal, 45 degree, line of time.
My column A is the name of the jobs
My column B is the start time of the jobs
My column C is the 24 hour clock (08:00; 09:00, 10:00, 11:00, 12:00,
13:00...2...Can anyione point out why?
In my test environment, I import the certificate from production to my
exchange 2003 frontend server on my test environemnt and configure it to
require SSL. I got "the page can not be dispalyed" If I access the OWA
through https://frontend server/exchange. If I removed the certificate, the
OWA through http://frontend server/exchange is fine.
Can anyone point me to the right direction?
What kind of certificate do you have. It sounds like it may be a server
certificate, in which case it will only be good on the server with the
correct name on it.
--...Report Name Customer
We have created a custom report in Visual Studio which shows all the service
activities per customer in CRM.
I now would like to display the customer name which was used in the filter
as the heading of the report. If no customer was selected the heading should
be blank. Do I need to use CRM_FilterText to achieve this? I have attempted
to insert a parameter without success.
I would really appreciate some guidance in how to achieve this.
no you can easily achieve this with a table group heading
"Mark Braithwaite" <MarkBraithwaite@discussions.microsoft....Connecting two series in a scatter chart
Hello - I have a user who created a scatter chart. The chart contains two
"HO" and "PD" - the HO data point has a related PD data point.
She would like to have Excel add a connector line from the HO data point to
the corresponding PD data point. Is this possible?
I apologize that I am not familiar with this type of chart, or the lingo, so
please let me know what other information you would need to answer this
We are using Excel 2007.
Thanks very much!
Double-click one of the series, in the format series dialog box choose the
Options tab, and ch...XPS Default File Name
I am printing to a .xps file. However, each file I save from .xls, prompts
for a file name with the .xps set as the default.
Does anyone know how to set the current workbook name of a .xls file as the
default name for the .xps file?
I guess you should save via a macro:
Dim WBName As String
Dim DotPos As Integer
WBName = ActiveWorkbook.Name
DotPos = InStrRev(WBName, ".")
If DotPos > 0 Then WBName = Left(WBName, DotPos - 1)
ActiveSheet.ExportAsFixedFormat Type:=xlTypeXPS, Filename:="C:\...Week numbers on X-axis
I have a chart that should display the project status over
a number of weeks. It all works fine when you have a
continous array of weeks (e.g w430 - w450).
But when the projects runs over the NewYear (e.g w430 -
w506) I have problems with my x-axis. The week numbers
(430 - 506) appears to the left on the x-axis and to the
right I only get marks on the axis but no numbers.
I would like to have the weeks spread evenly on the x-
axis, starting with 430 and ending with 506 (an across the
New Year; ... 451, 452, 452, 501, 502 etc).
I save the wanted x-axis in an array (1 to LastWeek) and...OL2003: Names Do Not Appear in the "Search Results" Box When You Search for Names That Have Double Byte Character Set Characters in a LDAP Address Book?
> how can i do?
> microsoft.com only say the ol2002 but not say ol2003!
> OL2003: Names Do Not Appear in the "Search Results" Box When You Search
> for Names That Have Double Byte Character Set Characters in a LDAP Address
> In Microsoft Outlook, you can search for names in a Lightweight Directory
> Access Protocol (LDAP) address book that you want to insert in the To box,
> the Cc box, or the Bcc box of an e-mail message. However, if the name that
> you are searching for contains Double Byte Character Set (DBCS) characters
> (...Modifying the Assembly transaction entry window-X in corner
I would like to modify the window that pops open after you change anything on
the Assembly Transaction entry window (Transaction>Inventory>Assembly Entry)
This window is labelled:
Microsoft Dynamics GP
and the question is:
Do you want to sasve changes or delete document number xxxxx
(I would like to remove the delete button)
How do I find this window in modifier?
That is a dialog box, and it does not exist as a "window" that can be
To accomplish what you want you would need to modify the behavior of the
Assembly Trx window to prevent ...Can you chart an equation (y=mx+b)?
I am trying to set up a graph in MS Excel where you can enter in the values
for X and B and it will graph the line, like a graphing caluclator would. Is
Excel graphs points, not equations. For a straight line, you would only
need to calculate the first and last points on the line and plot them as
an "XY (Scatter)" chart with points connected by a line. Alternately,
Tushar Mehta has written an add-in for plotting functions
> I am trying to set up a graph in MS Excel wh...Short cut key Ctrl Y (repeat last motion) in Publisher won't work
The help menu tells me that I can use the Ctrl 7 to repeat the last action I
made. However I have not been able to do so. Please help. I can use all
other shortcut keys. This is making me crazy -- I can do my work in half the
time with the Ctrl 7. It tells me I can also use F4 but this doesn't work
either-a moot point since I use the other that speeds my work considerably.
Where did you find those commands?
Mary Sauer MSFT MVP
http://officebeta.iponet.net/en-us/publisher/FX100649111033.as...Convert Power Point presentation
I have old presentation that I need to convert from "read me only file" so I
can edit or redo it. Can you email me. (Vista Home Addition).
> I have old presentation that I need to convert from "read me only
> file" so I can edit or redo it. Can you email me. (Vista Home
Did you try opening the file in MS PowerPoint?
John Inzer MS-MVP
Digital Media Experience
This is not tech support
I am a volunteer
...Microsoft Outlook 2000 error The Name Coud Not Be Resolved
Hi to All,
I have a windows 98 SE client with Outlook 2000 professional installed. I
cannot add exchange mailbox because there is an error when I tried to
connecto to exchange 2000 Enterprise Edition upgrade from exchange 5.5. The
name could not be resolved when I tried to get the users mailbox. However in
Windows 2000 DC I installed the Outlook 2000 and it is working fine.
Please I need a help. Thanks in advance!!
Also check DNS settings on Win 98 machine.
> Hi to All,
> I have a windows 98 SE client with ...User Name
Is there a formula to capture the current user's name (%username%) in a
I do not want to use any code that will ask the users to enable macro when
they open the document.
Use a UDF
UserName = Environ("UserName")
and use ina cell like this
(replace xxxx in the email address with gmail if mailing direct)
"JVS" <firstname.lastname@example.org> wrote in message
> Is there a formula to capture the current user's name (%username%) in a
&...Desktop names have been changed
Don't know how this happened - but most of my Desktop file and folder
names have been changed. Following is an example:
This is what it was changed to. When Vista SP2 boots, just for a moment
the correct name appears. But then, the names change to something like
what I showed above. I tried System Restore and ERUNT - no luck. Can
anyone tell me how to retrieve the file and folder names?
On Sun, 06 Jun 2010 20:45:22 -0400, PeoplesChoice@Chicago.net wrote:
> Don't know how this happened - but most of my Desktop file and folder
> names...Primary Axis(X) Formating Issue
I'm using a custom type chart (Lines on 2 Axes) and I'm using two different
ranges for the Category (X) axis labels and the Second category (X) axis
labels in order to display some additional information on the chart. When I
say two different ranges I mean the rows are the same, but the columns are
The problem I'm having is I want to use a custom format (dd-MMM-yy) to
display the dates, but when I do so the dates have format MMM-yy-dd. The
only way I can get the dates to display accurately is to use the Date format
with the * (either *03/14/01 or *March 14, 20...Data Series Name
I am trying to add wording in an Excel data series name, but also keep the
value linked to a cell in the spreadsheet. For example, the linked cell will
sum values from other cells. So, the data series name will equal that sum,
but in front of the summed value I would like to add the words "Total Sales".
Can this be done?
You have to construct the label in the worksheet cell, then link to it
in the series formula (or source data dialog).
For example, if the series name is in cell B1 and the value you want is
in C1, enter this formula in B1:
="Total Sales "&C1...Edit Contact Command doesn't remmber the Name
1) Right click Sent items folder in Storage folder.
2) Click Find. Put a name in the To: field. Click Find Now.
3) Click on an email message found.
4) Right click on a name in the To: field, a name that includes the First
Name and Last Name.
5) Click Edit Contact. If the person isn't already in your Contacts the
First Name and last name fields are blank in spite of the fact that their
name was clearly visible in step 4.
6) Why does Windows Live mail do this and is there a way around this other
than typing in their name?
Of course the whole point here is to add the...Change name of tab sheet
The 'help' menu tells me to double click on the tab sheet and override the name. When I do this, nothing happens!
Double-clicking should highlight the sheet name, allowing
you to change it just be typing. If you can't get it to
work, try right-clicking on the sheet name, and selecting
rename from the menu. If that doesn't work, the worksheet
is probably protected. Choose Tools, Protect, from the
menu bar, and see if there is a menu option "Unprotect
Sheet". If so, the sheet is protected. If is
says "Protect Sheet", then...deleting worksheets from names in a range
Is there anyway to delete worksheets via code where one worksheet contains a
range with the names of the tabs on the worksheets I want to delete?
i.e., Sheet 1 has a range that has the values, A, B, C.
These are the names on tabs for 3 worksheets. I want to have code that says
"delete worksheets with the tabs named A, B, C.
Let me know if you need more info.
Application.DisplayAlaerts = False
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
On Error Resume Next