Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...Problem with "Use Unicode Format when saving messages"
In outlook we have option to set "use Unicode format when saving
messages"(outlook>tools>options>other >Advanced options),even though option
is enabled, when ever I try "save as" the email into folder, it is showing
Html format by default.However can drop down the list and select the Unicode
But I need Unicode message format to be shown by default if I need to "save
as" any email.
Any Suggestion ?
That is not possible and that is not what this option controls.
The option controls whether the default safe fo...Reading SQL Server Extended Properties
I have an Access 2003 front-end (mdb/mde) connected to a SQL Server 2000
back-end. SQL Server 2000 offers the ability to add extended properties
(such as a caption, for example) to objects (tables, columns, etc.) using a
stored procedure called sp_AddExtendedProperty, along with the ability to
retrieve the values of these extended properties via a function named
With fn_ListExtendedProperty, four columns can be returned/selected using a
Select statement: objtype, objname, name and value. The first three columns
returned are of datatype sysname, whil...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...Reporting from Project Server
I dont know if i need to ask this question here or in the Access section. I
have an ODBC connection to the Project Server database so I can make reports
through Access. Access' limit of 255 fields per table is causing me some
trouble. for example, the MSP_VIEW_PROJ_PROJECTS_ENT table has well over 255
fields. Access only shows me the first 255 fields. how can I change that so I
can see all the fields in that table?
I have not tried this yet it may be a viable option. Have your DBA create a
view that pulls the key fields to this table and the specifi...Microsoft CRM 3.0 Installation 11-08-07
Good Day board,
Quick and to the point. I'm installing a trial copy of Microsoft CRM 3.0
that I got at a computer conference recently and I've gotten everything
to work in the System Requirements dialog except that it's telling me
that "The minimum required version is SQL Server 2000 SP4 (8.0.2026)".
Strange this is that I do believe that I have SQL Server 2005 installed
on the machine.
Any idea how to be absolutely sure of what version I have installed?
Have you choosed the right name of SQL server during installation set-
You have to make it sure if it is ...Voice connector on Exchange server 2007.
Is there any functionality available in exchange server 2007 regarding voice
If not how can we create it?
Thanks in advance.
Exchange 2007 has the "Universal Messaging" role which is intended for this
purpose. Do you have a PBX?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Microsoft Exchange 2007 command shell"
<MicrosoftExchange2007commandshell@discussions.microsoft.com> wrote in
> Is there any functionality available in exch...will CRM load on a 2003 server?
will CRM load on a 2003 server?
Microsoft CRM v1.2 supports Windows 2000/2003 Server.
>> Other Microsoft CRM Online Forum Resources:
>will CRM load on a 2003 server?
No problem. We just completed a 1.2 installation on a 2003 server, without
"Troy Hicks" <email@example.com> wrote in message
> will CRM load on a 2003 server?
CRM 1.2 will also load on Small business server 2003 as wel...Filters not working in Exchange 2003
I have been trying to turn on the Recipient, Connection, and Sender filters.
I have gone to the Default SMTP Virtual Server and turned it on there without
getting an error but when I go to the Properties and add senders to block and
the hit Apply, it tells me that I must manually turn the filtering on in the
SMTP VS. I have stopped and started the Default SMTP VS but still no luck.
That is a standard dialog box, it does not check to see if it is already
enabled, have you tested the sender filtering?
This posting is provided &quo...Contacts in Exchange #2
We are running Exchange 2003 and Outlook 2003. I have tried to give a user
rights to her boss's contacts through delegation and setting the rights on
the contacts folder, however, while she has the rights she is unable to add
or see her boss's contact folder in her Outlook. She can see it if she runs
a search, but can not permanently put it in her list of contact folders. IS
there a way that I can accomplish this through the back-end?
...Redirect Exchange 2000 IS backup to different Exchange 2003 server
I recently added an Exchange 2003 server to the same org as a 2000 server. I
have dbs from the 2000 server that I need to restore to retrieve email from a
user whose mailbox was moved to 2003. So I need to restore the db for that
mailbox from BEFORE it was moved because when you move mailboxes you lose any
deleted items that were being saved by retention policy.
Is this possible? I'm using Veritas Backup Exec 10 but nothing in their
support KB seems to follow this exact scenario.
If it helps, the old Exch 2000 server is currently empty of users and is
ready to be uninstalled. W...Document Viewer installer error
I recently ran CHKDSK /F as this was prompted when I attempted to run defrag
etc. Since the chkdsk was run, when I turn my PC on, I receive the following
"document viewier - installed encountered an unexpected error - error code
2908". I click run, the same error just repeats and loops. The only was I can
remove it is to end task via task manager.
Any ideas how I can correct this error?
...using the journal on outlook
Once I link an email to the journal, can I still find that email in my mail
box? I seem to be able to get to it only via the journal. If this is the way
it is supposed to be, how do I remove it from the journal and get it back
into my mail box? Am I just missing something?
Are you linking to the item or putting a copy into the journal item? Also,
has the item been archived or not?
"Independent" <Independent@discussions.microsoft.com> wrote in message
> Once I link an email to the journ...How do I see when new messages without outlook running?
Without Outlook 2003 constantly running, how do I send mail or know when I
have new mail?
two possible answers...
1) you don't or
2) you acquired a 3rd party app to occasionally poll your pop3/imap account
"Leslie Adams" <Leslie Adams@discussions.microsoft.com> wrote in message
> Without Outlook 2003 constantly running, how do I send mail or know when I
> have new mail?
...How to move MS Office without reinstalling?
I have an iMac that has had Microsoft Office on it since 2002 or so. Other
family members have bought MS Office as well since then. They are all v. X.
Each has a unique product ID and the only disc copy I can find for installing
MS Office has a key on it. I don't know if it was my original copy. I will
soon be reinstalling an OS on the iMac and in the process, I will have to
wipe it clean. Is it possible to copy all of the MS Office files to
appropriate backup locations, then copy them back when the install is done so
I do not have to reinstall from the disc and risk it not be...How do I overlay text to a row without loosing the text in the ba.
I would like to know how to give an entire row (or column) a text overlay
such as "VOID" and still be able to view the text in the underlaying row (or
Thanks in advance.
Use WordArt from the Drawing toolbar. Change the Fill to None.
"Bruce Charles" <Bruce Charles@discussions.microsoft.com> wrote in message
|I would like to know how to give an entire row (or column) a text overlay
| such as "VOID" and still be able to view the text in the underlaying row
| c...Disable Secure Sockets Layer on exchange server when using RPC over HTTP
Hi im trying to enable RPC over HTTP to enable users to establish contact to
my Excahger server 2003 over the internet.
Now, I dont want to use SSL (security not that important) and i am told by
this article that i can disable SSL in windows registry.
Note While RPC over HTTP does not require Secure Sockets Layer, you must
modify the registry to enable RPC over HTTP if you do not want to use Secure
Sockets Layer. Microsoft recommends that you enable and require Secure
Sockets Layer for your RPC over HTTP communications.
At this address: http://support.microsoft.com/?id=833401
But i ...Does Outlook use the DAV protocol?
I'm an Outlook Express user who wants to switch to Outlook. I received a
notice from Microsoft that includes the following: "... as of June 30, 2008,
Microsoft is disabling the DAV protocol and you will no longer be able to
access your Hotmail Inbox via Outlook Express."
Please tell me if this action by Microsoft will affect Outlook in the same
manner, or am I free to make the switch.
"BudV" <BudVitoff@(NO)att.(SPAM)net> wrote in message
> I'm an Outlook Express user who wants to switch to Outlook...CRM and Outlook Integration 07-22-03
I haven't seen a whole lot of great documentation on this - so if someone
knows where some exists then please tell me - but I'm curious as to how
featured the Outlook/CRM integration is? I see there is an addin for Outlook
that gets installed, but it looks to me like it's nothing more than a
synchronization tool between Outlook and the SQL Server - am I right? It
looks like it syncs Contacts, Emails, Calendar dates, etc.
I've looked through the SDK documentation and I've browsed a couple posts,
but none really say outright in exactly what way does Outlook and CRM
...mail queues for long on Exchange 2000 server time before being sent
I have a situation where all outgoing mail sits in a queues on the Exchange
2000 server (one per domain) for about 45 minutes before being sent. The
queues in question have a status of ready. There are also other queues of
that are retries (mostly NDRs from junk mail). We are only a small company
and the amount of mail is not great. What might Exchange be waiting for
before sending this mail? Is there something I can tweak to make it send
Thanks for any help,
Where does the mail go after it leaves your Exchange server, does it go to a
smarthost/isp or d...Installing Active Directory connector?
We are installing a 2003 exchange on a 2003 server in a
2000 domain. We also have a 5.5 sp4 machine running on
2000 sp 4, and once 2003 is installed, we are going to
move the mail boxes from the 5.5 machine. My question is,
do we have to install the active directory connector on
the 2000 Domain server, or could we install it on the
> We are installing a 2003 exchange on a 2003 server in a
> 2000 domain. We also have a 5.5 sp4 machine running on
> 2000 sp 4, and once 2003 is installed, we are going to
> move the mail boxes from the 5.5 machine. My q...Reply To Email after installing CRM Outlook Client
After installing the CRM Outlook Client, when opening an email and selecting
REPLY, the current windows looses focus. I know this sounds minor but many
of our power users are in the habit of hitting REPLY and typing without even
looking at the screen. It is not until they look up do they realize that the
window no longer has focus thus everything they thought they typed now has to
Has anyone seen this and know of a quick fix?
Thanks in Advance
Have you resolved this?
I have the same problem, and it is VERY annoying.
"Kenneth Clebak&...Exchange 2007 Content Conversion/Encoiding issue.
I have an Exchange 2007 RTM box running in a Windows 2003 only domain.
When we scan a document from our Dell 1815n multifunction and have the
output emailed, the document shows up as encoded garble instead of an
attached document. A message header from a bad email is below.
When we scan a document from the same device and send it to a mailbox that
still lives on our last remaining Exchange 2003 server, the output from the
scanner is attached as a PDF document normally.
Header from email recieved to Exchange 2007:
(server names and I...Terminal Server and GP Settings
Not being a Windows Terminal Server expert by any definition, I have a
question for somebody who is.
When wanting to have a user profile to store individual dex.ini files, my
understanding is that each user would have his own Windows folder under their
user folder. Additionally, if you typed SET at a command prompt, the settings
for WINDIR would point to that user-specific Windows folder. Is this thinking
Charles Allen, MVP
I think you also have to make certain that the dex.ini does NOT exist in the
program install location for GP or it will still look to that.
Dwight...HOWTO: Customizing CRM
We would like to customize our CRM Opportunity form. We want to
include a OpportunityNumber field, which will be auto-generated when
the new opportunity is created, similar to auto-numbers for Contracts,
Cases, Articles, Quotes, etc. Is it possible and how do we go about
I've looked at CRM Deployment Manager. It's possible to create a
simple custom Attribute for particular object. But I couldn't figure
out how to make it an auto-generated number, like SQLServer
Identity... Could I just modify OpportunityBase table in MSCRM
database? Do I need to change METABASE databas...