I want to unlock my word doc to make changes its protected
I am writing a word document the other night. I went to carry on with it
tonight but found it has protected the document and won't let me continue
writing or editing
Word 2007? Assuming that you have activated Office, it seems your trial
version of the application has expired. Time to pay the piper!
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> ...Removing multiple users from Outlook
We did some computer switching, which involved uninstalling a copy of Office
XP and replacing it with a copy of Office 2003. Now when I open Outlook, it
makes me choose a user. This wasn't in the .pst file which was transferred
for the other computer, but apparenly it was on this computer someplace.
How can I get Outlook to simply open for the one account without that dialog
box popping up?
Control Panel | Mail | Show Profiles...remove any profiles you don't want.
Select the one you do want and set it as the default. (if there are more
than one left)
-Ben-...How disable postmaster reply in exchange 5.5
I receive mail from virus in my Exchange 5.5 with
this format name@mydomain with a virus attached
My exchange server reply with postmaster with the original
I think that this is Mydoom virus.
Please help me to disable NDR messages for any e-mail sent
to an invalid address.
Virus send e-mail with field FROM with addres that want
attack and my exchange reply with postmaster with the
original mail that contain mydoom virus.
Excuse me for my bad english.
It is not possible to disable generation of NDR with E55. Why not
install antivirus for Exchange?
> I rece...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up.
Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my
message this morning didn't mention the "New Menu" at all!
So, here is the non-VBA way to create a custom menu:
- TOOLS > CUSTOMIZE
- under the categories available choose NEW MENU and then drag the NEW MENU
option under the Commands window up to the menu bar (like D'UH!! <lol>
Wish all those hours spent searching yielded webpages that gave this! <g>)
- THEN one can go back to the MACROS category a few line...how to make macro work even a sheet is hidden.
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview
It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"
the macro code is
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
...unable to grant existing user access to TEST company
Set up test company using live company data; ran the script referenced in
CustomerSource article ID#871973; can grant and remove user access in all
other companies; ran grantsql 9.2; the dexsql log shows the user already
has access probably because of using the other company data for the test; I
can set up a new user and grant them access, existing users who already have
access can view the company...but, I cannot figure out how to grant access
to the TEST company to an existing user. The error popup reads "The user
could not be added to one or more databases."
Dynamics 9.0,...Disable Scanmail & Typical VM Largest Block Size
This is how to disable Mailscan as per Trend Support.
Stop all Scanmail services and unregister the event sink.
To unregister SMTP event sinks:
1. Open the command prompt.
2. For SMEX 7.0, go to the ..\Program Files\Trend\SMEX folder 3. Run the
toolSmtpEventSink.exe /unreg command.
After doing this the VM Largest Block Size does not decrease below 70 meg.
But 70 meg seems low to me. Is 70 meg typical?
...How export all mailbox-enabled users from the GAL using Outlook?
We have a user which, for administrative reasons, needs to export all
mailbox-enabled users in the GAL now and then. They just need all the
names. Is there a straightforward way for them to do that?
We don't want to give them any special permissions and want to avoid
server scripting. Ideally, they should be able to export it to a CSV
file or any text file.
> We have a user which, for administrative reasons, needs to export all
> mailbox-enabled users in the GAL now and then. They just need all the
> names. Is there a straightforward way fo...Re-enabled user account cannot log in
In trying to troubleshoot and issue in CRM where I had multiple user accounts
for a single ADUC user, I tried disabling and re-enabling a user's account.
But even after re-enabling the account the user cannot log in now. The error
message says that it is disallowed when he tries to browse to the CRM server.
Please help, I need to get this user account working again asap.
...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...IM Add New Batch
GP 10 on 2003 Terminal Server.
How do you create a Payables Batch in the IM in preparation for importing to
the Payables Transaction destination? Alternatively, how must GP be set up to
ensure that the “Add New Batch” rule works correctly?
With the Add New Batch rule set the IM crashes (see my post Integration
Manager 10 Crashes). Additionally the characteristics of the Add New Batch
rule do not match the required information which I understand to be Origin
and Checkbook ID.
I figured there might be some default settings for Origin and Checkbook ID
in the setup somewhere but was not a...How do I disable the handicapped feature in Excel?
Someone in my office turned the handicapped feature on and now you have to
hold the key down for a couple of seconds or the letter never appears. Does
anyone know how to reverse this?
Duh! Nevermind. Not an Excel problem. Control Panel - Handicapped feature.
> Someone in my office turned the handicapped feature on and now you have to
> hold the key down for a couple of seconds or the letter never appears. Does
> anyone know how to reverse this?
...Accessing another user's calendar OL2000/OL2003/Ex2000
Here's the situation:
Running Exchange2000, v 6.0, sp4. Users are on XP/OL2003 or NT/OL2000.
(we're in the process of upgrading all of the workstations to XP.)
VIP user is on XP/OL2003. He can access his calendar just fine on his
His secretary and other office admin type people are still on NT/OL2000.
They have reviewer or editor rights to his calendar. They try to access his
calendar by chosing File/Open/Other User's Folder... and put in his name and
calendar. When they do this, the process hangs. In Task Manager, Outlook
is "Running." End the Outloo...Moving exchange 5.5 to a new server exchange 2003
Good day all... how do I move exchange 5.5 to a brand new
exchange server 2003. The new server will be in a new
organization. Any info would be greatly appreciated.
Microsoft MVP - Terminal Server
>Good day all... how do I move exchange 5.5 to a brand new
>exchange server 2003. The new server will be in a new
>organization. Any info would be greatly appreciated.
...open outlook new email form from a crm form
It would be great to be able to open a New Email form (outlook form) by
pressing a button on the Contact, Account or Opportunity etc. form in CRM.
Customers like to use outlook for email and currently there is a disconnect
in that if you are on the opportunity screen and you would like to email the
Potential Customer (and have regarding on the email linked to the Opprotunty)
you have to leave the screen and start a new email in Outlook and lookup the
opportuninty you already have open again to populate the regarding if you
want to use Outlook. You could use Email button, but browser ema...OWA user can only see subject
OWA users are unable to see their mail. Only Subject field is visible,
without mail contents(No message is visible). Our outlook is working fine.
Any ideas why this is happening and how we can solve this.
...Query involving Strings : How To Return Matching Data From Both Ta
I have tried my best on this but am unable to figure it out.
Table A contains only one column titled [District].
Let's assume that there are three rows here:
1) Bay Area Rapid Transit
2) San Diego Zoo
3) San Mateo
Table B contains other data with these fields:
[GeoCode] , [CountOfHourlyEmployees], [CountOfSalaryEmployees].
Let's assume that there are three rows here:
1) West Coast | CA | Bay Area Rapid Transit , 154, 205
2) CA | Southern | Bay Area Rapid Transit , 105, 206
3) Southw...How to export users list from MS-Exchange AD Users&Computers?
I want to export my exchange mailbox-enabled users list with their Given
Name+Surname and e-mail address..
I get this kind of list from ActiveDirectory Users&Computers but I can not
I know that there is a program somewhere that does what I want, but I can't
remember it's name..
Note: I don't mean LDIFDE tools..
Thanks for your help.
As always...be careful and test things in a lab first, please.
LDIFDE tools can be pretty ugly...
CSVDE will work and it is possible to limit the columns that are output by
CSVDE. Note: If you have a large ...Making month boxes in Calendar transparent
I have been trying to create a calender where I use my own background.
However, the boxes with the month information block most of the background
because they are not transparent. Is there a way to change this so that the
background is visible through them?
Thanks for any help.
Calendars are tables, select the cells, select fill, click *no fill*
"Kat Lomas" <Kat Lomas@discussions.microsoft.com> wrote in message
>I have been trying to create a calender where I...Wake up, 97 Query in 2000/03
I've converted a 97 database to 2000 (seems to do the same in 2003) and one
of the select queries gives me no records when there should be quite a few.
I tried copying the SQL to a new query and, lo and behold, it works fine. It
feels like the SQL isn't compiling properly. Is there a better solution as
I've got loads of these queries, hardwired into a number of reports and it's
going to take a while to go through them all.
The only thing to say about this particular query is that it was written
some time ago and the designer was obviously happier with writing by hand ...Query to Pull Most Recent Call with a Callback Date Scheduled
I'm trying to create a query that only pulls in patients that have a
scheduled callback date, but only if the callback date was scheduled on there
most recent call. So far I've been unsuccessful. Below is the SQL that I'm
attempting to use-
SELECT [Patients Table].[Patient ID], [Patients Table].[First Name],
[Patients Table].[Last Name], [Patients Table].[Home Phone], [Patients
Table].[Day Phone], Max([Call]) AS Expr1, [Calls Table].[Call Outcome],
[Calls Table].[Callback Date]
FROM [Patients Table] INNER JOIN [Calls Table] ON [Patients Table].[Patient
...access- dynamic select query
I hav database table with 17 fields.While retrieving data, user
must be able to select any of the 17 fields ( it can be 1 or more than
1 ), that is decided by the user at runtime.how should i write the
SELECT query for this one.I am a newbie to ms-access.
Please help me out..
On 19 Mar 2007 22:23:38 -0700, email@example.com wrote:
> I hav database table with 17 fields.While retrieving data, user
>must be able to select any of the 17 fields ( it can be 1 or more than
>1 ), that is decided by the user at runtime.how should i write the
>SELECT query fo...