Copy formulas via Code
I have a range with formulas on sheet2 called "database". I want to get this
range and transfer it's contents to sheet1 called "work", but I want the
formulas to update themselves to this new location, and not show the same
exact formula that was found in the original range. I had tried :
with the following results
Cells d1 to d10 on sheet database contain X values, and cells e1 to e10
contain the formula =d1*d1, =d2*d2, and so forth.
Wha...How to fullfil such effect as Visual Source Safe's Edit Box ?
The VSS's password input box can automaticlly switch the IM to accept
english character ,after it get foucs, no matter what the current input
method is (for example,use chinese character input metohd ).
...Either \ or conditions in rules
Is it possible in Outlook 2003 to create a rule with either \ or conditions,
eg If the message has certain words in the subject line OR if there are
certain words in the body of the message? As far as I can see, you can only
create conditions linked with AND.
In that scenario, you would need to create two separate rules, each with =
the same actions.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
...rules based on recipient address
We have one mailbox that has different email addresses that point to it. We
have within this mailbox folders. Depending on what email address mail was
sent to we want rules to move them into the relevent folder. Outlook and/or
Exchange shows the name of the account in the 'to' feild so that our rules do
not work as they are based on where the email was sent. how can we get over
IE main is Internet. Mail sent to firstname.lastname@example.org should go to Internet but
then get moved to the 'WEB' folder based on the email@example.com address. But
Internet is showing in the recpient field.
...Sent Message Rule
I know this is an Outlook ng. but I'm using Outlook Express and can't seem
to create a rule that copies my sent messages to a particular folder. 2
e-mail addresses in one Account. I want to send the sent messages from the
Sent Items folder to another.
The Bear <firstname.lastname@example.org> wrote:
> I know this is an Outlook ng. but I'm using Outlook Express
Then you should ask in an Outlook Express newsgroup.
...Not allowing breakpoints in the code
What setting can you set that will not let you set a breakpoint in the code?
It's supposed to have something to do with Startup.
If the breakpoints are not sticking, you need to decompile.
Try this sequence (in order):
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
I would like to use colors to change an email when
received from 1 of a group of like 60 people. (All 60
senders I would like to color their email when recieved)
I am limited by the number of color rules that I am
allowed to put into place.
I am unable to create one rule for the group of users as
well, as I get an error and outlook closes on me.
There is probably a very simple script that can be
written but I am not that familiar with writing those.
I have tried to assign category through a rule on the
list of these people, but it will not allow me to upload
to the exchange ...matching codes between 2 item codes
Is there someone who can tell me how I can match up (or link) codes
from one spreadsheet to another?
JChan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23273
View this thread: http://www.excelforum.com/showthread.php?threadid=476450
Perhaps the VLookup function is what you are looking for. See Excel help for
"JChan" <JChan.email@example.com> wrote in
message news:JChan.1wxdqa_11...Message Rules
Why don't the message rules work? I keep making messages to block the word
Viagra (any combination of spelling variations) and numerous other words, and
delete the messages. I have over 400 rule, most about Viagra, and NONE of
them are working.
What exactly are you specifying? See http://www.insideoe.com/tips/rules.htm
The rules are the same in WinMail except they added the junk folder.
"Darrell Bartels" <Darrell Bartels@discussions.microsoft.com> wrote in
> Why don't the mes...How do I set up Server Rule to move Emails to a an Exchange 2007 public Folder?
Dear Exchange people,
We are using Exchange 2007 and Outlook 2003 and Outlook 2007. I have
emails that come in every day that need to be moved to an Exchange
public folder based on words in the emails subject. I set up a rule
in Outlook 2003 to move it to the public folder automatically and it
usually works when Outlook is open, but I need it to just run on the
server and not require Outlook to be open to run it. Would anyone be
so kind and friendly as to share with me an example of how to get it
to work on the server and not require the Outlook client to process
Thanks in...Outlook2003: Display rules disappear (Tools/Organize/Colors/Automatic..)
Some help needed re rules created in Tools/Organize/Colors/Automatic..:
Those rules disappear randomly and without obvious reason. Some of them move
to an other folder, where they are useless.
Is there any way to save/restore those rules in order to avoid rekeying
everything again and again?
Where are they located? Are they accessible?
Thanks for your help,
they are stored in views - did you change views on the folder where you lost
The best way to keep them is to copy the current view or make a new view and
set the rules.
Diane Poremsky [MVP - Outlook]
...Emulate Out of Office Assistant in a rule?
I want to be able to emulate the OoO assistant in a server
side rule, specifically I want it to only reply once to
Currently we have several customer service and tech
support mailboxes that have server side reply rules that
reply with a template directing them to our website for
support. However, this rule EASILY gets caught up in loops
to the point where I have to check it daily and turn off
the rule temporarily to break the loop.
I would use the Out of office assistant on the mailboxes,
but the subject text "Out of Office:" seems to be static
which wouldn...Combining IF and COUNTIF based on two columns
Here is what I'm trying to do, I have two colums with data, the first column
will have one of four letters (A, B, C, D) the second column will have one of
two numbers (0, 1). I need to get 6 different counts:
COUNTIF column A range A1:A250 is A
COUNTIF column A is range A1:A250 B
COUNTIF column A is range A1:A250 C
COUNTIF column A is range A1:A250 D
COUNT column A ONLY IF column B range B1:B250 is 0
COUNT column A ONLY IF cloumn B range B1:B250 is 1
I can do the first 4 calculations pretty easy but am having a hard time
figuring out how to do the last two calculations. Can anyone h...Rules in Error
I have a number of rules in place to reduce spam by
permanently deleting certain messages upon their arrival
based on content. But every day the "Rules in Error"
window pops up with the message "You don't have
appropriate permission to perform this operation" and the
applicable rule is deactivated from that point on. This
seems to occur randomly for no particular reason. If I
subsequently run the rule manually, the messages are then
Is there a way to stop this?
...Message Rules Unavailable (2002)
Running Outlook 2002, I don't seem to have the "message rules" installed. I
did select Junk-Mail during custom setup, but no rules option under Tools.
Also when right clicking on a message there is "Junk Email" but it results
in a blank submenu.
I seem to be missing the rules wizard. How can I remedy this?
"Battleax" <firstname.lastname@example.org> wrote in message
> Running Outlook 2002, I don't seem to have the "message rules" installed.
> did select Junk-Mail during custom setup, b...EDIT CODING BEHIND EVENT WITHIN A PROGRAM
within in a vba program I am able to open a form object.
? oform.onopen = "[event procedure]"
My question is how do i find the actual text in the event procedure. Any
suggestions would be greatly appreciated.
I would like to then be able to edit the procedure within a program.
On Sep 17, 10:22 am, "ras" <rap...@bellsouth.net> wrote:
> within in a vba program I am able to open a form object.
> ? oform.onopen = "[event procedure]"
> My question is how do i find the actual text in the event procedure. Any
> suggestions wou...how to delete source file?
An excel spreadsheet links to another excel file. However Iwant to remove
this link completely since the file does not exist anymore. How do I remove
I know that by going into the spread sheet and doing a find ! I get all the
cells that call to this external file.
If I delete them all (and there are lots) will I still get the prompt when
opening the spreadsheet that it can't find this source File?
How shall I best handle this situation? Can I simply remove the source link
somehow? I don't get that option (rather, open source, change source).
Try this, Brad:
ht...Clock Based on Internet
Here's a tough one. Currently I have a commandline in txt that opens the
access db and updates the clock on the computer with the internet. Is there
anyway to simply build this into the access db itself? Can an access db
fundamently change the clock on the pc (assuming no security restrictions).
Thanks in advance.
Assuming the user has the right to change the system's time, the VBA time
function actually lets you change the system time.
Time() = #12:00:00#
will set it to noon.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"dog...Rules, Rules, Rules
I am trying to make a rule that tells people I am out of
office because I don't have an out of office menu (do not
use Exchange). When I select "reply using a specific
template" I run into a problem. I do not have
any "Standard Templates" loaded so I want to create one
under "User Template in File System". But this is looking
for a *.oft file. What is a *.oft file and how do I create
one? Any other way to accomplish making this rule?
Create your out of office message using Outlook's mail editor, not word.
then use file->save as->outlook templ...OL 2007 Rules
I am having some weird problems with the rules in Outlook.They seem to
stop working after awhile. I have to create a new one for them to start
I running Outlook 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)
Anyone else having any issues with rules?
...Copy Local Message Rule
I've created a complicated message rule for filtering that I would like to
put on other client machines. Can I copy it?
Is this possible?
WIn2k server/ Exchange 2k w/all current SPs.
...Great Plains 6 Country Codes
I am trying to extract country codes from a Great Plains 6 SQL backup
select SLSTERCD from RM20101
This gives me a set of good results in 7.5 and they aer nearly ISO
compliant so I can work out where they relate to.
However, in version 6 the results are not even close. They come back
I can;t find a lookup table anywhere which can decipher these results.
Is anyone able to point me in the right direction?
SLSTERCD is the sales territory ID - these are created by users and can be
anything you want, they don't have to...rules wizard #39
Is there a reason I can't cut and paste from and e-mail
into the rules wizard? There is so much spma coming with
creative spelling , accent marks etc. It would be so much
easier to just cut and paste them in the rules wizard.
..."Create Rules" question please
Can I WITH ONE RULE select several people from my addressbook & have their
mail moved to a specific folder when it is received?
Thanks in advance... Bob
"Bob Newmam" <email@example.com> wrote in message
> Outlook 2003
> Can I WITH ONE RULE select several people from my addressbook & have their
> mail moved to a specific folder when it is received?
To a single folder? Yes.
To seperate folders (for instance, to a folder named for the sender)? No.
I guess I should have asked, ho...%date% in Code Template doesn't work
I'm using Code Template's in Visio, but when I Generate the code, it doesn't
give me the %date%-value...
This happend in Visio 2002 and Visio 2003 for Enterprise Erchitects.
Any idea how to get this work?
Any help our hints would be really appreciated!
Thanks a lot in advance,
''' <name>Sub %method_name%</name>
''' %comments%''' </summary>
''' <param name="%params%">%params_and_comments%</param>