auto-update cells with this week/last week's totals?
I have 3 cells - C2, D2 & E2.
C2 contains the formula =SUM(C1528:C1534).
D2 contains the formula =SUM(D1528:D1534).
E2 contains the formul
C2 shows the total number of miles I have run from Monday of th
current week to Sunday inclusive.
D2 shows the total hours I have run over the same period of time.
E2 shows the average pace I've run at, again over the same period o
time. (I added the ISERROR function for neatness as I had to kee
amending the column width when I get the DIV0 error).
C3, ...Can Recieve email but cannot send out
For Outlook 2003, cannot send out. Have internet
connection, and can receive emails. I have tried
disabling firewall and Norton, but no luck. Any
are you getting any kind of error back?
"Mark Sanford" <email@example.com> wrote in message
> For Outlook 2003, cannot send out. Have internet
> connection, and can receive emails. I have tried
> disabling firewall and Norton, but no luck. Any
"Mark Sanford" <firstname.lastname@example.org> wrote in me...outlook email questionaire
I want to send an email to clients that has a questionaire on it with text
answers. I want them to be able to answer the questions and then click a
button at the bottom of the page that will send it directly to my email
without them having to enter my address. How do I do this?
Well, i's possible to do what you want (mail a form to someone that's
editable on the receiving end and runs code to send mail when done) but is
Check out www. outlookcode.com for some ideas on how to approach this. If
you are not using an exchange server, I'd recommend using Form Regions...Email
I have created a simple Access database that our HR department will use to
input demographic information on a new employee, as well as what software,
access, etc. a new employee will need. Again, it is VERY simple, but what I
can't figure out is how to create a button that the HR staff can click on and
the file, with all the information, is emailed to our IS department. Can this
You can setup a report to based on your current record and email it using
SendObject or using Outlook automation. This does require a minimal amount
of VBA programming in either case. If you sear...Can't forward to an external email address...
We have a user that uses his external AOL account as well as his company
email account. He has asked me to forward all company mail to his external
AOL account. I figured I'd be able to just go into the delivery options on
the "Exchange General" tab for his user profile and forward to the
appropriate address. However, you cannot enter just any address in there, it
forces you to select an address from the directory - of course his AOL
address is not there. Is there an easy way to forward all mail from his
internal account to an external account?
I tried creating a rule on his Out...windows can't check for updates
i had windows automatic downlad ,but the last 2 weeks i get a message saying
it can't downlad updates and when i do it manually i get this code
...80072EFD.how can this be corrected .i have not changes any setting in my
firewall as it saids when i chek on the erroe.
Always state your full Windows version (e.g., WinXP SP3; Vista SP1; Vista
64-bit SP2; Win7; Win7 64-bit) when posting in a forum or newsgroup. Please
do so in your next reply.
What anti-virus application or security suite is installed and is your
subscription current? What anti-spyware applications (other than...HELP: Lost all my old emails
First there was the power failure. Then there was Windows XP recovery
program (that ran automatically). Now, my desktop is blown away and all my
Outlook emails and contacts are gone.
Could these files be lurking in some obscure directory? Don't say search
for dbx files. My computer doesn't have any. I'm running Windows XP
Regards and thanks.
do a search for pst files. or you can try .pab files for
your personal address book. If those arent there.. You
might be screwed! I save my pst files on my server where
they are backed up.. for just this re...email addresses in memory
An outlook 2003 user states that when sending out an email and when they
type in a letter in the "to" area the email addresses that were in memory
when you type a letter or name are gone. They said they didn't do anything
different. The addresses are in the contact list but there is nothing in
memory so you have to type the whole address in. Is this possible or can
address in memory be deleted or removed?
They are stored in the *.nk2 file located in Docs&Settings\Application
Data\Microsoft\Outlook (by default)
You dont have to type the address in, just click the &...Office 12.2.4 update
Operating System: Mac OS X 10.5 (Leopard)
I downloaded the 12.2.4 update and attempted to install. I recieved an error message that I needed to turn off "Miscorsoft sync services" in order to finish the install. I can't figure out how to do that. I had to force quite the installer. What do I do?
On 3/12/10 8:20 PM, email@example.com wrote:
> I downloaded the 12.2.4 update and attempted to install. I recieved an
> error message that I needed to turn off "Miscorsoft sync services" in
> order to finish t...Exchange 2003 mailbox permissions being reset
I have seen many posts on this same problem with no real answer,
hopefully somebody out there has found a solution. I add "send as"
rights to a mailbox for a user other than the owner of the mailbox (or
full access, make no difference) and it works fine for a short while,
then when less than an hour goes by (not sure exactly how long), the
user that was added in the permissions tab is missing and obviously the
send as ability is gone. I have tried adding the user on the Security
tab, then also hitting the advanced button and adding it there (per ms
kB#327000). The user that I'...Unlinking tracked emails in CRM 3.0
I find that once an email is linked to/tracked by CRM (Customer, Client,
Activity) it can't be unlinked! only deleted.
For example; A client uses an old CRM generated email containing the
tracking token to ask about a new problem. CRM automatically tracks the new
email to the old CRM case and I can't untrack it to link it to a new case.
Any information would be helpful...
Check out "How to "untrack" Microsoft CRM Outlook e-mails" on following blog
PLEASE do click on Yes or No button if this post was helpful or not for ou...Korean email
I can type and send Korean characters in emails but cannot
receive them in Outlook 2003. Any help?
...outlook express outgoing email disappears
I use Windows98 SE and Outlook Express6. Sometimes and
with different addressees when I send an email it is
received by the addressee ok but it is not in my sent
items folder so I have no record of it! It does not happen
every time -- perhaps about 1 in 6. I'M probably
overlooking the obvious. Suggestions welcome.
i suggest the outlook express newsgroup
"Sean Dunne" <firstname.lastname@example.org> wrote in message
> I use Windows98 SE and Outlook Express6. Sometimes and
> with different addressees when I send an email it...Instant search of emails (10,000) fails
Failure of instant search requires reboot befor resolving for search or two
and again fails
...Multiple Tables updated from one form
I may be going about this the wrong way, but I have 4 tables:
Customer; Farm; Field; Main.
1. I have a form that I want to be able to enter a customer name, farm name,
and field name into and after clicking an "Add" button, I want the associated
values (i.e. IDs) to be entered into the main table. If the Customer Name is
not in the Customer Table I want it automatically added. The same with Farm
and Field. (The IDs are auto numbered) My combo box on my form is tied to
each respective table and also to the combo box before to filter down the
2. I also want...How do I Full screen an Email???
I looking for a way to look at an email that I receive in
a full screen mode. The way I'm trying to see it is like
I was in I.E. and pressed the f11 key or if I was in
Word or Excel & used the Alt+V+U function for full
screen. What I am trying to see just the heart of the
email not the header or anything else but the email body
Craig <email@example.com> wrote:
> I looking for a way to look at an email that I receive in
> a full screen mode. The way I'm trying to see it is like
> I was in I.E. and pressed the f11 key or if I was in
> Word or Excel & us...Emails not leaving outbox
Hi all -
I am having what seems to be a common problem, but all of the suggested
fixes I found did not work. I have set up SQLServer to use MAPI to email
notifications. I have Outlook 2000 installed and configured and working. The
SQLServer notifications part isworking too. The only thing I can't figure
out is the emails never leave the outbox until I start Outlook and click
Send/Receive. Then they are all sent fine.
I read some articles mentioning MAPISP32, which appears to be the culprit.
From what I see it's supposed to spool emails that are in the Outlook
outbox. I found after I ...Missing text in email
I recently installed Exchange 2003. From time to time when
my users send email outside the company there messages are
missing text upon arrival. The text missing could be two
sentences at the end of a paragraph and the next one
starts okay, or it could be a very words missing here and
Any ideas of this
I know you have probably thought about this already, but do you have any
type of content inspection system installed on your Exchange server? Or
anything installed that stamps a message disclaimer on the message.
Is the message changed by the clien...email forwarding to my other email
I have two email accounts. One I use for work and the other for personal.
For some reason, my personal email is being forwarded to my work email. I
don't know why and how do I stop it....?
Are these POP3 accounts?
Has it ever worked?
Are they separate accounts, or addresses that are aliases for the same
Does your personal e-mail show in both places, or is it going to your work
Any rules set up in WinMail, or on the server's Website?
Imperial Beach, CA
"az otr" <az otr@disc...question about grouping the emails.
I am signed-up to a discussion group and i get question about a prob and
also solutions as a reply.
i am grouping the e-mails by subject,
subject: "problem with ABCDE"
in reply the subject will be "RE: problem with ABCDE"
now Outlook2003 is grouping these two into seperate groups
and if there is a reply with subject "RE:RE: problem with ABCDE"
it groups that seperately.
i want to group the replies also into the same group.
the reply to the emails are grouped seperately. i want to have an exception
in the grouping saying to ignore the word...Outlook Client
In the web client there is an email icon available from the views which
allows you to send a direct email to the selected records in the view.
Does anyone know if there is any way to call this from the Outlook
Appreciate it :)
I'm afraid I can't help you out on this one. But I found that it's not only
the icon missing in the Outlook client, but as soon as the Outlook client is
active, the icon disappears in the Webclient also.
This seems the same issue to me as the settings button disappearing when the
Outlook client is active, wh...Macro UPDATE..
How I can use the Compact and Repair without access? Well let me ttry
explaine better: I want Compact and Repair Automatic every night an
http://support.microsoft.com/kb/295334 (I'm not sure there's a version
that's compatible with the Access 2007 accdb format)
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Milton" <firstname.lastname@example.org> wrote in message
> How I can use the Compact and Repair without access? Well let me ttry
> expl...Not receiving emails
I have not checked my emails for 1 week. Now when I try
to log in it ask for a user name and password. When I
enter them it states Your servers has unexpectedly
terminated the connections 0x800CCC0F????????????????
I can send messages but can't receive HELP ANYONE.
Pam C wrote:
> I have not checked my emails for 1 week. Now when I try
> to log in it ask for a user name and password. When I
> enter them it states Your servers has unexpectedly
> terminated the connections 0x800CCC0F????????????????
> I can send messages but can't receive HELP ANYONE.
This is an is...Hyperlinks blocked within email messages
Suddenly I can't open any links from within received messages. I receive
the following error message:
"This operation has been cancelled due to restrictions in effect on this
computer. Please contact your system administrator."
"System administrator" would be me. This is a standalone computer connected
via a Linksys router to a cable modem. There's no domain involved and there
are two Users (both administrators) set up, only one of which has the
problem. I'm using Outlook 2007 under Vista Ultimate and this has only
started happening in the last week...Purging Junk Email
Hi. The problem is that for the most part, my users don't purge their
junk on their own and it just keeps builing up and it is stating to
take up way too much space on my exchange server. I need to know if
there is a way of automatically purging my users' Junk E-mail Folders
every week on the server side (Excahnge) as oppsed to the client side
Yes, use Mailbox Manager its a very nice tool to keep your Exchange
Mailboxes clean. See
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner