how do i change the default value of measure from points to inche.
how do i change the default value of measure from points to inches when
setting the width and hight of cells?
You don't. Excel uses only points for these measures
remove CAPS in email address
"yoyo4u" <firstname.lastname@example.org> wrote in message
> how do i change the default value of measure from points to inches when
> setting the width and hight of cells?
Row heights are measured in points. There are 72 points to an inch.
Th...defining accounts receivable default accounts
We would like the ability to have limitations on the accounts that can be
selected for accounts receviable for a sales order transaction or receivable
transaction. Currently you can select any account number for the RECEV trx
type. We would like to define allowable accounts receivable accounts to
avoid our current out of balance condition. This would limit the
possibilities of reasons for ar trade to be out of balance to gl. This is a
very hot issue at many clients in trying to reconcile ar to gl. This could
also apply to AP!!
This post is a sug...The Settings button keeps disappearing
I'm having a weird problem when I access CRM using the web client. When I
access the site, I see all the buttons (Workplace, Sales, etc) except the
Settings button. If I reboot, the button is back. My security role is system
Any idea what is wrong?
Are you running the Microsoft CRM Outlook Desktop client in parallel?
Frank Lee, Microsoft CRM MVP
"Simon Renshaw" wrote:
> I'm having a weird problem when I access CRM using the web client. When I
> access the site, I s...Outlook 2003 offline caching changes
There has been a change in the default behavior of
Outlook from version 2000 to 2003 with regard to how the
offline cache responds when you have previously
synchronized the cache, and then reconnect online (in our
situation, it's particularly relevant when connecting
over a phone line rather than over a broadband or network
connection). We're wondering if there's a way to turn
back the clock..
In Outlook 2000, you would connect to the online mailbox,
and would view all the headers of all the messages in
your Inbox, Deleted Items, etc. (you still had to wait
for the head...Jounal Viewer
I have read questions posted but not any answer for this issue.
In the Journal Viewer - the batch look up is defaulted showing the oldest
batch first rather than showing the most recent batch first.
Does anyone know how to change this to default to listing the most recent
Appreciate any help.
...Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket
column on the Print Sales Documents screen? Currently when we open the
screen, we have to select which boxes to tick and since we always select the
same boxes we wondered if there was a way to have them default when the
screen is opened so we don't have to click each time. We want the "Picking
Ticket Per Site" box, the "Include Kit Components" box and the "Bin
Sequenced" box selected as default values.
You can accomplish this with a small VBA customization, b...Setting .doc default to .doc, not .dox
Operating System: Mac OS X 10.5 (Leopard)
How do i do this for all new documents?
> How do i do this for all new documents?
I meant .doc instead of .docx
Word> Preferences> Save, choose Word 97-2004 Document (.doc) from the Save
Word files as: list - just keep in mind that you'll be constantly working in
Compatibility Mode which will prevent the use of some of 2008's features.
On 4/23/08 7:50 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <dbdbdb@officeform...Public Folders: How to set up Auto-Reply in EX2003?
I've configured a public folder to receive mail from the Internet, and also
set up an auto-reply rule using the Folder Assistant to reply when an e-mail
is sent to the folder. The folder will auto-reply just fine if I e-mail it
from within the Exchange organization, but if folks from the Internet e-mail
the folder, it doesn't reply. Any ideas?
I ended up figuring out what the problem was. Just in case anyone else has
this problem, what I needed to do to fix it was:
- Open Exchange System Manager > Global Settings > Internet Message Formats
- Right-c...Reports and making it look prettier: Last Name, First Name Rank
I'm trying to pretty up my report by eliminating the forced space created by
having one field of the report for 'LastName', one for 'FirstName', and one
for 'Rank.' The Rank isn't too huge of an issue, and if three items in one
field gets to be too much, I have no problem leaving that as a side item of
sorts. But, I want my report to look a bit better by putting the names
I want the report to go to my table, pull the LastName from that column, and
pair it with the matching FirstName in the column to the right. (Since it's
just...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...Trying to set up account, geting nowhere FAST!
From: "Lenora" <email@example.com>
Subject: Understanding what Microsoft Communities
Date: Friday, September 14, 2007 5:41 PM
Hello out there!
What is Microsoft Communities all about? Is it something that comes with no
charge when you get Microsoft Vista? This is the 4th computer I've had
(besides ones at work). First a Compaq that I loaded everything I could
from work, the computer guy gave me stuff...did work at home, brought it
back to work, and visa versa.
Second was a re-built computer that was given to me by a man in the town we
had moved to...out of the g...Printing
Hope you folks can help me out with a strange one.
I have several worksheets formatted in exactly the same way as follows:
Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty
My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]
When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I m...Rules not working #7
I have a mail profile that I use with one email address that gets a LOT
of spam. I have a fair size number of rules (probably 10-15) for
categorizing and filtering it, all of them starting wth "Apply this
rule after the message arrives".
Problem is that most of them only work about half the time. I'll get
some messages that were moved to the correct folders, and some similar
messages still in the inbox. If I click "Rules Wizard" and the "Run
Now" button, selecting all the rules, it moves the ones still in the
inbox to the correct folder.
How come it didn...Out of Office (OOF) not working
OOF isnt working on one of our users mailbox, ie. she turns it on, but
it doesnt auto reply. ive searched through the existing posts on
solutions but still no joy. Ive disabled/re-enable OOF setting in
Exchange admin. The user has no exisitng rules setup. The oof never
worked so it cannot have been send one per user.
Im using Exchange 2003 with Outlook 2003 clients.
Any help, would help! thanks
If new mailboxes are working fine, you may want to take the simple "shotgun"
approach of exporting the users data to PST, saving out the rules, and then
creating a new mailbo...Default value for custom field?
How can I populate a custom field with a default value?
Specifically, I have a custom field "DisplayName"
associated with the Quote Detail object. I want initially
to populate this field with the value of the product name
field when a new product is added to a quote. The user can
then edit the DisplayName custom field if desired. The
DisplayName custom field will be used as the product name
on a Crystal Reports quote form.
...Make a cell flash
Please help I to make cell b1 flash when it becomes greater than 5
> Please help I to make cell b1 flash when it becomes greater than 5
see response in excel.misc
(replace somewhere in email address with gmail if mailing direct)
"Lloyd" <Lloyd@discussions.microsoft.com> wrote in message
> Please help I to make cell b1 flash when it becomes greater than 5
Thanks for the link. I ...Making CRM more attractive in Outlook
Hi, I'm new to this site (and MS CRM).
I am preparing a presales demo and want to make the outlook (desktop)
version of CRM more attractive for users by using the shortcut buttons that
I have two questions. One is more Outlook related, really.
- Can I create a new view in the navigation pane (like mail, calendar, ...)
with my CRM buttons? Right now I have all these buttons under "shortcuts" but
that doesn't appeal to the user.
- I have once seen a demo where a view was created with all the standard
shortcut buttons in a sort of "folder list",...hyperlinks within the same document are not working
I am trying to create an email publication in MS publisher 2007. It has
several stories that will be sent out in email and the first section is
supposed to contain a summary with hyperlinks to each story within the same
email for more details.
I am adding a bookmark at the begining of each story, and then trying to
create a hyperlink in the summary section to the bookmark.
However, when I send the publication as email, or do an email preview, the
hyperlinks do not work.
...initial default column width
Is there a way to configure Excel 2000 so that when I create
a new Workbook or add a new Worksheet so that all the columns
have a particular width instead of the default 64 pixels?
Create the workbook exactly the way you want it, then save it as a
template with the name "Book.xlt" (no quotes) in you XLStart directory.
It'll be then used as the template for new workbooks.
Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for
the template for Insert/Worksheet.
In article <419E181F.6251D20D@nospam.net>, Bruceh <firstname.lastname@example.org&...Hyperlinks do not work in email in outlook
Shortly after installing the new service pack for Windows
XP I began getting this message whenever I tried to click
on a hyperlink in an email: "This operation has been
canceled due to restrictions in effect on this computer.
Please contact your system administrator."
I assume it is because some switch has been set. Could
someone tell me how to regain the ability to use the
embedded links in email in outlook? Thanks
Bob <email@example.com> wrote:
> Shortly after installing the new service pack for Windows
> XP I began getting this message whene...Outlook 2003 working with Groupwise client
We are moving our people from Groupwise to Exchange and I
am having a horrible time getting the two to work
together. We need to keep both clients on the machine for
a short time while the switch is done. I installed Outlook
2003 on my workstation running Windows XP and Outlook and
Groupwise are happily coexisting. When I tried this on a
Windows 2000 machine everything went to crap. I've tried
all of the tricks I can think of. I've removed Groupwise
and windows messaging and reintalled everything from
scratch and no dice. I just keep getting Outlook MAPI
errors and messages s...OWA timeout does not work for every client
I set the timeout setting on OWA, i don't have any issues but i'm
getting lots of complaints that users are getting logged of after 15
min. why does this happen with some clients but not all?
...Exchange 2003 Envelope Journaling not working
I have a single Exchange 2003 SP1 server. I'm trying to get envelope
journaling to work.
I have enabled message journaling and then used "exejcfg.exe -e" to
enable envelope journaling. The journal mailbox is receiving the
standard message journal messages, but not the envelope journal
I have verified with LDP to confirm the heuristic value is 512 for the
Exchange Org object.
Anyone else seen this before or have any advice?
> I have a single Exchange 2003 SP1 server. I...Shared offline files
Does anyone have experience using shared workbooks in conjunction with
the Win2000 Offline Files feature? We used to use the Win95/Office95
briefcase function successfully, but with the advent of Office 97 shared
Excel files wouldn't merge. Spent time with MS tech support documenting
the problem but was never fixed. Was hoping functionality had returned
in Office/Windows 2000.
Thanks in advance,
...Setting up Exchange 2003
I had this problem the other day while extending the schema in
preparation for an upgrade to Exchange 2003. I searched through a lot
of databases and search engines, and found that a lot of people have
had this problem, but none of the forums led to a clear cut answer to
the issue. So, I thought I'd share my solution to try and help others
out, and save them some time and frustration. I was ready to call
Microsoft support right before I figured this out.
While running forest prep (setup /forestprep), setup failed with Error
code 0XC103798A. It then specified to check the Exchange inst...