difference send as / receive as
I know that if you want under E2K "service account" access to mailboxes you
must give yourself "send as"/ and "receive as" access ". But can anyone
please tell me the whaht is the difference between the two permissions ?
> I know that if you want under E2K "service account" access to mailboxes you
> must give yourself "send as"/ and "receive as" access ". But can anyone
> please tell me the whaht is the difference between the two permissions ?
> Regards Je...Updating two two tables based upon the response to questions in a subform
I'm trying to populate two tables based upon the results to questions on a
I have a form and one subform. The subform has a variable number of questions
related to the form. Each question is limited to either "Pass", "Fail", or
If the user should select "Fail" on a question, I want to add a record to a
table called "tblCARs" and a record to a table called "tbl CARLineItems".
However, for every subsequent "Fail" response I want (need) to only add a
record to the table "tblCARLi...Differences in various auto-fit options (2007)
Does anyone know why these two autofit mechanisms give different
1. Right-click in table | AutoFit | AutoFit to Contents.
2. Select entire table | Double-click right border.
Right-clicking in a table brings up a list of options. One of them is
Auto-Fit. Selecting Auto-Fit, brings up three options:
AutoFit to Contents (AFTC)
AutoFit to Window (AFTW)
Fixed Column Width (FCW)
AFTW makes the table as wide as possible. I am not sure how it decides
how wide to make each column.
AFTC doesn't seem to work all the time. I have a table with 18 columns
on a le...Counting how many different names in a long list
I have a list of 332 names many of them are duplicated. I am looking for
a formula or function that can count how many unique names there are in
Can anyone help?
Quaisne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28052
View this thread: http://www.excelforum.com/showthread.php?threadid=501357
This'll count the number of distinct values in a range:
(adjust the range to matc...Easier Time Entry
Operating System: Mac OS X 10.5 (Leopard)
Hi Everyone, <br><br>I'm a newbie to this forum. Please apologize if this question has been asked before. Though I did search before I post this question. <br><br>I did some look-around in the forum of Excel for PC and come across someone suggesting the following website for an easier way to do time entry in Excel, but I don't think this works with Excel 2004 for Mac since I tried and it doesn't work. <br><br><a href="http://www.cpearson.com/excel/datetimeentr...Unable to update free/busy time
This morning I installed the Exchange 2000 post-sp3 rollup on our
small business server. Since then users have been getting messages
from Outlook saying that it can't update free/busy time on the server.
Prior to installing the rollup we did not get the errors.
I had a look at the event log on the server and it is filling up with
EventID: 1546 errors, the description is:
Workflow event sink error [event: OnSyncSave, URL:
group/USER-_xF8...Run-time error '5'
I'm getting a weird error on one of our computers. As soon as I open Excel
and click anywhere on the sheet, I get an error:
Run-time error '5'
Invalid procedure or call argument
This is just a blank document, with no macros or VBA code. Why am I getting
I would appreciate your help.
try removing all add-ins
Peter Afonin wrote:
> I'm getting a weird error on one of our computers. As soon as I open
> Excel and click anywhere on the sheet, I get an error:
> ...Calculating date difference
I need to calculate the number of years of service for
person(difference between Start_Date & End_Date). The result should b
in terms of years, months and days (all in one single cell). Ca
someone please help?
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Have a look at Chip's site:
"rll" <firstname.lastname@example.org> wrote in message
&...Corporate or Workgroup, send from different accounts
I have been using Outlook 2000 (CW) in order to attach
history to my contacts in ACT! This has been running
well. The problem I've run into is I used to be able
click on the "Send" button and choose a different email
account to send from, I no longer have that option since I
set up the workgroup settings.
The email account that I can't send from is a Linux
firewall account we use for internal emails...I can
receive emails, but I can't reply or send new messages.
They keep coming back as undeliverable.
Any suggestions/feedback would be greatly appreciated.
...Total Minutes Worked Within IVR Timing
I need to figure out how many total minutes employee worked during the IVR
Each employee works different shift and it can run overnight into next
morning where there may be IVR coverage before employee logs out. IVR Timing
is same for Saturday/Sunday and same from Monday to Friday.
IVR Timing Table; data type is Date/Time but only Time is available because
date should be same as the schedule date
DayIs IVRStart IVRStop
Sunday 10:00:00 AM 6:00:00 PM
Monday 9:00:00 AM 9:00:00 PM
Tuesday 9:00:00 AM 9:00:00 PM
Wednesday 9:00:00 AM 9:00:00 PM
Thursday 9:00:00 AM ...Writing XML from Dataset to Response Object as Binary File
I have looked fot his solution, but Im not sure what to search for.
I have an asp.net based report. I need the user to be able to download
an XML file of the results so they can use the data in Excel, etc.
I do NOT want to write the file to the server first. I just want to be
able to write the contents of the Dataset into a binary file and send
it back out to the user as a download, but all in memory.
Can you give me a boost in the right direction or an article that
> I have an asp.net based report. I need the user to be able to download
&g...include busy/free time from "other" (i.e. ics) calendars
Please see the following thread. Is this possible? Could it be added as a
future enhancement request?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and t...total of a range of times
This should be simple for some of you, but not for me.
I am a runner, I have 4 ind. cells w/my split times. How do I get a total
for the tallied times.
I'm far from being experienced but am trying to learn..any and all help will
be much appreciated.
To help you in your quest to "try to learn" I will direct you to Chip
Pearson's site so's you can learn just about all you'll ever need for Time
Gord Dibben Excel MVP
On Sat, 13 Nov 2004 15:19:02 -0800, "Roger WG" &...Autoformat dates and times
I have a workbook with two columns. In the formula bar of one of the cells
i have 2005040101700 (YearMonthDateHoursMinutes), but what shows in the cell
When I try to format the cell as yyyymmddhhmm I get ########### and when I
put the cursor over the cell with ############### it says that negative dates
and times are shown this way. How can I make this work?
I'm hoping that your actual value is different: 2005040101700 doesn't make sense:
year 2005 month 04 day 01 hour 01 minutes 70 seconds 0
Perhaps it's really
200504010...How do I automatically plot different ranges of data in different.
I need to chart parameters that are a function of three variables in the 2002
version of Excel. I have used the x and y axis to represent 2 variables on an
'xy chart', but require an automatic method to represent the value of the
third variable. I have tried the 'bubble-plot', but cannot get sufficient
resolution between the data. Is their any way that I may plot the third
variable in different colours/shades, that automatically changes for
different ranges of the the third variable?
THis might help you:
&q...Why does Outlook's message recall feature work sometimes but not all the time?
Basically my users have a problem with message recall. The
problem is sometimes it works but most of the time it
doesn't. Even more frustrating is when they get a
successful recall notification message and then they get a
reply to the message that was supposedly recalled
Can anyone give me a straight answer or point me in the
direction of a reliable article on message recall.
www.winnetmag.com has an article that you have to pay for
and Microsoft just explains how to use it.
Thanks in advance,
Senior Customer Support Specialist
Message recall is really unr...Publisher 2007 will not open my old files
What to do? All of a sudden, my Publisher 2007 will not open any of my
publisher files, even others done in publisher 2007. It crashes EVERY TIME.
I have run Office Diagnostics twice, with no result. I have uninstalled and
reinstalled Office 2007 TWICE, still no change. Do I just abandon it and go
back to Publisher 2003?
I've run virus scans, defragged, tried other versions of these files, tried
files done by others - NOTHING works. it will start a new project, but will
not open an old project without crashing.
Can I install Publisher 2003 and use it even though I have Office ...Downloaded transactions must be re-accepted every time
I bought Money 2005 last week and got it all set up. But when I turned on
the auto-reconcile downloaded transactions option, I found that every
transaction it pulled from my bank servers for the last month had to be
re-accepted even though it had been downloaded, accepted, and reconciled.
Turning this option off didn't fix the problem. It is very frustrating
because I can't tell what's new and what's not now. It treats all my old
dowloaded and reviewed transactions as something new. Anyone know why or how
to fix it?
In microsoft.public.money, BASIC since TRS-80 wro...Operator Overload between different types
I'm trying to implement the overload for two different kinds of objects. I
tryed for example:
Dog1 + Dog2;
Dog Dog::operator+(Dog& s)
return this->nBau + s.nBau;
it works fine.
I need something...
Dog1 + Cat1;
??? Dog::operator+(Cat& s)
How can i implement my overload between different types and what type of
object must return?
I can only compile my program only specifing "return 0" in overload function
but it doesn't work.
Maybe i must implement overload function as static function outside class
Some help please.
My final n...Automating Different Survey Results
Does anyone have any idea on how to facilitate the preparation of surve
Our survey results are downloaded from our survey online facility (som
facility when it can't even produce the report :sigh:). These survey
are about the services of the different support groups of our company
So each survey has its own set of questions. The backend process o
translating these results is quite tedious and I've been thinking o
how to automate it ... I know that there is a better way. I am usin
Excel but only the standard features such as countif, sumproduct
pivot, charts. But still it c...different colors for x-Value axis
I want to use different colors for X-Values in X-axis of a chart. Is it
I-1, I-2 black
II-1, II-2, II-3 grey
III-1, III-2 red
V-1, V-2, V-3 green
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan
The best solution is that, Excel brings the formatting of x-axis value from
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan
> I want to use different colors for X-Values in X-axis of a chart. Is it
> I-1, I-2 black
> II-1, II-2, II-3 grey
> III-1, III-2 red
> IV pink
>...What's the Difference Between This NG and microsoft.public.excel.misc?
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet
Web Page: <www.speckledwithstars.net/>
You are posting to the microsoft.public.excel
so I'm not sure what you mean by the subject line? your's ends in .m which I
don't think is a legal site.
The microsoft Excel newgroup area has many sub-areas dealing with:
Hello All, I need some help with creating a query to sum a total time of a
I have a table called client services and have a query which pulls: date of
service, total time, and provider name. I would like to be able to create a
query which will sum the total time field. I have look at other posts on here
but am still confused. Also not sure what time set to use: minutes or
Thanks for your help,
I assume that you want to total time across clients, do you want to do it
for a specific period, (June 07) or just get the total time?
To get the total ...rpc over http long logon time
How long should it take after Outlook starts before the prompt appears and
asks for the password?
Then afer that, how long before Outlook connects and starts downloading
Ours takes from 30 seconds to a minute for both steps. User are very
confused why they start Outlook and have to enter their password a minute
later, and still can't use Outlook for another minute.
...Are there any significant differences in Excel 2003 from Excel 20.
I have some reference material for Excel 2002 and just wondering if it will
be suitable for Excel 2003. Has anyone seen any significant differnces?
Not really. You can read a review by MVP John Walkenbach
on his website:
>I have some reference material for Excel 2002 and just
wondering if it will
>be suitable for Excel 2003. Has anyone seen any