Several usernames, several domains
My boss frequently gets his name misspelled and has six additional e-mail
aliases to cover this. He also has 18 domains. So now when we're moving to
Exchange 2003 he's getting 7x18 addresses. Thats no problem in my book, Email
recipeint policies covers adding the 18 domains, but.... how to make every
policy cover the seven aliases?
You don't need to. Just add the aliases manually to the user account. As
long as the domains are the same, you're covered for him receiving mail
properly. You only need one recipient policy for each inbound domain to
cover ...Moving average trend line
When graphing, does a moving average trend line give equal weight to all
data within the trend period (30 days in my case) or does the more recent
data have greater weight (significance)? If the latter, do you know the
no weighting is done.
Don Culp wrote:
> When graphing, does a moving average trend line give equal weight to all
> data within the trend period (30 days in my case) or does the more recent
> data have greater weight (significance)? If the latter, do you know the
> weighting function?
> Don Culp
...Separating names from one cell
I have a long list of first and last names in one cell, is there a way to
separate them out without having to manually copy, paste, and delete each
one. It would be great to have two columns: first name and last name.
Have a look at Data/Text to columns. If you use <space> as a delimiter it
should do the job for you. Select the column before you start, and make a
copy of the sheet too, in case it all goes horribly wrong!
"mlf" <firstname.lastname@example.org> wrote in message
>I h...stationary how to make and use several
I need to use serveral differant stationaries to use with differant clients,
how do I make more than one and use it, I have one made right now, but can
not figure how to use it in a new email, I do not want it to be my default, I
only need it once a week or so.
...Word between lines
Hi, I´m working in Publisher 2003.
Can you guys help me out ? I need to changes words between lines, can I do
it automatic? So if changes the text I don´t have to go and take all the -
Mary Sauer MS MVP
"ASA" <ASA@discussions.microsoft.com> wrote in message
> Hi, I�m working in Publisher 2003.
> Can you guys help me out ? I need to changes words between lines, can I do
&...investing x monthly amounts to..?
Help out please,If one would put amount of x every month into an
investment with yearly interest of r (compounded at the end of the
year) how much it would amount to in N years?
In article <email@example.com>,
> Help out please,If one would put amount of x every month into an
> investment with yearly interest of r (compounded at the end of the
> year) how much it would amount to in N years?
If the x is deposited at the beginning of each month and earns simple
monthly interest until the end of the year, the amount...Suppressing lines on reports
How do you suppress 'zero' lines on reports. For example
when reporting Investment value stocks which have all been
sold show up on the report (with quantity zero).
This increases the size of the report with zeroes in all
You could customize out the investments in question. If the report in
question has the option, remove any option to show closed investments.
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.m...faq: different elements in one container,is it possible? #2
I use CArray, CList etc. , and always the elements in the container
are the same type. Now I want use these container to store the different
elements , is it possible?
As a example,
class CMyPoint : public CPoint
Now I want to store the CPoint and CMyPoint in CArray, how to define it?
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=UTF-8; format=flowed
David Wilkinson 写道:
> To store polymorphic...excel vba
is there a way to disable the close button on a userform such as
password screen that would disable a person from being able to clos
the userform by hitting the x button in the top right. I have it se
up so that they have to enter a password to view the page, bu
overlloked the fact that they can simply hit the close button. An
Message posted from http://www.ExcelForum.com
Use the form's QueryClose Method
Here is the (pasted) example from the Excel VBA Help file
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
'Prevent user from closing ...Transaction screen resolution got changed one more time!!!!
hi, in one of my POS the Transaction screen resolutions sometimes increments
its height with no reason....
After i fixed it do it again few days after....
Is this a common bug or some like that?
I've seen it happen before, it doesn't seem to be too common and don't know
what the cause is. The only solution I've found is to always log in as an
Limited User instead of an Admin. The Limited User cannot change the
setting and make it stick, without a lot of work.
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other ...x Axis inserts extra dates
I am charting values in two date columns, one date is 8/16/05 and the other
one is 9/1/05. The columns are side by side.
This use to be a piece of cake for me until I started using Excel 2003.
Now, instead of showing two dates on the X axis, it shows values for every
two days between 8/16/05 and 9/1/05. I found out that the X Axis scale was
showing a 2 day interval, however I was not able to make any changes in the
scale area to show only the two dates I wanted.
Any help would be appreciated.
If you have only two dates, then there's no reason to have a time...copy several items & paste several items?
Thanks in advance.
I want to copy several items into the Office Clipboard
(Edit>Office Clipboard...) and then paste those several
items into the active sheet (using VBA). (I believe up to
12 items can be stored in the Office clipboard) So rather
than copying one item, activating the sheet, pasting it,
then activating the sheet to copy from, copying, then
activating the sheet I want to paste to one more time, and
pasting it, the macro would:
select an item
copy to Office clipboard
select another item
copy to Office clipboard
activate another sheet
select a range
pastespecial an item
s...How do I restrict data movement (cut & paste) to only one column?
My workbook is designed for shared use. One crucial function is to allow
the users to move data (text) up and down columns associated with that
specific data. How do I protect the users from mistakenly moving data into
a wrong column. I have tried the validation function, but cut/moved data
carries its own validation properties and is therefore not considered
invalid when pasted into any cell.
Any guidance would be much appreciated.
One way to play with might be to restrict the scroll area in each sheet to a
certain columnar range.
For example, suppose ...Help with adding x-axis major gridlines
I'm trying to make a chart that will have small tick-marks along the x-axis
for a fiscal week, and a long tick-mark separating the fiscal month. I think
I'm not formatting the data properly in the worksheet. Any ideas?
Use a Line chart with dates as the X values. Double click the X axis. On the
Scale tab, set the X axis minimum to occur on the 1st of a month. Set the
Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7
Day(s). On the Patterns tab, choose whatever for Major Ticks and something
besides None for Minor Ticks. Click OK. On the Chart menu, choose C...Y-axis on both sides?? Gridlines priority??
Is it possible to display a y-axis on both sides of a chart?
Both should be identical, and should have automatic scales. It's on a
Area chart with four or five data series.
Alternatively, if I could give the Gridlines priority (ie if they
appeared on top of the coloured area ranges) it would solve my
germullen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30626
View this thread: http://www.excelforum.com/showthread.php?threadid=542920
In place ...[Q] Command Line Switch for Outlook to specify profile....
- I have 2 outlook profiles on the same computer
- I dont want to log in to the same one each time
- I would like to create a 2 shortcuts - one for each profile
- So is it possible to supply a command line paramater to Outlook to
specify the profile?
The switch you want is /profile <profile name>
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Donovan J. Edye" <firstname.lastname@example.org> wrote in message
...RMS should allow you to choose more than one item at a time
RMS should allow you to choose more than one item at a time, this would be
helpful in creating PO's. Mutiple item selection is a standard in every
software; you really dropped the ball with this one.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micr...Outlook 2002 Red X
I am running Outlook 2002 and suddenly my incoming emails are missing
pictures and banners - replaced by rectangles with red x's (think they are
called placeholders). Can you help me to restore the pictures, please.
Robert S <email@example.com> wrote:
> I am running Outlook 2002 and suddenly my incoming emails are missing
> pictures and banners - replaced by rectangles with red x's (think
> they are called placeholders). Can you help me to restore the
> pictures, please.
Try uninstalling the most recent Office security update.
Brian Tillman [MVP-Out...split from one date to several dates
hi there. this is the situation, i'm trying to split one date in several
dates, for example:
01/03/2010 ----- split in 60 dates with the interval of 1 month
Can you help me???
Tks in advance...
First, be aware that Access does date/times in US format ... I'm assuming
your list of dates are the 1st of March, the 1st of April, ...
If you want an Access table with the first day of each month for the next 60
months, there's a simple trick. Open Excel, put in a few dates, then extend
the range until you ha...how do i make a chart with two seperate lines of data?
i have a historical sales chart from Mar 2003 to present that i'm trying to
however, excel is making me keep the data in one straight line
if i try to seperate it into two rows, it adds another bit to the chart
how do i graph sales using two seperate lines of data?
This is best done in 2 steps. Create the chart with the first set of
data. Then use the Source Data dialog to reselect the 2 data ranges,
using the CTRL key to select the 2 separate ranges.
So for data that is in the range A1:E1 continued in A2:E2 you would end
up with a series formula like this,
=SERIE...How do I open multiple PST files in one go?
I have multiple PST files saved as Dec 09, Nov 09 so on and so forth. I want
to open all the files in one go instead of doing the following process a
dozen time for the dozen or so files
run outlook --> file --> open --> open data file --> browse to the location
(multiple clicks) --> click on the archived pst file i want to open
Any help would be greatly appreciated.
Hope everyone has an excellent weekend *smile*
> I have multiple PST files saved as Dec 09, Nov 09 so on and so forth. I want
> to open all the files in one go instead...One click to select a newly create account from a Lookup form
On the Case form, when you look up a Customer you have the option to
click New. If New is clicked and a new Account (or Contact) is
created, is it possible to link the Account straight back to the form
when the Save & Close button is clicked. Rather than having to select
the newly created Account from the Lookup up form, the account is
selected automatically and the lookup form is closed.
This CRM implemenation is for a call centre and they must minimse the
amount of clicks to perform certain actions.
This is a CRM 4.0 implementation.
Is this possible with JScript, or by any other means...Sending from several addresses
I am running Outlook 2000, and have several addresses set
up under one profile. Can anyone tell me how I can tell
Outlook which of those addresses to send from? It always
sends from the first one I originally put in, but now we
have our own domain, and I need to send my messages from
the new address. I would like to be able to send from the
third e-mail address, so I can't just delete all the
...SQL 2008 linked server to VFP 7.x tables??
Does a good reference or tutorial exist for this topic??
We only need READ access from SQL 2008 to the VFP tables -- various
select queries for reporting etc.
Should this be done by first installing the most current VFPOLE driver
onto the server containing SQL 2008, then establishing the linked
Or should we use an ODBC DSN (file or system, which??) and link from
SQL 2008 to the VFP data this way??
Thank you, Tom
...Leader Lines Connecting Chart to Box
I have a pie chart with a text box (to the upper right). I take one slice and
draw lines from the top and bottom of the outside ends of the slice to
connect to the text box.
Naturally, as the data changes, the slice changes (or the pie slightly
rotates) which requires me to adjust the lines to the box.
Is there a way to have these lines track with the chart?
Here is a possible solution. It uses a combination chart which allows
the lines to be plotted and updated dynamically by using a xy-scatter.
If you have to still with ...