How create rule that searches BOTH body and subject (OR not AND)?
When I check the boxes in Advanced Rules for finding a term in the body of a
message and then the subject line, the resulting line ANDs it -- that is the
term has to appear in both the subject and the body.
This is not what I want. I want to screen emails where this term appears in
either the subject line or body. That is, in Boolean terms, I want to OR
this, not AND it.
I think you'd have to create two rules to do that...
"kdez" <email@example.com> wrote in message
> When I check the boxes in...Matching data in different sheets but slight difference in time va
I have two sheets as follows:
Date / Time / Number Dailled / Duration
22/1/10 10:00 01234123456 00:01:57 0.789
Date / Time / Number Dailled / Duration
22/1/10 10:02 01234123456 00:01:56 1501
I am trying to put the cost of the phone call against the relevant extension
on sheet 2 that has dialled the number dialled. Obviously I can match the
number dialled in both cases, and the...current and future chart section in different colours
Hi All Helpers, I have yearly charts set up for totals of
income etc (monthly and cumulative). How can I make the
chart a different colour after the current month?
Preferably also hiding the cumulative lines after the
Jon Peltier has information on creating dynamic charts:
that may help you.
> Hi All Helpers, I have yearly charts set up for totals of
> income etc (monthly and cumulative). How can I make the
> chart a different colour after the current month?
> Preferably also hid...How can I create a Chen ERD in Visio 2007?
I'm trying to do an assignment for my Database Management Systems class that
requires a Chen diagram. Can I do this with Visio 2007?
I don't know if this is a standard or pro version feature. Easy why to tell
would be to go to file > new > and see if Software - Chen ERD is listed.
> I'm trying to do an assignment for my Database Management Systems class that
> requires a Chen diagram. Can I do this with Visio 2007?
This may have been dropped along the line somewhere. I see it back to Visio
Technical 4.1, but I don't see...Create Visio Diagrams in Access
I have been tasked with designing, or at least outputting visio diagrams
form Access 2007, I believe there is a sample database somewhere with info
on how to do this. Please can someone point me to it, or inform me if I am
going down the wrong track and let me know if this is just not feasible.
Basically I need to output Idef0 diagrams.
BTW, I have never worked with Visio before so I am on crash here
Also any help or pointers that you can provide to me will be greatly
Thanks in advance
You can only retroengineer a mdb database through a ODBC datasource.
Just c...Mass Modify-Create Single Account and duplicate within 80 branches
Our account structure is as follows, Acct#-Branch-Region, ?????-????-??. I
have used the Mass Modify feature to copy an entire range of accounts from
one branch to a new branch.
I want to create an account within a single branch and then copy that single
account to the other 79 branches. Is this possible with Mass Modify. I have
already learned it's shortcomings as far as changing an account description
across the 80 branches. I modified the table using SQL for that.
Free Radical, LTD.
There is no way to do what you want with Mass Modify. Integr...Creating and showing a list
I have a phone list divided into many catagories: a=Div#, b=what the
do, c=Contact info. Im trying to create a lookup feature that allow
the user to look up a div#, and show all. Or lookup what they do an
show the contact information. for example. In div2, I have 13 asphal
subcontractors, in the cell "div#", I would like to type "2", the
below that in another cell, I would like to type "asphalt" and th
result would be ALL 13 asphalt subcontractors
comotoman's Profile: http://...View equations created in Word 2007
Operating System: Mac OS X 10.5 (Leopard)
Greetings! I've successfully installed Office 2008 update 12.0.1 on my MacBook Pro running 10.5.2. One of the fixes that was listed in the Microsoft Knowledgebase article associated with the update was the ability to edit equations created in Word 2007 for Windows. After applying the update, I still get a warning message when opening a file created in Word 2007: "This file contains Word 2007 for Windows equations"; the document opens with placeholders (blank squares) instead of the equations. Does anyone el...Outlook 2003 from SBS different from Office 2003?
I have an SBS2003 server installed and distributed the Outlook2003 that came
with it to my clients, while the other office applications still ran the
Last week, we installed the office 2003 suite and I disabled the
installation of Outlook 2003, since it was already installed. Next I
installed the Rights Management Server and the client.
All Office applications now have the Permissions icon, except Outlook. I
have looked through every single setting, but could not find how to enable
This leads me to conclude that the SBS outlook 2003 version might be
different from t...New Essay: ListBox to Clipboard
I have an essay that shows how to copy ListBox contents to the clipboard. It works
correctly in both Unicode and ANSI modes, and illusrtrates several other concepts in the
Joseph M. Newcomer [MVP]
MVP Tips: http://www.flounder.com/mvp_tips.htm
...Hi Bruce Hagen
I have XP Pro and IE7.
Hope you can help me again. Many months ago it was determined that my OE was
corrupt. I remember you instructing me to delete certain folders in OE and
then upon a restart they would be re-installed by the system.
I did that and the problem was solved. Now it seems that my WLM may be
corrupt. I do not see my posts from any NG. Have to go to google groups,
where I can just see some replies, but never my original posts. The some
help that I can see doesn't solve the problem.
Hope you can give me about the same procedures to delete those ...New Records Not In Query
I have a query with a very detailed criteria. I inputted new records
by using forms that meet the criteria of the query. However, they are
not there. Can anyone tell me of some type of refresh that I need to
do in order for the records to show up in the query? The records are
in the main table and the main query. Any input would be appreciated.
Pension Fund Intern
Queries retrieve records from tables (and other queries).
Tables store data.
Forms are used to display (and enter/edit) data.
If you've added records via your forms, those records sh...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....Outlook Email Help: selecting Voting button option from excel VBA
I had a question about sending email from excel. I know we can set certain
properties of outlook from excel such as "Send Receipt" ect.. But can we set
an voting button option from excel?
I am able to send the voting buttons through excel by doing:
..VotingOptions = "Accept;Reject"
But There is an option "Have Replies Sent To" in Voting Buttons section
which I want checked everytime as I want the voting responses sent to the
person who requested the vote AND to one more person. Is there a way to do
this from excel?
To select "Hav...button to navigate to a different page?
I have a long document with multiple sections. Is it possible to create a
navigation buttons at the top of the page and clicking on one the buttons
would take me to that section, something similar to A HREF in HTML?
If you bookmarks the location that you want to move to, you can insert
hyperlinks to the bookmarks.
Or maybe you will find a table of contents useful (it will be hyperlinked by
Microsoft Word MVP
"Liu" <Liu@discussions.microsoft.com> wrote in message
news:ADB88D9B-F03C-49DA-A13A-3EB035B76122@microsoft....Change the file name in Macro
I created Macro that open several workbooks (actually 17 of them) at
the same time like this;
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\01 - Feb09 CFW.xls"
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\11 - Feb09 CFW.xls"
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\21 - Feb09 CFW.xls"
It works fine till I have to use it for the following month. I have to
go back to my Macro and change manually the directory from 02-09 to
03-09 and file name from Feb09 to Mar0...Big Help Needed Excel '95
A friend has a simple spreadsheet with 6 tabs along the bottom. Win 95 and
Office 95 installed.
One of the Tabbed sheets had a HUGE list of items and he "hit some key" and
wiped out the data in the sheet. Doesn't know what he did and worse still
saved the file and exited. Has no back-up! He can't duplicate what he did
or even know what he did.
I appreciate the data is probably lost, but my query is that the sheet, when
you click the Tab shows no cell lines at all, no data obviously, but no
cells at all? There are line numbers down the left side that you can click...Can I add to a drop down list like a new status that is not shown.
I am using Time and Billing form. I would like to be able to add to the drop
down status menu which already gives me some options but I need some to cover
warranties. How can I add an item to the drop down menu? I am new to this.
By drop down, do you mean a combo box?
If so, what is the row source type property of the combo?
What is the row source property of the combo?
The above questions need to be answered in able to answer your question.
Dave Hargis, Microsoft Access MVP
"Learning the ropes" wrote:
> I am using Time and Billing form. I would like to be ...Passing Names to Macro's
How can I have a macro recognize a named range? E.g. ADDON=5 is defined
and named in a cell, and I want to reference it in the macro.
Dim sRangeName As String
sRangeName = ThisWorkbook.Names("ADDON").Value
MsgBox "ADDON Value" & sRangeName
Microsoft MVP - Excel
"Randy Numbers" <firstname.lastname@example.org> wrote in message
> How can I have a macro recognize a named range? E.g. ...GPv10 How to Create New PO from Sales Order
Hi, In SOP, on a line being ordered, I click on the Paper Clip icon
and a screen pops up allowing me to lookup an existing PO to assign
this item. A few questions.
1) are the POs listed when I select the lookup only vendors that we
purchase this specific item from or does the lookup select any new
PO? If any PO that could cause issues since someone may assign this
item to a vendor that doesn't sell that item.
2) What if I wanted to create a New PO so I know I'm ordering from the
correct vendor? Is this possible? Is this a setup option, cause I
don't see where to create a new ...Font size when composing new message.....
I changed my font options in the Tools Menu and it does not seem to help.
When I am composing a new message, my font and signature , which includes a
business card, is huge!!!!
And also when I pick a theme for stationary that i had put on there, it is
huge too! You can't see it all!
What is going on, anybody?
Thanks for any help!!
I'm betting that it is your zoom settings in the email.
For Outlook 2007, with the email open, click on the Format Text tab - Zoom
and change the setting.
For Outlook 2003 and older, with the email open, click on View - Zoo...Create a task based on Contract Expiration Date
Is there a way to create and assign a task in CRM for a given time
period before a contract expiration date come due? I would like to
have reps notified and proactivly contact customers weeks before
...I need help with mfc doc/view
i'm a newbie to vc++ mfc and stuff ... and am working on a project of developing an IDE for a TCL script file which contains a statements that indicate the state flow of the application script. simply put this script can be diagramatically represented as a kind of STATE FLOW DIAGRAM.
So .. i started with an SDI application that will enable a user to draw the state flow and save the diagramatic document. Now the IDE should essentially enable the user to create the script file from the diagram and vice versa. Therefore i need a text file kinda document support also for my SDI application. ...How? Default is current date, but user can edit if needed?
I want Start Date field to default to the current date, but allow the user to
change it if needed. Start Date field has a format of Short Date with a mask
__/__/__. The boss wants the field to default to the current date to
eliminate keystrokes for the user.
Scenario: User forgot to input data yesterday that must reflect yesterday's
How can the field be formatted to allow the user to change the Start Date
field if the field defaults to current date?
When a field has a default value, it can be changed as you want.
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele...New Vista Update: KB 980248
Today, Thursday, I got a notice for an "important" update for Vista: KB
980248. Apparently it deals with fonts and Office 2010, and is 29 MB in
size. Is this "important" update really necessary if I'll never use Office
2010 or would it tie in to other Vista core applications where it will be
needed? The last thing we need is a large useless update, if that's what
this really is.