Public Folder Auto-reply #2
Is there any way that I can enable an auto-reply for emails that are going
to a Public Folder that is mail enabled. The emails will not only becoming
from inside th company but externally as well.
Thanx for the help
yes, you can...on the Administration tab, click Folder Assistant...but be
very cautious with this...it's very easy to get into a "mail loop" condition
that could conceivably crash the store...
Susan Conkey [MVP]
"Sulaiman" <Sulaiman@discussions.microsoft.com> wrote in message
news:9E3D127F-2CBE-40D3-9AC3-333F3D25B465@microsoft....clustered stack column charts #2
I am trying to create a chart with three stacks in two columns. I tried
using the method described by Bernard Liengmen's but it doesn't allow me to
add a secondary axis for the last (sixth) data series. I don't get it???
How does one series in a stacked cluster use the secondary axis?
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Lou T wrote:
> I am trying to create a chart with three stacks in two columns. I tried
> using the method described by Bernard Liengmen's but it ...Store.exe crashing on 2 Exchange 2003 servers
We have 2 Exchange 2003 SP1 servers (Win 2K SP4) which have developed a
problem with the store crashing every half hour or so.
System event log:
The Microsoft Exchange Information Store service terminated unexpectedly.
It has done this 2 time(s). The following corrective action will be taken in
0 milliseconds: No action.
Application event log
Faulting application store.exe, version 6.5.7226.3, stamp 407db771, faulting
module storevs2.dll, version 7.1.367.0, stamp 40746ce5, debug? 0, fault
I think it is interesting that both servers are crashing, but not at exact...What happened? #2
Does anybody know why many of the discussion topics have been deleted from
Not specific to this forum, but the MS newsgroups have a "retention
period". Anything too old is automatically purged (which sometimes
leaves answers with no questions. IIRC this period is 6 months.
They are generally moving everything across to the web-based forums instead.
On 24/06/2010 14:57, Squeaky wrote:
> Does anybody know why many of the discussion topics have been deleted from
> this forum?
...How can I convert text to all lowercase?
How can I convert text to all lowercase?
I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?
If not with Excel, how about Word, DOS, any other way.
I'm using Excel 7.0 (Office 95).
Thanks in advance!
Take a look at David McRitchie's Lower() Macro (I believe it will
work in XL7):
In article <email@example.com>,
firstname.lastname@example.org (HBYardSale) wrote:
> How can I convert text to all lowercase?
&g...Getting date stored as text into real date?
A database query program outputs everything as a text string. One of
the fields is a date, formatted as yyyymmdd. Is there a worksheet
function that will change this to an Excel-recognized date? Or a
macro? The error checking doesn't flag this.
With your text date in A1, try this in B1:
Hope this helps.
On Dec 17, 1:12 pm, Ed from AZ <prof_ofw...@yahoo.com> wrote:
> A database query program outputs everything as a text string. One of
> the fields is a date, formatted as yyyymmdd. Is there a worksheet
> function t...x values and plotting points
I need to plot points and draw a straight line to
calculate the slope. I will use this same method to
present a trend for data points over time ( three years
Help! I have Excel 97.
annette christian wrote:
> I need to plot points and draw a straight line to
> calculate the slope. I will use this same method to
> present a trend for data points over time ( three years
> per compound)!
> Help! I have Excel 97.
You should be able to chart your data points using the Chart Wizard. See
http://www.geocities.com/jonpeltier/Excel/...IS there a way to compare 2 excel files
I like to be able to compare 2 excel files to see how different they are.Is
there such a thing?
Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
HTH. Best wishes Harald
"PeterM" <email@example.com> skrev i melding
> I like to be able to compare 2 excel files to see how different they
> there such a ...Creating a view with concatenated columns
I have a table with about 20 columns and I am trying to create a view of it
about 10 columns. The problem is that in the process, I am trying to
fields into one field and I am unable to get any thing working. Below is one
my attempts to tackle this. Any ideas will be highly appreciated.
// The following should be considered as pseudo-SQL
CREATE function [dbo].[fn_myview] (@CardNo varchar(11)) returns Table
declare @FullName as nvarchar(128)
(SELECT FirstName, FatherName, GFatherName, FamilyName, Birthdate,
Trim removes spacing in the beginning and end of word.
How can i delete a spacing betwee two words (name) ex "De Wit" > i want
You can use:
to remove all the spaces (leading/trailing/embedded)
if you really wanted lower case.
Luc Vandenhoeck wrote:
> Trim removes spacing in the beginning and end of word.
> How can i delete a spacing betwee two words (name) ex "De Wit" > i want
> THX Luc
...Rich Text control formatted as bold??
I have a control field on my form that is setup as textformat = rich text. In
the memo field on the form I need specific parts of the text to show up as
Upon form load I am populating the field with string data such as:
Me.MyTextBox = "This is a test string generation."
I need to set bold only one or two words of this string. The way I understood
it was that if I was using Rich Text format it would convert the formatting
to HTML style. But I don't see and havent found examples HTML formatting like
[b] [/b] working in VBA.
What is the correct way I can do t...special orders #2
What is the best way to handle special orders... would it be via work orders?
We would like to have two "special order" items that require 6 or so input
criteria, i.e. if a cashier selects the item, they would have to input
various selections such as color, finish, cloth type, etc. Any ideas on how
to handle this? Thanks, Dallas.
We use Layaway for special orders and I don't believe there is any
fundamental difference between Layaway and Work Order other than the
name. For the past year we've been using SO Tracker from Digital
Retail Solutions. You can find it at:
http...Automatically inserting text into a cell
I have a formula in a cell that reads like this;
In column M I am asking if a report is due Y/N. Can I add to the above
formula to automatically insert "N/A" into N12 if there is a "N" in column M?
N12: =IF(M12="N","N/A",IF(A12="","",WORKDAY(A12, 5)))
In article <39A51AAF-D44A-4356-B20A-71C8AA661338@microsoft.com>,
Roy <Roy@discussions.microsoft.com> wrote:
> I have a formula in a cell that reads like this;
> =IF(A12="","",W...Service Call SQL Object creation error #2
I am trying to configure Service Call Management, and when I execute the
step to set up permissions for the GP users who can perform service call
escalations (i.e Tools \ Setup \ Project \ Service Setup \ Service button \
SQL Objects button - Set permissions for Sql Objects for Escalation, then I
get the following error: 'An error occurred executing add group statements'.
When I click OK the next error is: 'The role FSSQLJOB does not exist in the
I am on GP10 and am doing this in the Fabrikam database.
You will want to run the follow...Combining 2 Text Strings in Body of E-Mail Q
I am trying to create a string of text to place in the message body of
an e-mail. Using Ron De Bruins code I've run in to the "Too many line
continuations". I've a requirement for 31 lines, but it hits this
error on line 24. How can I combine 2 text strings to appear in the
message body of the reports. My code with only the first stringbody
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim Sourcewb As Workbook
Dim Destwb As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim OutApp As O...Text Wrapping and received Emails
I have received an email that has lines in it longer than the page
width and dont wrap. I have tried help and searching here but cant
find a way to have outlook automatically word wrap incoming messages
to fit the text to the window any ideas please?
Are you sure this is a Plain Text e-mail? These should be wrapped
automatically for Outlook 2002 and 2003. HTML messages will be displayed in
the way got formatted.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of the month:
-Tips for...Display lists in an arbitrary number of columns
I have written and posted the following articles which will prove useful =
Display Lists in Columns Horizontally Using One Cell per Column
Display Lists in Columns Horizontally Using Individual Cells
Display Lists in Columns Vertically Using One Cells per Column
Display Lists in Columns Vertically Using Individual Cells
...Script to count duplicate lines in a text file
We have a requirement to count the number of duplicate entries in a text file
and then list the line and the number of duplicates. For example, we have a
file call test.txt that has the following entries:
This would return the following:
Any assistance would be greatly appreciated
> We have a requirement to count the number of duplicate entries in a text file
> and then list the line and the number of duplicates. For example, we have a
> file call test.txt that has the following entries:
...COUNTIF with adjacent columns
I have a spreadsheet which has a list of tasks in one column and
directly next to it whether that task is complete/not complete/
For example in cell B2 the task is CL and in column C2 the task is
2 CL Complete
I would like to add a tally box at the bottom for all CL tasks which
are complete, then another for not complete and another for
rescheduled. At the moment, I can only get it to COUNTIF on either the
CL or the complete value but not both together.
Any help greatly appreciated!
A B C ...Rules do not run #2
I have erase all my rules and set them up one at a time as a new message
arrives. Next time that rule is supposed to run it does not. Using "Run
Rules Now" does work, why are my rule not running automatically when new
messages arrive. I am using Outlook 2003.
what type of email account do you have?
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 2007: http://www.slipstick.com/outlook/ol2007/
Ou...Migration From 1.2 to 3.0
We want to do a new installation of CRM3.0 on a new server. How to migrate
data from 1.2 to 3.0 ?
(1)Somebody suggested to use data migration tools. I don't like it because I
have experienced before (when I migrate Goldmine to CRM 1.2). It is very
headache and time-consuming.
(2)Somebody suggested to do a new installation for CRM1.2 and upgrade to
CRM3.0. Does it mean I can copy the database of 1.2 to a new server and
install CRM1.2 ?
I would actually first upgrade your existing system. Then look to migrating
to the new hardware. With v3, the DB is a lot easier to mov...How to split numbers and decimal in 2 columns
One column for the dollars and the other for the cents? If so, use the Text
to Columns, Use Delimited as the split option (Step 1) and select Other, type
in the decimal point in the blank to the right of the Other option in step 2.
This is good, but how do i keep it in the colums is i introduce new data and
how do i sum it up (the colums) to get a final number with decimals in there
Dollars in in B, cents in C, Data shown
Dollars Cents Cu Sum
7 56 7.56
3 44 11.00
2 24 13.24
45 23 58.47
C2: =SUM($B$2:B2)+SUM($C$2:C2)/100 and copy down
"...outlook web access
Thanks in advance for your help. I am using outlook web access. When I
attempt to reply to a message, the text box just has a box with a red "X" in
the top left corner. The same thing happens when I open a new message.
"Amy" <Amy@discussions.microsoft.com> wrote in message
> Thanks in advance for your help. I am using outlook web access. When I
> attempt to reply to a message, the text box just has a box with a red "X"
> the top left corner. The same t...Reporting #2
I receive email for two domains into my Exchange Server. I'd like to know
how much email is received total and for each of these domains individually.
Are there any built in tools for this type of reporting?
No built in tools to do this in Exchange, you would need to use a product
lik MOM or a 3 rd pary product like:
Mail Access Monitor http://www.internetaccessmonitor.com/eng/products/mam/
Admin Report Kit for Exchange Server
Exchange Monitor http://www.fortissoftware.com/
Ben Ho...Update Rollup 2 and Terminal Server
I've been using the terminstall.cmd script that MS put together for
installing CRM 3 for Outlook on Terminal Server.
How should I install the UR 2 on Terminal Server?
I can't find any direction on this so any hints would be greatly
Having the same issue myself. Can anyone point us to some suggestions?
> I've been using the terminstall.cmd script that MS put together for
> installing CRM 3 for Outlook on Terminal Server.
> How should I install the UR 2 on Terminal Server?
> I can't find any dir...