Macro to Clear Cell Contents based on Cell Value in another Sheet
Sorry for the Newbie question but.......
How do I create a macro to clear the contents of cells in one worksheet
based on the value of a cell in another worksheet?
For example: on SHEET 1 the value of cell A1 can be Yes or No. If A1 =
"Yes" then I want to clear the values in cell range A1:C5 of SHEET 2,
if "No" then don't clear the values.
Thanks in advance.
dim rng1 as range
dim rng2 as range
set rng1 = worksheets("sheet1").range("a1")
set rng2 = worksheets("sheet2").range("a1:c5")
...re-downloading mail on Outlook 2003
I just upgraded from Office 97 to Office 2003. Using
Outlook 97, my wife and I were able to use different
computers but share one email account. The same mail was
downloaded to each PC one time. Now, the same mail gets
downloaded over and over again on each PC. I obviously
can choose to delete the mail from the server so that it
only gets read once, but then the second PC will never
see it. How can I get the same behavior from Outlook
2003 that I used to have? Reading 500 messages every 10
minutes makes the upgrade really unusable.
Try creating a new mail profile on each comput...How do you a mail message to everyone in your mail database
How do you sending a mail message to everyone is your mail database?
I have switched internet dial-up links and need to send a message to
You can select all items in your Contacts folder (assuming they all have
valid e-mail addresses -- if not, set a filter first so that only those with
valid e-mail addresses are showing) and then click Actions | New message to
contact. Of course, if you have a lot of contacts, your ISP may balk at
sending to so many at once -- if so, you'll have to break up the list
MVP -...OL2003 unable to send mail
In OL2003 when I try to send email I get;
'Your message did not reach some or all of the intended recipients. The
following recipient(s) could not be reached: ....
None of your email accounts could send to this recipient.'
The pc is connected to the internet via a router. Other pcs connected to the
router can send mail fine. What is the problem and how can I fix it?
Do you require authentication to send email?
check with your provider.
"John" <John@nospam.infovis.co.uk> wrote in message
...Safe sendershould not go to junk mail
I have an web application sends email, I found outlook 2003 puts the emails
to the junk mail folder if multiple emails were sent within a short period
of time, about 1 minute. The initial one was ok went to inbox, while the
followings went to junk mail. but if the gap between multiple emails sent
time was longer, the problem went away. (each one went to inbox).
This only happened for outlook 2003, not for outlook xp.
The sender address is in the global address list, with the same domain with
all my users. (so I think it qualified as safe sender.)
How can I turn off this filt...multiple e-mails
Usin' Outlook or Outlook Express, for some reason I keep
gettin' repeat emails. Somebody can send me one and I get
the same message two or three times! What can I do, if
anything, to cure this problem? Anybody had the same
problem? Please don't tell me I'm the only one that has
had this problem...
...roadwarrior + principal + multigig e-mail + psts = ???
here's the deal. we have a principal who travels all the time. she gets
an insane amount of legit e-mail with small to large attachments (we
cap it at 15 MB, 5 MB is fairly common). her mailbox is capped at 700
MB. this is not enough. we have to archive for her every other month.
she has almost 2GBs of PST archives on the network. she wants to have
access to them all the time.
so we have set up offline files to sync the pst folder. ick. sometimes
she'll actually edit the psts on the road and when she gets back she's
asked to choose between the network version and her loca...Outlook 2003 blocks attachments
I installed Outlook 2003 on my wifes laptop, it was an
upgrade from Outlook 2000. Whenever she tries sending a
url she gets a message saying Outlook blocked the
I have gone into the automatic picture download settings
and unchecked the don't download pictures or other
content automatically in html email. Its like html isn't
being used or my settings are ignored.
Does anyone have any ideas? I downloaded the latest
On occasion I get the same errors. Mainly when someone sends the URL as an
attachment. If they send the URL in the body of the email, th...mails are not going out side of my domain
i have an exchange 2003 (sp1) with windows server 2003(sp1) i have an smtp
filter for exchange which filters the mails coming in my exchange server ,
the scenario is like that , first i have an router then pix firewall and then
smtp filter then my exchange comes ,he domain controller and exchnage are on
same machine. today i am getting a problem is that the mails from hotmail and
yahoo are coming to my exchange but the mails from my exchange are not going
outside ,the error i am getting is given below.
"Your message with Subject: hi test mail
could not be delivered to the fo...e-mail #17
Microsoft Outlook does not respond to making it my
default for e-mail. I have checked all that I know how
to. It is checked as my default under "Other" Tab but it
continues to send my e-mail to Outlook Express. Why? What
am I doing wrong?
Orville Cruea <email@example.com> wrote:
> Microsoft Outlook does not respond to making it my
> default for e-mail. I have checked all that I know how
> to. It is checked as my default under "Other" Tab but it
> continues to send my e-mail to Outlook Express. Why? What
> am I doing wrong?
What you are doi...Hoes does table of contents work?
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi there, <br><br>I am generating the table of contents and there are some headers that are appearing in the TOC that I dont want to be there. What is the best way to get certain headers to never added to the TOC in the first place. Is the best Method to change the style to a non-Header name? <br><br>Or is there some other trick? <br><br>Cheers, <br><br>Noah
First let's clarify some terminology :-) It would seem that you're referring
to HeadINGs as opp...Counts for Mail Folders #2
I'd like to have the total number of messages in all the folders and
subfolders of my mailbox to appear on the status bar.
I don't think that's possible
"Steve" <Steve@discussions.microsoft.com> wrote in message
> I'd like to have the total number of messages in all the folders and
> subfolders of my mailbox to appear on the status bar.
...Importing old MS Mail folders
I need to import the shared folders and global address book from an old MS
Mail postoffice. I have seen some discussions concerning migrating
mailboxes but very little at that. Can anyone point me in the right
Outlook 2002 in Office XP
When sending, the mail does not leave the outbox and sends
over and over again, never making it to the sent items
folder. The recipients are getting it multiple times.
How to fix?
...Unable to send e-mails, but can receive e-mail.
I have re-installed Windows Outlook 2000 but now I can not
receive e-mails. My network configuration is correct. My
IP address and server are correctly labeled, but I still
can not receive e-mail. Everyone on the server are not
having any problems. What should I do?
Hi - which is it you're having a problem with? Your subject line & message
content are contradictory...
Are you connecting to an Exchange server? What kind of mail account are you
having problems with? What errors do you get?
> I have re-installed Windows Outlook 2000 but now I can not
> receive...Mail receiveing but not sending
Since setting up my mail to use SMTP instead of pop3 I can
recieve mail fine but when I send mail it goes but doesn't
turn up at the other end!
I used the ICW in sbs 2003 to configure it.
I've checked the queues on the exchange server but there
My exchange Small Business SMTP connector Properties are
set to forward all mail through a smart host. currently
Not sure why this is happening!
Any help would be appreciated!
Any help from SBS newsgroup?
> Since setting up my mail to use SMTP instead of pop3 I can
> recie...Addins attached only to selected workbook(s)??
Using Excel 2003 I have written a set of macros that is used with workbooks
with a lot of hand entered data. Right now the macros need frequent
updates as more features are added. To facilitate providing updates, I
felt it was necessary to separate the code from the data so that the user
didn't have to do anything when the code was upgraded.
To accomplish this, I created an addin containing the macros. Now I just
email the new addin and users are good to go. The problem is that the
addin is automatically attached to every workbook I open and there are a
number of reasons that ...Incoming mail server changes to "localhost" after windows is restarting
this is the problem i am facing...can anyone help me
"Incoming mail server changes to "localhost" after
windows is restarting"
pls reply in firstname.lastname@example.org"
Thanks & Regards
The most likely reason is that you have an antivirus solution installed that
can scan e-mail as it is downloaded. You would need to disable the scanning
of e-mail to get what you describe to stop.
"email@example.com" <firstname.lastname@example.org> wrote in
> this is ...Replicate mail boxes?
is it possable to replicate mail boxes? I would like to do this while we
migrate fully over to our new server?
What are you trying to accomplish?
replicate Stores? At byte and block levels using 3rd party products like
NSI, or from storage vendors like NetApp (SnapMirror) and EMC. Exchange 12
is reported to have log shipping.
"Josh" <Jsawyer@insightbb.com> wrote in message
> is it possable to replicate mail...change mail format for contacts
For the iphone, attachments come over as winmail.dat and the solution is to
change the mail format in options, mail format to HTML.
Also the individual contacts needs to be changed by double clicking the
email address and changing the internet format to Send Plain Text only.
After these changes are made, the attachments come over fine. I have had
problems with this issue with some contact before. I would love to be able to
make this change globally instead of having to edit all contacts. Can this be
It can be done with some VBA code, which you'll find here:
ht...Mailing in a test enviornment
I have a CRM ans SQL server configure on a single machine and the Domain
controleer along with exchange Server on a seperate machine.
Till some time back Mails could be sent via CRM and they could be seen in
the history tab.
Suddenly when i try to send mails vai CRM, it gives me the following error:
for more information contact your system administrator.
I have checked all the necessary services required for the excahnge
The exchange router has been reinstalled as well.
Still cannot figure out why I am getting this error.
Thank for your help in advance
Jus...delete blocked senders messages on receipt why junk mail them?
Why is it that after going to all the trouble of putting people onto a
blocked senders list the filter still puts their messages into the junk mail
folder for you to delete them?
Or am I understanding the training wrong?
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 then
click "I Agree" in the message pane....OE 6.0 "Unsafe attachments" #2
Recently began receiving msg
"oe removed access to the following unsafe attachments in
your mail: xxx.jpg, yyy,jpg, etc."
What's causing this? I am comfortable with these
attachments and want to access them. How do I turn off
this function, and how do I access attachments removed by
Happening on both Win 98 and XP
Here is a link to an article that explains why this is happening and how to
disable this feature in Outlook Express,
I hope this information is helpful.
Partne...Please Consult Before Posting: Unofficial FAQ Available #57
An unofficial FAQ for this newsgroup is available at http://umpmfaq.info.
The source FAQ was last updated Friday, February 25, 2005. You may save
yourself and those willing to spend their time helping you both time and
hassle by consulting this resource before posting what may already be a FAQ.
The unofficial FAQ answers 162 of the most frequently asked questions in
this newsgroup. Note that only a limited number of FAQ items have been added
or modified for Money 2005--those that are derive from my limited experience
with the product and on very high profile items in the newsgroup. If you are
...cannot receive mail, delete mail, or send mail. get an error message.
Now I know why I switch between Outlook Express and
Outlook: Both cease to function at one point in time. In
Outlook 2000, I cannot receive mail; I cannot delete mail;
I cannot use the calendar function. Here are the messages:
When I click receive mail, I get:
could not be accessed.access denied.
I cannot delete. I get the following
..pst could not be accessed...