how can i change my email address outgoing.
Ok, I have an email address which is 'piggy backed' to my normal email
address so that anything from work comes through to my outllook account.
When i receive mail it comes through as being sent to it ok.
My question is how can i set it up so that my personal email doesn't show
up on outgoing mail but shows as my business mail address thus looking more
> Ok, I have an email address which is 'piggy backed' to my normal email
> address so that anything from work comes through to my outllook account.
> When i receiv...Recommendations for Mobile workforce Password change
My company has about 150 users of which 100 of them never access the
Corporate network. These are Webmail and Smartphone only users (they do not
have company issued PCs). The only reason the have an account in AD is for
email access. So I am looking for recommendations for password change
procedures, policies, and tools. We run Exchange 2007 and there is a
password change feature but the implementation is lacking. If you force a
password change (through domain policy) the user cannot log in to get to the
password change option once the password has expired.
We have Exchan...Color box unavailable on Patterns tab in "format data series"
I have a user who is working with some charts and can not edit the color box
(is grayed out) on the patterns tab in “format data series”. We feel it is
a user setting or something because a different user can pull in the same
spreadsheet and edit the color of a graph bar just fine… Has anyone
encountered this? Any suggestions?
...Copy & Paste #3
What's wrong with Excel in office XP?
When I copy information from worksheet and try to paste
them in a new worksheet, Excel will paste whole different
text in the new worksheet? Simply the original text will
disappear and something new is created in the new
Is there some options that I should put on/off which would
make this problem disappear?
I hope that someone can understand this english.
This is not a known Excel 2002 problem and I think it has something to do
with your local setup. Try starting Excel in "safe mode" (from Start->Run
type &...Swap a BMP in a dialog
i have attached a BMP to a static
element in a dialog box.
This should be reclaced by another
one, when the user makes an input.
Thanks for any clue!
"Kai Sandner" <firstname.lastname@example.org> wrote in message
> i have attached a BMP to a static
> element in a dialog box.
> This should be reclaced by another
> one, when the user makes an input.
> Thanks for any clue!
Using Access 2007.
If I have one instance of Access already opened to database#1, then
attempt to open another Access db (database#2), I get "Permission Denied".
This happens whether I try to Shell out to it, or try using Windows Explorer
to open it.
Now the twist! If I start db#1, then try to start db#3, it works!
There's something about db#2 that makes the Shell command believe that
opening it isn't allowed.
Now the second twist!! After clicking through the "Permission Denied" error
msg, db#2 STILL OPENS! It doesn't do what it's suppose...login -- changed my password
silly me, not knowing that it wasn't my fault I changed
the .NET password on the microsoft site. Now I'm getting
the "Your sign-in name is not associated with your file"
I had the same problem and thought maybe I had a virus or
something. My password just suddenly didn't work and I
changed my passport too. I changed it back to what it
was. I'll be furious if this problem isn't fixed. I have
about a years worth of stuff in Money and was just
getting ready to use it to put together a budget, in
addition to the fact that I haven'...how do I copy several lines of word text into one excel cell?
In a word doc I need to copy several lines of text and paste them into one
excel cell. I can't seem to find any help telling me how to do this (each
line pastes into a different cell)
You can either double click the cell or press F2 key to get into edit mode
for the cell, then the text pasted would all go into the cell.
> In a word doc I need to copy several lines of text and paste them into one
> excel cell. I can't seem to find any help telling me how to do this (each
> line pastes into a different cell)
thank you SO much Simon CC - ...Saving Attachment
Using Outlook XP
Let's say I send someone an e-mail attachment or someone
sends me one - Either way. (For example: an Excel
spreadsheet or a Word document) I open it and make some
changes to the file. When I close it, the application
will prompt me to save it and then Outlook will prompt me
to save it. I save it on both prompts. When I open the
attachment in my e-mail, the changes have been saved. If
I forward the message to someone, the recipient receives
the attachment without the changes. How can the
attachment be saved (without downloading it to the hard
drive) and be ...text box filter by form
For some reason that I just can't explain, a text box on a form associated
with a single primary key field behaves unexpectedly when I do a
filter-by-form. Instead of listing all of the records from the source table
as choices in combo box mode, I only see "Is Null" and "Is Not Null" as
I have an older form from another database that behaves as I hoped this one
would, yet there seems to be no property differences between the two text
boxes. Can anybody explain what I'm missing please? Having "Is Null" and
"Is Not Null" as filt...Excel crashes after copy and paste of charts
I am using Excel 2002 and Micsosoft Windows 2000 Professional.
In my excel file I first create two sheets, one with only one chart an
another with two charts, then copy and paste the charts into
worddocument. Then I remove the sheets. I do this over and over in
loop, and after about 60 times (this varies) I get the message:
"Microsoft Excel has encountered a problem and needs to close. We ar
sorry for the inconvenience"
and then Excel crashes.
Any suggestions about how to solve this problem?
Message posted from http://www.ExcelForum.com
...Combo box to control two sub forms
I have a combo box on a form that I want to control the data viewed in two
sub forms. The combo box list months in the mmm format. One of the sub forms
is requests that have been approved with the date (mmm-yy) the other sub form
is requests that have been denied with the date (mmm-yy). When I select Jan
from the combo box, I want the sub forms to display only the records having
to do with that month. Is this even possible?
Your combobox provides only a month criteria while your data is both year
and month. That's not a problem except when you select a month, your subform
d...Change control workflow
Does anyone have any experience creating a change control workflow? For
example if we want all firewall changes to have an audit trail, and we need
someone other than who did the work to cross-check and sign it off before
that ticket can be closed?
...Outlook 2003 hangs when saving an Office document opened as an attachment
When a user opens a office document attachment from an email in
outlook 2003, they are immediately able to see and edit this document.
There seems to be an issue, however, when the user goes to File > Save
As.... in word, excel, or whichever office product is in use.
Outlook saves its temporary files to the temporary internet files
folder on the local (c:) drive. It takes approximately 60 seconds for
the dialog box to populate so the user can change the folder where
they would like the document to be saved.
This was an upgrade install from Office 2000. Does anyone know of
anythin...Moving mailboxes from Exchange 2000 to Exchange 2003 changes size
When we move mailboxes from Exchange 2000 server to Exchange 2003 server it
increases the mailbox size which causes issues with our users.
Can someone tell me why this is happening and what to do if anything to
prevent it from occurring?
It may be possible that you have a high ratio of single instance storage.
When someone sends an e-mail to multiple people on you exchange server it
only stores one attachement and each user recieves a pointer that points to
it. (this is all transparent to the user) But when you start moving
mailboxes for any reason it breaks this and makes a single a...Promt before changing a value
I was asked the below question by someone and was wondering if you
guys have any advise I can relay to him.
"I am looking to create something, most likely with VB code, in excel
that will pop up a dialog box to warn the user that they are changing
the quantity of a part by a more than normal amount. For example, if
the current inventory quantity for a specific insert is 10,000, then
if that cell is changed by more than 3000, a dialog box will appear to
prompt the user to double check their change. So, if that cell is
changed to 13,000 or higher, or, 7,000 or lower, the dialog box will
...Change in CTime data member fro 4 bytes to 8 bytes
Hi, I have legacy code that has a structure which has several CTime
data members. These data structs were written using VC6. When I try to
reade these same structs using VC7.1 (.Net 2003) I get errors, because
the CTime class now has a 8 byte rather than a 4 byte data member.
My question is can I use a compiler or some other option in .Net 2003 to
use the older version of CTime rather than the newer version. The work
around of reading the CTime data in as a long and then casting it to a
CTime works, but is clugy.
Hi, while it's nice of Microsoft to support CTimes beyond th...HOW TO CHANGE ROW COLOUR
I want that current row colour with its header change, when i move to nex the
previous row change to default. is it possible.
Message posted via OfficeKB.com
Huh? Some possibilities without a decent
description of what you want to do.
RowLiner Cell Highlighting Add In
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.o...Dynamic Range in a List Box with a blank choice?
Ok... so far so good !! 8-) ... I'm happy!
I have a named dynamic range similar to this.
.... and (by golly) it shows up in my list when I do Data>Validation>allow
list on another sheet!
But how do I provide a blank?
What I want to do is if a referenced cell is blank (no input from the user)
then the list shows a blank?
A little bit about what I'm headed for:
I am trying to develop a time sheet that will track:
running total time
what task I spent the time on (this is where my list box comes in)
then on another ...creating Dialog
The following question should be very easy to answer :
I am splitting my application into several Dll and I am
getting into troubles with my resources. I have built an
MFC Dialog and the associated class using the wizzard in
one of my Dlls. This Dialog is called by the main
application and it cannot open for any reason. If the
dialog id defined as Child, it does not crash but it does
not open, otherwise it crashes.
> The following question should be very easy to answer :
> I am splitting my application into several Dll and I am
> getti...automatically change text case on entry
I use the following code to automatically change the case of a range of cells
to uppercase in Excel, which works fine.
However I need some other cells in the same sheet to automatically change to
Proper Case. Is there a way of adapting the following code to enable upper
and proper case?
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Range("H1,M5,O11,F7")) Is Nothing Then
.Value = UCase(.Value)
Application.En...select items in a list box with a macro?
Instead of a mouse, can you select items in a list box with a macro?
You can use a line like this:
Me.ListBox1.ListIndex = 0
The first item in the listbox is item 0.
If you allow multiple selections, then this worked ok for me:
Private Sub CommandButton1_Click()
Dim iCtr As Long
For iCtr = 0 To .ListCount - 1
If iCtr = 0 _
Or iCtr = 3 _
Or iCtr = 5 Then
.Selected(iCtr) = True
.Selected(iCtr) = False
Next i...problems with charts copied into Word 2000
using Excel 2000 SR1 & Word 2000
created a simple chart in excel, copied it, switched to word and did edit /
paste special - link
when the chart is viewed in word (and after i've resized it) the rhs of the
chart is truncated (about 2cm - compared to how it looks in excel) - moving
the legend etc didn't seem to make a difference
i've not seen this problem before and couldn't find anything in google
groups that helped (still can't cope with the new interface!).
...copy format and formulas of one report to a second report
I need to copy a report to create a second report, and am looking to know how
to globally change formulas to a different table/query. The fields in the
two tables are identical, the data results are different.
Example of a Current formula:
=Sum(IIf([Customer Sat Results database]![The service or information you
received was appropriate and help]="Good",1,0))
New report formula would be:
=Sum(IIf([Internet Customer Sat Results database Query1]![The service or
information you received was appropriate and help]="Good",1,0))
there are about 96 formulas t...Track Changes in 2007 deleting large portions of text
We have a document where 3 team members are making updates in revision marks.
We are not updating at the same time. For some reason, huge chunks of text
are getting deleted that were never actually deleted by any of us. It has
happened to all 3 of us after we worked in the document. It is now the third
or fourth time that I have had to go back and reject the changes for the
sections deleted, and yes it does show my name or one of the other uses in
the name of the person who made the changes. I can go in, reject all of the
deleted sections, save the document, get out and get b...