Outlook across firewall #4
We are a small franchise and access our email using
Outlook 2000. The head office has the Exchange server
that hosts our email across a VPN using a Raptor firewall.
2 out of 6 or our Windows 2000 SP3 clients on the same
network are having problems when they try to access their
email for a second time. The error they get is "Unable to
access Exchange Server".
The only way to access the Exchange server again is to
restart Windows2000. Then it will fail with the same
error if they click on the Send/Receive a second time.
Thanks in advance.
...automatic copy cells into other worksheet??
i am trying to find out how i can type text in an excel cell and have it
automatically inserted in another worksheet.
is this possible?? if so how??
hope u are ok
go the sheet2 cell A1 and type =Sheet1!A1
and Drag it
and now go to sheet1 and type something in Cell A1 and A2 and A3 and then
check them in sheet2 Colum u will find what u have written
hope it may work for uuuuu
"Matt Hall" wrote:
> i am trying to find out how i can type text in an excel cell and have it
> automatically inserted in another worksheet.
> is this possible?...update worksheet in one file with worksheet in another file
I want to have one worksheet in one of my excel files (file 1) to
reflect the contents of a worksheet in another file (file 2) every
time it is opened (file 1), that is, everytime it is opened this one
tab should reflect the last changes made on the tab in another file,
including formating. I suspect this is possible but I don't have a
clue how to do it. I have a few questions:
Can this be done without VBA? (I'm not even a beginner with VBA!)
I did search the web some and found the following that looks
http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadI...I have a problem with getting a total Sum of numbers (URGENT)
I'd really appreciate if someone could help me here.
I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.
I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
numbe...how do i change or remove a signiture that is under outo text hea.
Someone please help i am using outlook 2003 and i am triyng to change a
signiture that is under auto text. to get into it i open a message push
insert then outo text then signiture. I want to change it. I have closed the
untilted message gone to tools then options then mail format then signitures
then remove all the signitures but the signiture under insert and outo text
is still there
See if this helps:
"nearly bald with frustration" <nearly bald with
email@example.com> wrote i...Counting Texts
If cell A1 contains a paragraph of texts and if I want to count just letter
"W"s (Upper or lower case), How can I achieve this?
Example: A1 contains "How now brown cow" the formula should return "4".
Write a macro and use the VBA functions Instr(strName, "w") together with
Split(strName, "w") and count the number of times that it finds "w" or "W"
"Keith" <Keith@discussions.microsoft.com> wrote in message
> If cell A1 co...Emails missing text
We have about 80 users on our Exchange server. We have 2
users that have an issue with reading their email. It
appears that when they open the email the right side of
the email/text is gone. When I shadow their session I can
see the entire email but they cannot. It is as if they
right section of the text of the email was deleted. I'm
sorry I'm not explaining this well. Any feedback is
...Export excel file to semicolon delimited text file
Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.
If you change your regional settings to use the semicolon as your list
separator, you can save as .csv and it should work. But this may affect other
programs, too--since it's a windows setting.
windows start button|settings|control panel|regional and language options|
regional options tab|customize button
near the bottom.
On the other hand, if you don't want to fiddle with...Sumif across a table
I am looking for a function that works using a =sumif function to add things
that are not in a range that are next to each other as seen below the letters
in () are the columns that the values are in...
so I am looking for a sum in column A "X" of the total work out time if the
appl column is "Y"
total work Running (D) Walking (F)
out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl (H)
X Y 20 N 0
Y ...Creating a task with a duration = sum of all tasks durations
Is it possible to have a task that has a duration equal the sum of the
duration for a set of tasks and that has work for that task calculated
automatically based on a formula of say number of hours per day times the
number of days duration?
Duration is not additive but work is. Imagine a summary task that has 3
subtasks, each of which lasts one day. If the three are in parallel,
starting together, they all finish at the same timne and all work on the
summary is complete since all work on its children is complete, The summary
task duration is 1 day. But as to work, each subt...text size in reading pane
Where is the font selection / text size control for the
Outlook 2003 reading pane (incoming emails)?
I just bought a brand new dell with windows xp and all
and I can't even increase the text size of incoming
emails as I could with older versions of Outlook Express.
I have been trying to figure this out for around 15 hours
now and have come up empty.
What kind of progress is this anyway???? A program
rendered unable to accomplish such a simple practical
thing like that!!
Im very upset. My vision is poor. Unless I get an answer
soon, I am considering a return of this unit to dell...can't see text in any office files anymore
Operating System: Mac OS X 10.6 (Snow Leopard)
on my macbookpro: can't see text in any office files anymore (word, powerpoint, excel). only when using preview function from OSX. <br>
what's wrong??? <br>
do I have to re-install the all suite? any quick fix?
...Automatically updating cells on other worksheets when data typed into primary sheet
I'm trying to create a workbook that will allow me to enter data on the
first sheet and it will then append the data to a second sheet by
automatically starting a new line.
I enter "This is a test" into A1 on sheet 1
First available line on sheet2 automatically updates with "This is a test"
When it comes to enter something new in A1 on sheet1, same function above
goes into action, accept it should be on the next available line which will
be A2 on sheet2, as A1 is already used by previous data entry.
Can this be done?
I would appreciate any help with this.
...Help Creating A Formula To Copy and Paste Text
Hi everyone. Thanks in advance for any help you may have.
I need to create a formula that searches for a specific word in a
column then cut the word and paste it to another column. Of course
this would be simple if it was the only word in the column, but there
is other text that I would like to remain in the orginal column..
You have a reply at your other thread.
> Hi everyone. Thanks in advance for any help you may have.
> I need to create a formula that searches for a specific word in a
> column then cut the word and paste it to ...Rich Text formatting in Access 2007
In Access 2007, is it possible to add rich text formatting to text in a memo
field (or mixed formatting within any text field). I have just upgraded to
the new version of Access, and it appears that this feature still has not
been added. Is this correct? (If so, why?) If it is not possible to format
individual words within a field in Access, , is there a simple, free add-in
that will enable Access to do this kind of basic formatting, such as adding
italic, bold, and underlining?
Thanks very much for any information you may have.
Rich Text format for Memos in:
Tables - Look in t...Footnote text cannot be entered without mouse click
Operating System: Mac OS X 10.6 (Snow Leopard)
Normally adding a footnote number automatically adds that number to the bottom of the page. A blinking text entry indicator normally allows me to enter the footnote text without any additional step. <br><br>However, today I wanted to add a footnote number after a word, and although the corresponding number correctly appears at the bottom of the page, and the blinking text entry indicator also appears ready to allow entering footnote text, yet when I try to type, nothing is entered. I must resort to ...Sum of values in a form
I have read numerous threads on this topic, and understand that in order for
my Sum() to work I need t ensure all references are made back to the Record
I have endeavoured to do this, but am still getting #Error.
I am trying to Sum the revenue each tenant provides in a given date range, to
give a total revenue figure. If the date range is a whole month, then the
expression just takes the value of Rent PCM, and not Rent PCM * No. of Days,
which would give some unusual results.
My Expression looks like this:
=Sum(Nz(IIf([Short Let]=-1,[Rent pcm],IIf(Day([Forms]...Add numbers accross columns after stripping away text
I have the following data in a spreadsheet:
A1 B1 C1 D1 E1 F1
4.5f 6f 3.5f 3f 7.25f
I need to be able to add the numbers together to give me 24.25, i.e. strip
the fs away. The numbers will always be less than 10 and the there will only
ever be .25 or.5 or .75 after the number (I don't know whether that is
If anyone can show me how to do this I would be very grateful. I have been
messing around with MID and FIND to no avail and then started thinking that
SUMPRODUCT might have to get involved but it all got a bit m...Mottled Text in GIF Image
I'm trying to put a GIF image into my signature page. The image is a
Static GIF Image that consists of a graphic and some text. When I go
to write the email it appears correctly, however when I send the email
the text portion is mottled.
I am sending the email to myself and this still occurrs so it is the
same monitor, computer, software etc.
Anyone have any ideas on what is causing this. Should I covert this
image to a jpg or some other format?
Thanks in advance
...Impossibly Tiny Text
On rare occasions Excel 2003 (with all updates) screws up and will display
just one sheet with impossibly tiny text - like only one or two pels high on
the screen. All other sheets continue to look normal. All the cells appear
to still have correct information in them, it's just tiny.
I can select the entire sheet and tell it to use 100 point type and it will
produce type that looks like maybe 10 point type on the other sheets. Or I
can copy an entire good sheet, and "Paste Special" only the formats onto the
bad sheet and get back the impossibly tiny text again. Saving ...Copy a formula formatted as Text In Excel
I have a UDF that returns the formula of a given cell in a text
format. Is there anyway to have excel recognize that the result of
the function is a formula and not text.
Once I click on the cell, hit F2 to edit it and then enter, Excel
realizes it's a formula and then calculates the value,
The formula in the cell is going to be the UDF--not the what formula string
You could add some more steps.
Select the range (if more than one cell)
Convert to values (edit|copy, edit|paste special|values)
what: = (equal sign)
And exce...Extracting a word from a long text field
I have a text field (up to 200 characters) and I need to extract a specific
The text field name is "MEDICATIONS" and the word I need to extract which
might appear anywhere in the field is 'VENOFER'. The word need to be entered
in a separate field in a query.
Could any one help as to how to enter the code in the query?
In the criteria I entered Like "VENOFER" Or "Venofer"
It seems to work.
Will it cause any problems down the line? In other wrods is this an
>...IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file
from a sales database using IIF statements I adapted from another database
(I’m a novice at this). The field I’m querying is text format and contains
both alpha and numeric values. When I test for a null value the IIF works
fine, but when I test for a numeric value I get an #ERROR.
Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is
Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And
[Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...Largest text box
I have 3 text boxes on my form and I need to find the largest number among
I tried =max([txt1],[txt2],txt3]) but this is obviously wrong. How can I do
Thanks for all help offered!
If .txt 1 > .txt2 And .tx1 > txt3 Then
'Txt1 is greatest
ElseIf .txt2 > .txt1 And .txt2 > .txt3 Then
'Txt2 is greatest
'txt3 is greatest
Dave Hargis, Microsoft Access MVP
"Johnny Bright" wrote:
> Hi there!
> I have 3 text boxes ...Converting incoming email to plain text
Is there any way I can configure Xch 5.5 to convert all received SMTP email
to plain text ? I can't find any option.