Change entries in popup list for partially typed email addresses
When I start a new email and type in the first few letters of a
recipient name or email address, I am given a helpful list of
candidate addresses. However, the email addresses of one acquaintance
in this list needs to be corrected. How can I do this? I tried
looking in the address book, but none of the lists seem to contain
I am using Outlook 2003 on Windows XP.
The autocompletion cache has nothing to do with your Contacts. It is simply
a cache of your prior recipients.
Remove individual addresses from the autocompletion cache by highlighting
the entry when pres...Accessing Record Buffer in MCI
I am using MCI to record user audio through mic or any other recording
device. While I can play it back and save the audio easily, I have not
found any method to directly access recorded buffer.
How do i do this?
Thanks in advance
> Hi all,
> I am using MCI to record user audio through mic or any other recording
> device. While I can play it back and save the audio easily, I have not
> found any method to directly access recorded buffer.
> How do i do this?
> Thanks in advance
I think you can save your recorded buffer to a mem...Windows for newly converted records not showing up...
We seems to have a problem with our CRM system where someone tries to
"Convert a Lead" and clicks the "Open newly created record(s)" checkbox.
The system will convert the lead and create all the necessary records, but
it will NOT open the newly created records.
At first I thought it was a Pop-Up block issue, but I tried it myself with
all Pop-Up blocking turned OFF and it still is happening.
...Export chart value
I would like to export a chart without the link source from table data
Please help me. Thanks:mad:
excelvn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32724
View this thread: http://www.excelforum.com/showthread.php?threadid=555867
Maybe Jon Peltier's page on delinking chart data will help.
> I would like to export a chart without the link source from table da...Wrong time displayed
When I view my calendar in the office using Outlook, the
meetings are listed correctly. When I login to our server
remotely across the Internet, my mail works fine, but my
calendar displays all times 8 hours off ( a 9 am meeting
displays as a 5 pm meeting) !!
Outlook has the option of maintaining separate time zones so you can, for
example, see what time your 5PM conference call is going to seem to that
person in, say, London.
Not sure about your setup, but you might have either a second time zone set
or be switching between them. In general, the following is how to set one
up. If you...voting buttons not recording.
On occasions when voting Yes/No buttons (Outlook 2002)
have been used the replies do not always tally on the
original sender's e-mail. Any suggestions as to why and
...use the current time to return a value
Simple formula? if the time is >=07:00:00<15:00:00, G$1. = 1 if time
>=15:00:00 < 23:00:00 G$1 = 2 if Time >=23:00:00 < 07:00:00 G$1 = 3
I have tried to do this a few different ways and have been
unsuccessful. Could someone help please?
G1: =IF(OR(MOD(NOW(),1)<7/24,MOD(NOW(),1)>=23/24), 3,
IF(MOD(NOW(),1)>=15/24, 2, 1))
In article <firstname.lastname@example.org>,
> Simple formula? if the time is >=07:00:00<15:00:00, G$1. = 1 if time
> >=15:00:00 < 23:00:00 G$1 = 2 if Time...changing tcp port used by exchange 5.5?
We are trying to find out if it is possible to change the tcp port that
exchange 5.5 uses to send outgoing (internet bound) emails?
specifically, we are trying to have our internal exchange 5.5 server send
all outbound emails to our unix based/postfix server using a port other then
I have search both technet and google but seem to only find articles
relating to inbound or client based issues.
can you point me in the right direction/tech article?
I have to admit I don't know if this applies to 5.5, but maybe it'll help if
it's somewhat similar. This is how it'...Do not want to display negative formula results
If the result of a formula is negative, how do I display it as a zero?
A couple of ways
On Sun, 12 Sep 2004 11:29:02 -0700, "plabi" <email@example.com>
>If the result of a formula is negative, how do I display it as a zero?
"plabi" <firstname.lastname@example.org> wrote in message
> If the result of a formula is negative, how do I display it as a zero?
...Offline Outlook Synchronization should allow ALL records
I finally got my Great Plains integration with CRM working, and I have to say
that I am very disappointed that my customers do not synch with Outlook. I
just realized that only records that are "owned" by me will synchronize, and
not my entire database. All of my Great Plains records are owned by the
Integration user. I'm not sure that if I change ownership to myself, whether
that will mess up the integration with Great Plains. (does anyone know the
answer to this?)
My suggestion is that all users should be able to synchronize all accounts,
contacts & leads with th...Display Empty Cells as Bar on Bar Chart
I'm creating a spreadsheet to track patch deployment and it has five phases:
Initial, Test, Pilot, Due Date and Production. Most of the cells have dates
in them but some don't. I would like for the cells with no dates to either
show a bar associated with the phase with no date or show nothing, meaning
there would be a break in the bar. Is this possible?
...how to change range for dynamic chart in excel 2000 with button?
i need a help please.
i have problem in excel chart. i add data to the table.
and then if i want to update my chart i need to change the range too, isn't
is there any solution for that? i've already use dynamic chart. but it always
show data from Jan04 till Jan05. If I add Feb05 it will change from Feb04 to
what about if i want to see Dec03 till Dec04? is there any command or
something else like using macro or vb? thank you in advance..
You should be able to set the dynamic chart to show just about any range you
want. These articles should help:
http://pu...Changing English text to Spanish text
Hello can anyone help me out with this... I'm creating a
newsletter, and want to see if there is a way to convert
the english text to spanish... Any help would be great..
There are translation services available for a cost.
"Gilbert Saenz" <email@example.com> wrote in message
> Hello can anyone help me out with this... I'm creating a
> newsletter, and want to see if there is a way to convert
> the english text to spanish... Any help would be great.....How can I get Positive values only from the random number generat.
I am generating a random group of numbers using Excel's add-in "Random Number
Generator". I am using the normal distribution, but I want positive values
only. I know that the test I am doing will work with the negative values I
have generated, because the mean/stdev are correct. However, the activity
for which the numbers are associated can never be negative, so my
presentation will be less effective. Any ideas?
You could use the randbetween function and specify a positive range i.e.
> I am gene...Excell
How do I change font colour in a footer??
There are options to change the font, size, underline etc
but not colour... Can anyone help?
You can't change the font colour in a footer. If you really need
coloured text, you could print just the footer using Word, then print
the Excel file onto those pages.
Or, if you have Excel 2002, you can insert a coloured picture into the
footer, so you could create a graphic with the text, and insert that.
> How do I change font colour in a footer??
> There are options to change the font, size, underline etc
> but not...hide colum based on cell value on each worksheets
I have a workbook with several worksheets. I am trying to write a VBA
macro that would look at row 5 to see if any cells indicate "Hide
column". If it does, it would hide all the columns indicating "Hide
column" on this worksheet. Then it would continue the same process to
the next worksheet, and the next one ...
I currently have the macro working for the individual worksheet (see
below), but I would like to have it work to do all the worksheets of
Application.ScreenUpdating = False
Application.Calculation = xlCalculation...help with combo box display...plz...
i have a multicolumn combo box...with columns FName, MName, and LName...how
can i enable it to display the 3 values of the column when a row is selected??
it's like that i'm merging the 3 values int the text box display of the combo
On Fri, 20 Apr 2007 08:30:20 GMT, ai_enjoi wrote:
> i have a multicolumn combo box...with columns FName, MName, and LName...how
> can i enable it to display the 3 values of the column when a row is selected??
> it's like that i'm merging the 3 values int the text box display of the combo
> box......When message changes from text to HTML format, font is not the default
My outlook 2003 default format is HTML. The Default fond for new/reply
messages is Arial.
I get a message in text format. When I manually change the format of
this message to HTML, the font of the message is Times Roman.
How can I make outlook automatically use the default font (Arial) as
the font for messages changed from text to HTML ?
...Textbox value automatically selected, How?
This has to be a simple one.
When opening a userform I would like the value stored in the firs
textbox to be selected. Therefore I can just start typing over th
current value. Currently I have to click and drag the mouse over th
old value to select it
Message posted from http://www.ExcelForum.com
Private Sub UserForm_Activate()
Me.TextBox1.SelStart = 0
Me.TextBox1.SelLength = Len(Me.TextBox1)
Message posted from http://www.ExcelForum.com
That works well. Thanks
Now, how do I get the list of choices in a listbox to default to th
Message posted from...switching the axes, categories to values and vice versa
I'm trying to create a statistical add-on that makes a dot plot in excel 07.
right now i'm using a line chart with markers to create the values on the
y-axis and the categories on the x-axis, aka text items on the bottom. i'm
trying to figure out a way to switch these two, so that the categories are on
the y-axis and the values are on the x-axis while still maintaining my data
so that if someone changes it, the graph updates. i've looked at the peltier
pages and can't seem to get the bar-xy combo to work. i create my secondary
axis, move it over, and change th...How to not have formula change after inserting column from another sheet
One file - a few sheets. I run a macro weekly to copy column B of my
CURRENT PORTFOLIO sheet and insert that data between Col I and J (Moving
older data to the right - off the screen.) I then populate col B with
this weeks data. That works fine, BUT another sheet of that file (
GRAPH) uses that data to track a few moving averages. To keep the GRAPH
sheet accurate, after the macro I then have to modify the contents for
the SOURCE field of the graph because NOW $I$1 becomes $J$1 and $I$28
becomes $J$28. I can't use an INDIRECT command - I get an error. Name =
Weekly Moving Average, ...Formatting when combining text & value in a cell
The value of my cell is
="Product Margin is "&Z5
Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
format the percent when combining text & value? Thank you for your
="Product Margin is " & TEXT(Z5, "0.0%")
In article <firstname.lastname@example.org>,
"John13" <email@example.com> wrote:
> The value of my cell is
> ="Product Margin is "&Z5
> Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
> format the...code wild card value for form variable
i use a check box in an option group to generate a specific value for a
using the following code
If Forms![fee sched form]![select region] = 2 Then
Forms![fee sched form]![region var] = "Roch"
If Forms![fee sched form]![select region] = 3 Then
Forms![fee sched form]![region var] = "CNY"
this variable is hidden on the form and value is used a query.
how do i code this, so i can put "*" in the variable and thereby get all
values in the query?
the query code generates like "*" but i do not know how to code via the
fo...recurring deposit with wrong value
Isn't it possible to show the missing amount of a recurring value (and maybe
the missing deposits afterwards?) It does show the next missing recurring
value but not the difference between the expected and received value.
My situation: I've got a recurring deposit that misses 100 euro for one
deposit and misses two deposits a few months later. So at least i'd like to
know from money that i miss the 100 euro and maybe some othere afterwards or
i'd like to know that i miss the 100 euro and all other payments afterwards.
Thanks for your reply.
...Changing Quote status from Active to Draft
After we re did our picklists for reps (were originally not working - not
done right), it erased that data from all our past quotes. i need to run a
work flow rule to chang the Quotes status from Active to Draft, but don't
want to do that if it will affect the orders created. Can someone please
help me with this.
It really didn't "erase" the data. The problem most likely is that you
removed the entries for the previously saved values. You could just update
the numeric value of the underlying records with SQL (not supported, but in
this case safe). Othe...