Can an IF statement be used for 3 options?
Can I setup an IF statement to select between 3 options? For example, I have
3 divisions with 5 teams in each division. Can I setup a formula to have it
enter the proper division if I have the team name entered. For example, if I
have BOS in cell B2 how do I get cell C2 to say AL EAST. I have a tab called
divisions with the divisions listed in cells A1, A2, and A3. The teams from
division A1 are listed in cells A2, A3, A4, A5, and A6. Thanks.
Assuming your division names are in A1:C1 and teams are
in the 5 rows below each division (A2:C6), then try:
=OFFSET(divisions!A1,,MAX(IF(I...How can pass URL for website as imgeurl
Hi Every Body:
I am wondering if there is a way to retrive URL for website and pass it as
imageurl, so when the Image control renderd by the server the image would be
the website that I assigned its URL to imageurl.
any help will be apprecited
"Husam" <Husam@discussions.microsoft.com> wrote in message
> Hi Every Body:
> I am wondering if there is a way to retrive URL for website and pass it as
> imageurl, so when the Image control renderd by the server the image ...Duplicate email messages
I am receiving 2 copies of each email message in WLM downloaded from gmail.
Any suggestions as to how to stop the duplication?
Have you set up the account twice in Tools - Accounts, perhaps one account
is an alias for the same mailbox . . . . .
"Jean" <Jean@discussions.microsoft.com> wrote in message
> I am receiving 2 copies of each email message in WLM downloaded from
> Any suggestions as to how to stop the duplication?
Is your account set up as ...Confirmation Email
I want to be able to send out shipment confirmation emails at the end of the
day, based on a query that populates with the records that meet some
specified criteria. Any record that shows in this query result set will need
to have an email sent to the customer on record. I am having the hardest
time locating some code snipets that I could experiment with. How would I be
able to have it go through each record and send an email? Any help,
guidance, or code would be greatly appreciated. Thanks!
Try something like
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenR...Can't build using DDKBuild on XP
I've got an older version of Microsoft DDK (3790.1830) for Windows
Server 2003. But tried following this link
but get the following error as copied and pasted below here:
Deleting intermediate files and output files for project 'KbFiltrProj
- Win32 Debug'.
--------------------Configuration: KbFiltrProj - Win32
DDKBUILD VERSION 3.15.38 FREEWARE FROM HOLLIS TECHNOLOGY SOLUTIONS
Comments? Suggestions? email@example.com
The system cannot find the batch label specified - NoWI...Exporting email with atachment to text file
I would lke to have a backup of all my email in a pure text form. Many
years ago I used Netscape email, and the entire mail file was pur text;
attachments followed the message and were encoded in base64. I could
always retrieve my email (with a little effort) by cuting and pasting,
and using uuencode to retrieve the binary form of the attachment. Is
there any way to do this in Outlook?
I have recently encountered difficulties with different versions of
Outook at home and work, so would like to avoid problems like this in
the future by having a purely text email file.
<dtshedd@yah...How can I search for and display actual record numbers in Access?
I have a form that has several fields to save data in for achieve
purposes. I also have a search form that pulls that data and displays it,
each in an individual line. It would be ideal to be able to click on a
search result and then on the main form have that record be displayed. I do
not know how to do that, so I was hoping to just be able to display the
record number in the search results so that you can just type it in the main
form and go right to that record number. I am unable to do that either, I
tried several combinations of displaying something like me.currentrecord for ...No longer can connect to Hotmail.......
Outlook 2007 on Vista Ultimate 32 bit........
I have a paid hotmail account that I have been happily using for 2 years
now. I always check it via outlook (2003 and 2007). In 2007, for about the
past 45 days, I would get intermittent dialog boxes asking me to confirm my
I would, and I would select remember this password and things would
continue - until about 3 days ago. Then the dialog boxes would not go away
in Outlook 2007. It constantly asked me for my password and would not
connect to my hotmail account.
I logged in to my hotmail account via the web to make sure I wa...Can not make Messenger video calls
When I try to make a video call, I get the following message:
Messenger is not available right now. Please try again later. (0x8ac70013)
The video feature has worked in the past, the problem appeared after the
forced upgrade to the latest version of Messenger. I am running Windows 7
I don't have McAfee Site Advisor installed
I don't have WMware installed
I opened a case with Microsoft Support (SRX1118889786ID) , sent various logs
as requested, was told well over a month ago that it will be escalated to a
specialist, heard nothing to date.
Any assistance to resolv...Moving Emails to Folders
Though I encountered no problems over many months, in the last several
I have run into a huge issue in moving certain emails from my "in" and
"sent" boxes to my achive folders. These emails all either originate
from China or have a Chinese originated reply in the email string. The
individuals with whom I'm corresponding in China are from major
corporations and, in one case, the person is an employee on my
corporate email system.
The symptoms are as follows. When I try to drag the email to the
folder, the hourglass appears, as if it is trying to complete the
transfer. A...Unable to change email password
Here is my problem, I tried to change my email password by choosing Outlook
login screen "Change Password" button, but received an error message "Your
Windows password could not be changed, Please check the information and try
I have upgraded our Exchange system from 2000 to 2003 SP1 about six months
ago, and never had that problem while at Exchange 2000, here is our setup -
1. Client - Outlook 2002 SP3
2. Server - Exchange 2003 server (Windows 2003 SP1) and Active Directory
server (Still on Windows 2000 SP4).
3. We have Novell servers, so each works...MSWord 2003: how can I adapt US keyboard to UK English?
MSWord 2003: how can I adapt a US keyboard layout to use UK English?
The layout of a keyboard does not prevent you from typing in UK English? Set
Windows Regional settings to UK English and the keyboard to US English and
the keyboard will type what is illustrated on the key caps.
If you have an IBM PS2 keyboard and more money than sense, you could buy a
new set of key caps and replace the US caps with the UK ones.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web ...How can I translate text in many cells of an Excel sheet from English to Greek with VBA
I have a spreadsheet with thousands of rows and columns of text that
I'd like to translate into Greek.
Can anyone tell me how I might do that using VBA with some free
service or API online?
Many thanks in advance.
Kim wrote, on 01st March 2012 00:11 UTC + 1 :
> Hi all,
> I have a spreadsheet with thousands of rows and columns of text that
> I'd like to translate into Greek.
> Can anyone tell me how I might do that using VBA with some free
> service or API online?
> Many thanks in advance.
This is a quite classical...Warn me when other applications try to send email as me
Is there a setting in Outlook2002 that can be disabled
like in Outlook Express? In Outlook Express all you have
to do is disable the check box that states... "Warn me
when other applications try to send email as me" In
Outlook 2002 my custom mass email program stops.
...Can't connect to Exchange server
Hello, I am having a problem configuring an account on
Outlook XP. I can ping the Exchange server, both by IP
address and by host name. When i try to configure the
client to connect to the Exchange server I get an error
saying that it could not locate the server. I have even
uninstalled and reinstalled, repaired, done everything I
could think off but I can not get it going. Obviously
there is something I'm not doing right. Any help would be
Rather then typin in the name of the exchange, can you
connect if you use it's ip address?
This sounds like a w...send and receive wiht VPN connexion
I use Outlook in disconnected mode all the time. I have set up Outlook to
start a VPN connexion automatically.
Then when I press the "send & receive" button here what happen each time.
1- The VPN start automatically.
2- Outlook tries to synchronize while the connexion is done
3- Outlook starts to synchronize when the connexion is establish
4- The VPN close 3 or 5 seconds after the connexion has been established
5- Outlook gives me a send and receives error. (Of course the VPN get close
before the end of the sync)
This was working fine with W2K and Out...Receiving "Unknown" error opening DB tables (Office 2003 SP3)
I am receiving an error opening tables that only says "Unknown" and I
cannot run the create table wizard.
Here is what I have done so far:
1. I have reinstalled Office 2003, and upgraded to SP3.
2. The DB is written in Access 2000 and the default file format has been
set to Access 2000.
3. Forms, Queries, and Reports all work well.
4. I cannot open a table, run it in design view or run the create table
5. I have not been able to install KB829558 for Microsoft Jet Pack 4.0. I
receive an error saying this hotfix is older than the one installed on the
Has an...Can't install Office 2010 beta
I downloaded Office 2010 from Office Online and i tryed to install it, but
not. It won't open. I check in CTRL+ALT+DEL under processes: it's not there.
HOW to install it? :(
Try posting to the Office 2010 beta forums here:
**please reply to the newsgroup so others may benefit**
"confusedguy" <firstname.lastname@example.org> wrote in message
>I downloaded Office 2010 from Office Online and i tr...Email with attached email in shared mailbox
I have a user that is unable to open attached Outlook email message in a
shared mailbox more than once without closing out & reopening Outlook. She
is using Outlook 2003 SP3 (11.8206.8202) under Windows XP SP2.
The user is able to open a message and open any attached email messages
once without any problems. However, if she closes the attached email message
and attempts to reopen it, she immediately receives 'Operation Failed'. If
she copies the message with the attached messages to her main Outlook
mailbox, she can open the attached messages as many times as she wis...Who can make film from PNG files?
Does anyone here maintain a list of graphics people who can generate film
positives from Publisher PNG files for 'precision' silkscreening (tight
tolerance, not for tee shirts)? OR... does anyone have positive (pardon the
pun) experience converting a Publisher file to a PDF for this same purpose?
Heck, do they even make film anymore?
Look for help and links here
Mary Sauer MSFT MVP
"Jim Wood" <JimW...merging worksheet by email
How does one execute merging a worksheet with someone by email? If the
emailer has the exact same headers and emails the worksheet, how can I merge
the list of names and addresses into my sheet alphabetically? Is this
possible to do? TIA
Open both, copy the new data from the emailed worksheet, paste it at
the bottom of your worksheet, then select the entire range and sort
based on the appropriate key(s).
"bb" <email@example.com> wrote in message
> How does one execute merging a worksheet...Send-as an Email alias [SBS2003PremiumR2]
I add an SMTP email address to my SBS mailbox called firstname.lastname@example.org and
they appear in my Inbox. OK.
Now I want to send emails from email@example.com. How do I do that?
Someone suggested I create a mail enabled public folder and then "Send-As"
from the Public Folder. Is that right? Is there a procedure?
Google or Bing (goobing) is your friend:
"how to send as a different user from exchange"
-Please post the resolution to your issue so others may benefit.
-Get Your SBS Health Check at www.sbsbpa.com
> I add an SM...Excel can't do hex
I would like to be able to define a group of cells as (hex, oct, or
bin). The effect would be that when I input numbers, or the cell
displays numbers they would be in the chosen format.
I set up cell A1 as a hex "type" cell. I set up cell B1 as a decimal
"type" cell. In cell B1 I put the simple formula (=A1). Now I enter
"ff" into A1 and "255" pops up in B1.
I understand that there are hex2dec, dec2hex, bin2dec, ...etc
formulas. These, however, aren't much help when you are trying to work
with a different base across the whole spreads...Can't select text in input control
I have created a custom page that works fine within CRM. The strange
thing is that I can't select (highlight) text in a textbox control. I
created the page using an asp:TextBox control and a regular HTML Input
control set to type=text. For some reason I can't select the text using
the keyboard or mouse in either case. The standard CRM pages don't
exhibit this behavior. Does anyone have a clue what's going on?
onselectstart="return false;" Not too smart.
...Can not see a particular sub folder under public
We use exchange 2003 with outlook 2003 client
When I use outlook 2003 client, I can see all public folders except 1 sub
when I login thru OWA, I can see that folder also.
I made sure all the permission are there, and besides I have all
administrative rights in exchnage and AD
Public Folders will read the LOGGED in account for permissions.
Are you logged into the machine with the same entity as the account
that is the owner?
example: My Active directory account called AdminNikki is owner
of all my public folders. But if I log into my machine as