text to columns #6
sometimes i get a text from a webpage with delimiters a small square (what
you get when you type =char(1) in an excel cell). how to specify this
delimiter in the <data-texttocolumn>. Fixed width criterion does not help.
mine excel 2000
remove $$$ from email addresss to send email
Try other, hold down the alt key and type 010 on the numpad, release the alt
I have never heard of char 1 as delimiter, sometimes char 10 and char 13
(alt + 013)
(No private emails please)
"R.VENKATARAMAN" <vram26@vsnl$$$.net> w...Exchange 5.5 #49
I can not mount the folders that are stored on M: Drive or even access the
drive in explorer. Any ideas?
"M:" drive? Exchange 5.5 doesn't use an M drive....
Steven Sharman wrote:
> I can not mount the folders that are stored on M: Drive or even access the
> drive in explorer. Any ideas?
The mailboxes where on drive M: when I last done a backup on 29/3/06
Im using Win2K Server with exchange 5.5
I can not mount the the Exchange Server
Also M: Drive is not accesible
Any ideas would be more then welcomed
"Hank Arnol...Convert Works 6.0 data base to Excel?
How can I convert my data bases in Works 6.0 to Excel??
Generally you would normally open the file in WORKS and then save it down as
a file that Excel can read. .xlr is a native Excel format, or .txt, .csv,
dbaseIV are all formats it can read. You can also find a converter here if
you don't have WORKS.
Text from the website above:-
Microsoft does not provide an import Excel filter for Works-WKS files later
than version 2. (for Works-WPD and Word they do). There is no standard way
to convert a lot of Works-WKS files in...Import Data from ACT 6.0
Hi, I would like to import my data from ACT 6.0 into CRM 3.0., Does anybody
have step by step instructions in how to do this?
there are multiple options
1 - use the Microsoft data migraiton framework
2 - buy and use scribe migrate
3 - write your own code
4 - buy a 3rd party utility which transfers act to an easier database then
extract from that
sorry there is no easy quick way to do this
Microsoft CRM MVP
"Behzad1m" <Behzad1m@discussions.microsoft.com> wrote in message
news:7C19676E-...Post migration 5.5 to 2003
The migration is complete. I need to remove the 5.5 box from the site. Bad
thing happened. Exchange 5.5 box went down, never to start again. How do I
remove the 5.5 from exchange 2003 site so that I can go to native mode? Do I
stop SRS and delete the connector? I can not just remove it as I could a 2003
box from the site. Please assist.
Remove SRS and the Connector. Then use ADSIedit to remove the references to
the Exch 5.5 from AD.
"dstout" <email@example.com> wrote in message
news:4902E9F0-F046-4768-AC6D-91C780056832@microsoft.com.....log files #6
On the last installations of 2003SBS premium SP1 edition, i noticed that
under c:\program files\exchsrv\mdbdata\, lots of .log-files are created,
consuming lots of space. Is there a way to avoid the creation of these
files. Because after, lets say a week, these files can consume for example
and these are the things that are eating up my diskspace.
I think the way is scheduled job on 00:00
cd c:\program files\exchsrv\mbdata
del *.log /q
"Jo Lambrecht" wrote:
> On the last installations of 2003SBS premium SP1 edi...ESEUTIL Usage Recomendation
I have a private store that was purge of around 40 gigs of messages.
Obviously I'll like to shrink the db.
Is eseutil the best way to do this?
Following link will be usfull
Repairing Exchange databases with ESEUTIL - when and how?
In Exchange 2000 Server and Exchange Server 2003 Eseutil in Repair/Integrity
Mode Incorporates /X and /V Options
Use the Eseutil Utility to Detect File Header Damage in Exchange 2003
http://support.microsoft.c...How do I change row height to 16.0? I get choice of 15.6 (26 Pix.
In an excel sheet I need the row heights to be 16.0. I select the rows and
go to Format, Row, Height and type 16.0. When I check the row height it will
be 16.2. I can take the cursor and try to change an individual row height
and it will let me choose 15.6 (26 Pixels) or 16.2 (27 Pixels). I have
changed the screen resolution and it did not help and I have tried to change
print resolution but am only given 600dpi as a choice.
AFAIK 1 pixel is the smallest increment you can use.
"jlloyd" <firstname.lastname@example.org> s...Exchange 5.5 #13
To be honest, my experience on Exchange 5.5 server has
been minimal. I have been briefly told that a client is
running Exchange 5.5 Server in his organisation.
The users in that organisation already have email address
of for example: email@example.com
Now the client wants that some of the users should
maintain that email address and some of the users should
get an email address of:
Therefore, the end result will be that 500 users will be
having and email address ending with ...@doorlock.com and
the rest 200 will be having ....@woodenf...MSVC 6.0 or VC++.NET
By the way Os and platorms are upgrading, more and more softwares and
codes shall require portability issues. I am a C++ developer. Last week
only I faced a lot of troubles in developing code sticking to the
basic C++ style and also using MFC.
I have one question.
Do the newer IDE's and dev env, like VC++.NET provide better support
for portability issues. I am using MSVC 6. Will I face any portability
issues and optimizaion issues later.
Maybe should I switch to VC++.NET.
Now, as common sense says, some of the dev's here shall point out that
it depends on the type of codes I a...Eseutil and switches
We have one E2K Standard server. DB is approaching 15GB and needs defragging.
Eseutil resides on C:\ The DB resides on D:\ There is not enough space on C:\ for the temp file.
What would be the exact syntax to defrag the DB and direct the temp file to D:\ ?
My best guess at the command line would be:
C:\>eseutil /d D:\DB.edb /t D:\TEMPDFRG.edb
Thanks for the help
There should be no space after /t.
dan p wrote:
> We have one E2K Standard server. DB is approaching 15GB a...B 2.5 Unable to validate company information in your backoffice da
I am un able to REinstall BP 2.5.
once I retry to install from scratch I get the following error
Unable to validate company information in your backoffice data
Great plains 8 with Business Portal 2.5
is it as simple of Dumping all the mbf Tables?
or is there more to this.
This problem may occur for one of the following reasons.
1. The wrong version numbers are listed in the system tables.
2. An orphan company exists in Microsoft Dynamics GP. Additionally, the
system tables in the DYNAMICS database contain references to a company that
no longer exists in Microsoft SQL Server.
See belo...Public Folders #6
Hi, i have a Public Folder mail enabled. When this folder receives a mail
outside my Organization this object is created like a post object. Whin this
folder receives a mail inside my Organization this object is created like a
message object. I need that the mails outside my Organization are created
like message objects. Any idea?
PD: Sorry For My English!!!
XADM: Update to Permit the Caching of Incoming SMTP Messages as IPM.Note
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send em...about my disabled 5 tear old
i want to tell people about a story about my 5 year old he is being
discriminated by by the state and its not fair and i have 3 other children
the comunity should no about please i would love to put my story somewhere i
need to get some help thanks god will love you and so will me and my5 year old
...MFC DLLs in Windows CE 6.0?
MFC dlls was no longer part of Windows CE 6.0 platform builder, so MFC
App have to use static library. If we still want to use MFC DLLs,
where they are?
On Jan 6, 10:03=A0am, ydlu <yudian...@gmail.com> wrote:
> MFC dlls was no longer part of Windows CE 6.0 platform builder, so MFC
> App have to use static library. If we still want to use MFC DLLs,
> where they are?
I got it.
the MFC dlls under: $(BINDIR)\$(ARCHFAM) directory.
I have looked all over publsiher 2000 and can't find wre to put what template
I will be printing too. I'm sure I missed it somewhere. Help would be
Do you want to re-word this?
Mary Sauer MS MVP
"Karen Rhodes" <KarenRhodes@discussions.microsoft.com> wrote in message
>I have looked all over publsiher 2000 and can't find wre to put what template
> I will be printing too. I'm sure I missed it some...Security issue with 5.5 IMC?
I am seeing some weird events in my Application log on my Exchange 5.5
server. It looks like someone is attempting to directly access my server
from a remote address. Here's a couple instances of what I'm seeing:
Event Type: Error
Event Source: MSExchangeIMC
Event Category: SMTP Interface Events
Event ID: 4183
Time: 10:35:58 PM
Authentication attempt (AUTH LOGIN) from 188.8.131.52 as \webmaster failed:
LogonUser() call failed with error: Logon failure: unknown user name or bad
Event Type: Error
Event So...Watermark #6
I am trying to put a watermark on an Excel worksheet.
I have tried using the Word Art but the lines still effect what is written in the cell.
Any suggestions would be gratefullt received. I am using Excel 2002.
maybe the following sites will help you:
And for Excel 2002+:
>I am trying to put a watermark on an Excel worksheet.
>I have tried using the Word Art but the lines still
effect what is written in the cell.
>Any suggestions wou...Column Labels #6
The Lables have changed from A,B,C to 1,2,3 and I can not change them back.
Any one can help please?
Tools|Options|General|Uncheck R1C1 Reference style
> The Lables have changed from A,B,C to 1,2,3 and I can not change them back.
> Any one can help please?
Go to Tools->Options and choose General tab.
In that uncheck 'R1C1 reference style'
> The Lables have changed from A,B,C to 1,2,3 and I can not change them back.
> Any one can help please?
Thanks a lot.
"Dave Peterson"...IF statements #6
I wish to create a cell that gives a rounded up/rounded down figure i.e.
Assume figure of 20.38
The number before the decimal point will be variable.
The number after the decimal point will be subject to the following
If < .124 then round down to next whole 0.5 (if 20.38 then figure to be 20.0)
If > .124 then round up to next whole 0.5 (if 20.38 then figure to be 20.5)
If < .624 then round down to next whole 0.5 (if 20.45 then figure to be 20.5)
If > .624 then round up to next whole 0.5 (if 20.72 then figure to be 21.0)
How do I write the formula please?
Hi Dave...Moving Storage Database
I have two domains and I'm planning leave just one. One runs an Exchange 2003
enterprise, the othe an Exchange 2003 Standard. I there a way to move all
email boxes from the standard to the enterprise server?
On Sun, 26 Mar 2006 14:50:42 -0800, Menjivar
>I have two domains and I'm planning leave just one. One runs an Exchange 2003
>enterprise, the othe an Exchange 2003 Standard. I there a way to move all
>email boxes from the standard to the enterprise server?
Move mailbox wizard in ESM.
...Exchange 5.5 Open Relay
I have done all of the necessary things to shutdown our Exchange
server and can telnet to port 25 to send mail and I always get
the message "Relaying prohibited". I thought I had it locked
down but using Nessus as a vulnerability scanner it tells me
that I have an open relay. Using the following syntax it says it
can relay mail.
MAIL FROM: <firstname.lastname@example.org>
RCPT TO: <email@example.com>
I substituted "nobody%nessus.org" with my home email address and
was not able to get a message through. Is there some kind of
exploit using a special syn...spam #6
How do I filter out e-mails with adult content words in
the body of the e-mail?
I continue to add to my junk senders and adult content
lists. I have the feature turned on so these lists are
looked at, but it doesn't seem to make a difference.
I've tried modifying the c:\program files\microsoft
office\office\filters.txt file buy adding additinal words
but it doesn't make a difference.
That can get old real fast....
Are you setting up rules to block the emails ? Rules, especially when you
are looking for certain words in the body of the text on my system (200...Running eseutil
I ran the esetutil last night on my exchange 2003 server, it took over 13
hours to run because the temp file is being copied over the network to
another system with enough hard drive space, my question is I had to stop the
eseutil from finishing because users needed to get back on the server so when
I restart the process does it start from where it left off?
I don't think so. How big is your EDB? I personally would stop IS then
copy the EDB to a server with good processors and memory and sufficient
disk space. Copy the ESEUTIL plus necessary DLL's (there is...Worksheet protection #5
I have a work book with over 120 worksheets. Is there any way to set the
worksheet protection on all worksheets so that a user can only select
unlocked cells. I know I can do this by selecting each worksheet, one at a
time, and deselecting all options but "select unlocked cells", but that
will be very time consuming.
A macro will do what you want.
Application.ScreenUpdating = False
Dim n As Single
For n = 1 To Sheets.Count
.EnableSelection = xlUnlockedCel...