Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...Shortcut to other user's folders
At our office we view other user's folders by:
File:Open:Other user's folder...
Is there a way to make a shortcut in the "Outlook Shortcuts" pane on
the left to one or more of these user's folders?
Edit: This is in Outlook 2000
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from ht...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...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-...automaticaly create a variable sized table from user input
How can I user data input to a cell by a user to create a table with that
number of rows.
eg. User enters 1024 in B2
165 in B3
12.5 in B4
A10 would contain 1, B10 would contain =B3+(A10*$B$4)
A11 would contain 2, B11 would contain =B3+(A11*$B$4)
etc to 1024
The user entered number in B2 could be any whole number between 1 and 1024
I could make this better but other things to do right now so try this.
Uncomment the last line to remove the formula and just leave the values.
Range("a10") = 1
Range("b10").Formula = "=B3+(A10*$B$4)...Can E-mail recipient policy be linked to the OU membership?
Running Exchange 2003 (mixed mode) and Windows 2003 server (Windows 2000
I'd like to create a e-mail recipient policy that is linked to the different
OU's that are created on the system.
Is it possible to link the policy to a specific OU or do I need to create
groups on the AD to control which recipients a policy applies to?
Yes, you can create a recipient policy that looks to just a specific OU. It
is done through LDAP queries. Here are some references to articles and
whitepapers that discuss how to work with recipient policies.
HO...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...can i download lxce serv.exe
want to open message lxce serv.exe using windows xp
...how many receivers i can add
i want to use outlook send 2000 thousands emails to 2000 peoples at the same
can i put them all in the recivers and send them at one time?
thank you for you help
...Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...With and import tool can you change only item description?
Is there a way to change only the item description on a large quanity of
items. What about the extended description? Thanks for your help.
Use the MS SQL Data Import Tool by EMS. $65.00. The QSImport Tool available
to download from Microsoft will probably work but is not supported by
Kinnard L. Kohler
Business Machines Systems
6101 South Shackleford Road
Little Rock, AR 72204-8606
> Is there a way to change only the item description on a large quanity of
>...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...Can't configure Outlook Express
I had Outlook express set up for the Money newsgroup, but
somehow I lost it. Now I even forgot how to set it up
again. I always get the error message saying "server
cannot be found". The server name I typed in was
microsoft.public.money, and I am not sure what should I
type in here
Thanks for help
In microsoft.public.money, wj wrote:
>I had Outlook express set up for the Money newsgroup, but
>somehow I lost it. Now I even forgot how to set it up
>again. I always get the error message saying "server
>cannot be found". The server name I typed in was
&g...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,...what printers can run Vista
just purchased a dell which came with Vista on it. now my printer (HP 5550
deskjet) won't print. I need to find a new printer that i can hook up to the
This is an Access newsgroup. We help with questions related to Microsoft
Access - the database application that is part of MS Office Professional.
"monroe" <firstname.lastname@example.org> wrote in message
> just purchased a dell which came with Vista on it. now my printer (HP
> deskjet) won't print. I need to...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...Recommendations Please: Software That Can Backup Outlook While It is Open/Running
As the subject says. There are lots of packages that will backup the pst,
etc. once Outloook is closed, but some products claim to do it while Outlook
is open. Any suggestions on products that actually do this and do it
properly? If the product can safely backup over the network to a server and
can do incremental/update backups throughout the day, I'd really like to
hear about it.
...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.
...Start macro creating a mail with contact data and autotext
I am working with an user form.
The developing of that form started with Outlook XP with a lot of code
inside for different buttons.
I changed to Outlook 2007 and unfortunately the code of the form was not
What I learned about this is that MS does not support to much code in the
form (or maybe a bug).
They also do not support any longer.
I was sending this form to MS support but they told it is do much code
inside and they do not know, why the code is not displayed.
In Outlook 2003 the code is displayed as in Outlook XP.
Because I do not know real...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...Can not open PDFs
I'm using Outlook Express,when I receive e-mail with pdf
attachments I can not open or save the PDF files I can
see that the file is there but nothing happen.
Open the message in question. Is there a informational bar across the top
that states Outlook Express blocked access to the file? If yes, select Tool
> Options > Security tab and uncheck the second box from the top concerning
"Cesar Calderon" <email@example.com> wrote in message
> I'm using Outlook Express,...How can I sum only amounts that are in BOLD format within a column
I need to get a total from a worksheet that has hundreds of amounts in it.
However, I only need the total of the amounts that were marked with have BOLD
font. Please help me I don't have much experience with EXCEL.
Thank you very much!
W a n d a
try this for column D
x = Cells(Rows.Count, "d").End(xlUp).Row
For Each c In Range(Cells(2, 4), Cells(x, 4))
If c.Font.Bold Then mysum = mysum + c
"Wanda" <Wanda@discussions.microsoft.com> wrote in message
news:89A268A6-...DLLs being loaded for all applications
I get the following warning at system startup:
"Custom dynamic link libraries are being loaded for every application. The
system administrator should review the list of libraries to ensure they are
related to trusted applications."
How do I review the list of libraries and how do I eliminate any that should
...Can't use openURL or access internet on some locations
I have previously raised a question where openUrl threw an exception in
a specific office location. However the problem I have now is that the
application just freeze when I call openURL. It seems as it is waiting
This only happens at one company so far the company does have a proxy
but so do I at work and I have no problems.
I have also tried the Microsoft TEAR sample and it behaves the exact
same way, it says "Opening internet...Connection made" and then it just
stops. If I run it on my computer it gets the webpage and everything
I have tried to set t...Outlook has started coming up with wizard
My Outlook has started coming up with the wizard like it was first
installed. How would this have happened?
We don't know.
We don't even know what version of Outlook you have so how could we?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Jason asked:
| My Outlook has started coming up with the wizard like it was first
| installed. How would this have happened?
XP,2002,2003 have the same startup wiz...