Advanced find to select Accounts with "interested" campaign responses.
Hopefully someone may be able to help with this query.
I need to be able to run an advanced find query that returns every
account who has a campaign response for a particular campaign, where
the response code is "interested".
I've tried several approaches to this, and whilst I can return all
accounts that are on a particular marketing list, where is has been
applied to a particular campaign, I can't get it to work to only
include accounts with an "interested" campaign response logged against
I've tried things based around the following
...How do I find a document in Word 2007?
I realize that I can search for a document using Windows, but is there a way
in Word 2007 for me to search for a certain document, or a word within a
In Word 2007, there is no longer a specific user interface for searching
from within Word.
However, to search a folder in, say, the Open dialog box, you can
right-click its icon and choose Search from the context menu.
Microsoft Word MVP
"jldube" <firstname.lastname@example.org> wrote in message
>I r...Excel is changing the last digit to 0
I am trying to enter some numbers into an excel spreadsheet and the program
keeps changing my last digit to 0. These are 16 digit numbers. Is there any
way to fix this? What is going on?
Excel is limited to 15-digit precision. To enter longer numbers,
precede the number with an apostrophe.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Heather Lisco" <HeatherLisco@discussions.microsoft.com> wrote in
>I am trying to enter some numbers into an e...Finding Outlook on Another Drive
My computer had a system crash so I hooked my hard drive
up on my girlfriends computer... I need to open MY
Outlook for important dates and email... How do I get to
it? I can open my girlfriends Outlook because that's now
on her desktop and the master hard drive... I need to
open my Outlook from my drive or import the data... I
know how to import export but I can't get to it to export
data to a file so I can import it on her drive... I hope
someone knows what I'm talking about... I need this in
the next two days and I don't have time to fix or buy
another computer rig...finding a blank sheet
Does anybody have an idea of the best way to look in a workbook an
delete any sheet that is completely blank? Therefore only keepin
worksheets that have data in them.
Thanks for your help,
Message posted from http://www.ExcelForum.com
I don't profess to have written this but have found the folowing cod
which would appear to do what you want
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
If Application.WorksheetFunction.CountA(sh.Cells) = 0 Then
Application.DisplayAlerts = False
Application.DisplayAlerts = True
...What happened to the find file command?
On Microsoft Word 2003, I could use the find file command to find Word files.
I could search on words in the file and one file names. I cannot find this
command in Word 2007. Please help!
As far as I know, that command is no longer supported.
Instead, use the Find feature in Windows. Hold the Windows key as you press
Microsoft Word MVP
"ellenjones6052" <email@example.com> wrote in message
> On Microsoft Word 2003, I could use the find file command ...The system could not find the volume specified 0x801F0014 DPM2010
DPM Server is 2008 r2 x64 and protected server is 2008 sp2 x64. All of a
sudden this started happening. Reinstalled agent, and recreated the
protection group didn't fix the issue.
Type: Consistency check
Description: An unexpected error occurred during job execution. (ID 104
Details: The system could not find the volume specified (0x801F0014))
End time: 3/10/2010 3:57:31 PM
Start time: 3/10/2010 3:57:28 PM
Time elapsed: 00:00:03
Data transferred: -
Cluster node -
Source details: F:\
Protection group members: 2
Protection gr...Look up last entry for text boxes or combo boxes
I'm consolidating some data that my company has accumulated and many
of the peices of data carry over to the next entry many times over.
In other words, many entries may have duplicate peices of data, i.e.
location, country, building, etc... I would like to make it so that I
can have some of my combo and text boxes remember what was last
entered so I don't have to retype it every time.
I thought that I had seen something like this before, but after a
morning of searching and reading I have decided to post.
Thanks in advance,
This was answered earlier --
Put ...Having trouble using 'find'
After a user's mailbox is moved from Exchange 2000 to Exchange 2003, he can
no longer do use the find feature. As a test, we try to do a 'find' for
emails in his inbox from someone we know he has a lot of them in his inbox.
The find finished in like one second and show nothing. Please help.
...vba for find last column with hidden columns in worksheet
This code has worked for finding the last column:
lc = ws.cells(7, columns.count).end(xltoleft).column.
However, when I used this code for a sheet that has hidden columns it would
What would be the correct code in this instance?
Thanks from OffDev wannabe
lc = Rows(7).Find(What:="*", SearchDirection:=xlPrevious).Column
> This code has worked for finding the last column:
> lc = ws.cells(7, columns.count).end(xltoleft).column.
> However, when I us...'find' command button
I have a 'find record' command button on a form. How do I make it open the
'find' popup with 'Lookin' set to the whole database (rather than the field
that the client is in when they press 'find') and 'Match' to any part of the
field, rather than whole field.
The second part is easy! Goto Tools - Options - Edit/Find and set Default
Find/Replace to General Search.
For the first part of your question you need to clarify. Do you really mean
"the whole database" opr do you simply mean to search all fields in the form?
And what...Where can I find a 'Goal Setting" template?
I am looking for a template which I can use for 'goal setting'. There are
programs out there selling for $100. or more. Is there one available on
Have you tried Excel's Goal Seek, or for more complex solutions, Solver?
Both are in the Tools Menu.
> I am looking for a template which I can use for 'goal setting'. There are
> programs out there selling for $100. or more. Is there one available on
...How to get last session position in 2007 Word
There was the simple and vary convenient AutoOpen macro in 2003 Word
that give last editing position when open document.
This macro does not work at all in 2007 Word. What can I do instead?
Check this thread.
Hope it helps,
...How to find free News-Server about science?
i hope someone can help me to find free Servers with newsgroups about
sciences , medicine, pharmacie and so one.
I'm total new and I use Outlook to show all informations.
Ask your ISP or Google it.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Kerstin Hummel
| i hope someone can help me to find free Servers with newsgroups about
| sciences , medicine...Advanced Find OR condition
How can Advanced Find be used to perform the following search:
List all Contacts...
- where their Job Title is "Chief Executive"
- where a custom field on a custom related entity is "Chief Executive"
Can OR conditions only be placed on fields within the same entity?
This seems like a bit of a hole in an otherwise extremely powerful tool.
"Optevia" <firstname.lastname@example.org> wrote:
> How can Advanced Find be used to perform the following search:
> List al...Removing last exchange 5.5 from exchange 2003
We have installed exchange 2003 linked to 5.5 and move all the mail from 5.5
to 2003 my question is, now is the time to remove the last exchange 5.5 I am
following the MS instruction on removing the last exchange but is not very
clear I am to the point that I am replicating offline address book and
schedule + free busy and eforms my problem is the everything is sync out
except free busy folder and I have a x.400 MTA from exchange 5.5 listed in my
2003 queue that when I turn off the 5.5 server keep sending mesage to 5.5.
Your help is greatly appreciated.
What are you using for your ...Last cell in a range
Can anyone tell me the way to display the latest entry into a range of cells
in a downward entry
I would like a cell to report the last cell in the column regardless of
whether it is the highest or lowest in the range.
Any help is as always Appreciated.
Will return the last entry in column A no matter what type of data.
For Numeric entry only..............
For Text entry only....................
Gord Dibben MS E...Last filled Column in a Worksheet
Pls cud some1 tell me how to find the last filled column
in a Excel worksheet?
The xlCellTypeLastCell() gives the last TYPED cell,which
is not always the last filled cell.
Is there a way out?
Sometimes this is a little tricky, due to Xl's reluctance to set it's
UsedRange after cells have been used and cleared.
I normally use a line similar to
iLastCol = Range("IV1").End(xlToLeft).Column
"Anita K" <email@example.com> wrote in message
news:07c801c39144$6e95f1b0$...Event ID 12002 error occured while processing message
Hi, Have just upgraded to Exchange 2003 from 2000 last weekend and now am
getting error 12002 800804DE against MSExchangeIS The message says error
occured while processing message from (email address). All the Microsoft
articles I read refer to Exchange 2000 not 2003 any help appreciated. This
has happened about 5-6 times in the last week.
We have no virus software installed on the Server. I made sure of that
before doing the upgrade so that no issues would arise.
Do we need to do anything about these messages
...finding the size of files using vc++
I need to write code in vc++ for finding the size of any file or document
that the user has clicked on. I also need to know how to compress
documents and then find the size of the compressed file. Can anybody
help me ASAP?
> need to write code in vc++ for finding the size of any file or document
that the user has clicked on.
Take a look at CFileFind
"dc" <firstname.lastname@example.org> wrote in message
> I need to write code in vc++ for finding th...Formula to find average of field for all rows that contain another field
Say I have a worksheet with the following information:
Name Position Salary
John Producer $10,000
Jeremy Producer $98,000
Jaime Producer $50,000
Darren Artist $67,000
Chris Artist $75,000
Clint Artist $30,000
Adam Artist $57,000
In Cell C2 (salary for John) I want to create a formula that looks for
all rows that contain the same position as in B2 (John's position which
is producer) and then calculates the average of all the salaries in
column C of those rows that have the position producer. Then I want to
compare that calculated average salary for all rows that have the
position prod...finding last non empty cell in a column #2
Perfect - Thank
cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286
View this thread: http://www.excelforum.com/showthread.php?threadid=26238
I just noticed that if I load a document into Word and then try to paste
something to Find or Replace form from another document (assumed string
being pasted comes from clipboard) that Word 97 will Not allow you to paste
that string -- It must be manually typed.
Would someone who is still using Word 97 please confirm this for me.
If this is by design "normal for 97" --- or if there a work around and/or
registry setting to correct this?
Have you tried pasting the text into the body of the document first, then
re-copying and then pasting into the Fi...finding last value in rows
Here's what I have. In column B5 I have a list of 35 people and i
columns C5 through AL5 I have weekly values, all with 0 values excep
the first week which has already been entered. I need excel to find th
last value that is not 0 for each of the 35 people.
I tried this formula but it only seems to work with the first week o
=INDEX('Totals sheet'!C5:AL5,COUNTA('Totals sheet'!C5:AL5)>0)
Can anyone help?...thanks
Message posted from http://www.ExcelForum.com
one way: enter the following array formula (CTRL+SHIFT+ENTER):
=INDEX('Totals sheet'!C5:A...How to find a text in a string without giving the position of the
My requirement are
I want to find a particular text in a string with out giving the position of
the text . I believe that if we use find and search we have to give the text
position for the particular text. Can anyone guide me what should be the
function used for getting this.
Microsoft MVP Excel
"Sreekanth" <Sreekanth@discussions.microsoft.com> wrote in message
> My requirement are
> I want to find a particular text in...