Can I send a recurring e-mail automatically each weekI want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Thank-you
Happy new Year!!
Carl R
...
Lookup based on criteria in 2 columnsHi,
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
luck.
Thanks,
=SUMPRODUCT(--(A2:A50=102),--(B2:B50=DATE(2008,9,15)),C2:C50)
--
Regards,
Peo Sjo...
"The connection to the Exchange server is unavailable. Outlook must be online or connected to complete this action"I have setup a number of user accounts and the relative mailboxes without
any problem.
However, since this afternoon, if I try and connect to a newly mailbox
through the email accounts wizard I get the following error message: "The
connection to the Exchange server is unavailable. Outlook must be online or
connected to complete this action".
This also occurs when I go to File>Open>Other User's Folder... and I try and
lookup an existing account/mailbox that I know I have permission to.
I know Outlook is connected to the Exchange server (I can ping, send and
receive emails) ...
Microsoft POS #2I have a group of customers that I am working on setting up A bundled POS
system for.
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...
Outlook 2003 keeps crashing #2I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
Best regards/
Bj=F6rn
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...
Exchange 2003 new install can not receive external email.I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
server.
The reasons given by the server are included to help you determine
why
each recipient was rejected.
Recipient: <**...
Rollup 2 and Office 2007I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
compatibility?
yes
--
Regards,
MS CRM Certified Professional
http://microsoftcrm3.blogspot.com
Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com
"LLoyd" wrote:
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
> compatibility?
...
How to restore entire server?This is a long post.
Its that time of year again where I practise some disaster recovery skills.
I set up a completely seperate physical network from the production network.
Its got one Win2000 server (DC + all the Operations Master roles, DNS, WINS,
etc) with SP4 (different AD/DNS root forest) and running Exchange 2000
with SP3 (same org name as production server, admin group, storage group,
logical and physical database names, legacyexchangeDN, etc). As a result, I
can successfully restore our production Exchange 2000 w/SP3 Storage
Group/Information Store database without problems. Outlook...
can't customize toolbarVersion: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
all i see is document elements, quick tables, charts and smartart graphics. i do not see the main menu or the toolbar button. when i attempt to customize the toolbar, the to menu bar and format bar do not appear where they should. on a website i visited, they advised that i drag and drop the temporary toolbar into the real toolbar. but i can't drag and drop the toolbar. i can only move the temporary toolbar. how do i add the menu bar and format bar for go?
You may have hidden the toolbar by accident. Click on the ti...
How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...
"Save" preferences getting lostList members:
I work on long documents and want to save my work frequently.
Every time I set the "Save" preference to a brief interval like
five or ten minutes, the preferences seemingly resets itself to a
default of thirty minutes.
I'm using Word 2008 for the Mac on an Intel running 10.6.2.
Thanks in advance for any thoughts.
- Mark Pavlick
Hi Mark:
That indicates that your user ID does not have permission to write to the
preference file that Word is using, or that something is replacing the
preference file.
With the help of your System...
Install Exchange 2003 Server on new Hardware with same nameI got a new server to move my Exchange Server Installation. I want to
keep the name I'm using now for my Server. Already read TechNet Article
"How to Move Exchange Server 2003 to New Hardware and Keep the Same
Server Name". Is there anything else that I should be aware of that is
not on this TechNet article? I'm using a different Disk Configuration,
does this matters? Should this be a smooth process?
Thanks for any help you can give.
The drive letters MUST match, because the paths of the databases are at the
Active Directory. The disks can have different sizes than the or...
Mails not appearing in Inbox although on Server and viewable by colleagueHi all,
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
them.
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...
Can you only merge up to a certain number of cellsI am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...
matching contents #2E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
B E
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
7 7
8 8
9 9
10 10
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
B E
1 1 1
2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 7
8 8
9 9
10 10 10
Besides dr...
saving and distributing a customized desktopIf there a way to customize one desktop and then copy the file to the other
workstations so that they are set up the same way?
I get calls all day from our users asking that I customizes their outlook to
include some of the modifications I've made to my desk.
We have Exchange Server and Outlook 2003 SP2.
"Herb Segal" <herb@endlar.com> wrote in message
news:Olsb5oBpKHA.5508@TK2MSFTNGP02.phx.gbl...
> If there a way to customize one desktop and then copy the file to the other
> workstations so that they are set up the same way?
>
> I get c...
Can I make messages unable to be forwarded by the receiver?We are interested in setting up a private email group at work that receives
semi-confidential information.
Is there a way to make the emails that these users will receive unable to be
forwarded to people outside of the group? Make private, or somehow else
prevent the information from getting outside of the approved recipient list?
no. and you can't keep people from printing it, copying and pasting the
contents of it, taking a screen shot of it, etc, etc...
"Jonna Kosalko" wrote:
> We are interested in setting up a private email group at work that receives
...
Can anyone help ?I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...
Please ignore #2Testing a posting problem
--
Jim Bunton
...
2 register ruinning together on one z reportIs this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
though.
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.c...
[b]Can I download Excel data to a MS Access database?[/b]I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
database).
Is this possible or even feasible? Any and all help is appreciated.
Thanks.
:D
---------
Message sent via www.excelforums.com
Hi
in Access check 'File - Import External data'
--
Regards
Frank Kabel
Frankfurt, Germany
"...
reason codes #2I'm having a big problem tracking discounts in RMS. Whenever something is
discounted up front, a reason code is set. There are several I use for
discounts.
However, when I try to do an Item Movement History report and select based
on those reason codes, I never get any matches. When I do an item history
report for a few weeks, I notice that the only reason codes that are
displayed are the ones pertaining to inventory adjustment. It seems that
reason codes associated with discounts do not display in this report.
HELP! I need these to display to track discounts (and also store use)!
...
Why can't I edit the Schema for a Knowledge Base Article in CRM 3.Why can't I edit the Schema for a Knowledge Base Article? It seems to me
that you could do this in 1.2. I just want to add some custom fields.
...
How can I set an alarm Excel?I would like to set an audible alarm in Excel based on a cell value.
Try this in the worksheet VBA editor. If the value of A5 is greater than 50
you get a beep.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim frequency As Long
Dim duration As Long
If Target <> Range("A5") Then Exit Sub
If Target.Value > 50 Then
frequency = 4160
duration = 1500
Call Beep(frequency, duration)
End If
End Sub
HTH
Regards,
Howard
"Annell" <Annell@discussions.microsoft.com> wrote in message
news:EFE8AA18-3F14-4A92-941D-053922417AB2@mic...
Server-Requested Client Action MoveCopy, Unable to create dest msg.Help. This error message displays when my user opens
Outlook 2002. The only fix I can find is to update my
exchange server.. which is already up to date. Any
suggestions?
...