Hi, I am trying to export a list of contacts, which is greater than 5000,
from a marketing list but everytime I try I only get 5000 records.
This is a different problem to the throttling and Maxnumber of records
registry setting solutions as I have tried all of these.
If anyone has had the same problem and has managed fix it you advise would
be much appreciated.
Craig - you indicate that your problem is similar to this one:
If this is correct (and you have made the necessary/required changes
indicated in the KB above?) are y...Exchange 2003 Distribution List
We currently have two office's in different countries. In country 'A' we have a SBS 2003 server with exchange. In country 'B' we have a Windows 2000 Server. The countries are linked via VPN but are on different subnets. All users have email address like firstname.lastname@example.org
In country 'A' i want to setup a distribution list for the users in country 'B'. So what i did was setup the group, added contacts into Active Directory specifying SMTP and each users email address. However when i try and send an email to the Distribution Group it does not go through...Function is killing performance
Hi - I'm using a custom function in a query and it takes forever - was
hoping someone might have an idea of how to speed things up a bit.
A little more info: the function is relatively simple (4 arguments
that are run through an IF statement to pick a value from another
table (only 12 records). The query is run against a table with 41k
records. The numbers don't seem to big here, and the query takes over
Where & how are you using the IF's?
Sounds like a coding problem to me
<email@example.com> wrote in message
news:1189019241.93425...countif function hassle
Im working on two sheets
On sheet 1, I wish cell e37 to enter the number of times a date is
placed in the column h34:h44. (These dates will be randomly entered
The dates will fall on or between the current day "today()" and a date
enntered in sheet 2, cell N2
Every syntax I try falls over and I keep getting zero values in E37.
Its got to be easy but it escapes me. Any help out there?
dond's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25477
View this t...Import Text Wizard
I'm trying to open a .txt file from Windows that starts the Import Text
All I've managed so far is to actually open it, yet if you open a text
file in Excel it starts the wizard itself.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
I believe that the Text Import Wizard runs automatically from the user
interface. You can run it from Data, Text to Columns after the file is
...distribution lists and email
Can anyone tell me how I send an email to a distribution
list in outlook 2002 - the help instructions seem to be
inaccurate. they say to chose item from the insert menu -
however that is not a choice that appears on the insert
Create the distribution list. When you address the new message, click on the
To: field, browse to the DL name, and you're good to go.
Note - everyone will be able to see all the other DL members, so a better
option is to put the DL in the BCC field (blind carbon copy) and put your
own address in the TO field. Most people will appreciate i...manage text and tag mixed in xml
I've got an XML doc which looks like something like that :
The name of the package the procedure exists in in an oracle
This is necessary because ref cursor parameters need to be
in packages and are required for returning result sets.
Accessible via the <see
and I would like,...Need a way to by pass IMF by smtp email address white list
The global connection filtering accept list is not sufficient. Although it
is better to white list by ip address this does not work for email address
that are from public email services like Microsofts Hotmail or Gmail. It
also does not work for pop email addresses from large services like SBC's pop
email servers. Please correct me if I am wrong, but clearly it would be
better to risk spoofing of headers than to open the flood gates to all email
addresses at hotmail.com or gmail.com or sbcglobal.net if this could even be
done by ip address. Even if I am correct I would like a re...A Percentile IF function
Hi i was running if there was a percentile IF function or a way to run
something similar to an average if function.
Lets say I have a data set like below
What I want to achieve is to find the percentile of all data points that are
The average if function for this data looks like =AVERAGEIF(D1:D8,"a",E1:E8)
So ideally I want to be able to have a =PERCENTILEIF(D1:D8,"a",E1:E8),
sorting column d is no appropriare as different filters are constantly
applied to this data set.
Potentially I would want to ...March 11th Windows Update and VBA (dis)functionality in Access
I've programmed an AccessXP database that makes extensive use of VBA module
code called via Macro in response to form object events. Since yesterday's
Office Security updates (multiple), a particular module function called via
macro has begun to throw Microsoft Visual Basic Run-time error 2427 - You
entered an expression that has no value.
On debug, it jumps to the second in a series of about 6 If/Else statement in
which the [Object].Value is tested for content. The first appears to work
correctly, but commenting out the following 5 items one at a time causes the
func...How to get rid of GETPIVOTDATA function?
while addressing cells in a spredsheet from PivotTable Excel 2007 always
puts GetPivotData functionautomatically instead, like old versions, simply
addressing cells (like =B3 or simillar). It makes my formulas very long and
not possible to understand. I wonder if I can switch off this automatic
functuion and tell Excel to address cells just by they simple address?
Office button/Excel Options/Formulas/2nd section: deselect "Use GetPivotData
"Rafal Hemmerling" <Rafal Hemmerling@discussions.microsoft.com> wrote in
message news:...SQL Insert statement
I have an insert query running on SQL Server. I can run delete queries from a
module in an Access adp using this syntax.
CurrentProject.Connection.Execute "DELETE FROM dbo.HoldTerm"
This works fine and returns to the module to run the next line of code.
However, if I try an insert query it fails to return to the module although
it does run the query. This seems to be the case whether I call a stored
procedure or use the syntax above. The code will fail after the insert? Any
SQL Server 2000, MS Access 2002
What is the syntax of your insert statement...Need more =if functions
I'm trying to do an if,then function that looks at data in a cell and
compares to 13 different possible results but excel on allows 7 nested IF
functions. Any thougths on how to complete this task?
This is in regards to banking. The function should look at the term (13
different terms) and based on the term should return the appropriate rate.
With that many, I would use a VLOOKUP. To learn how to
use a VLOOKUP, see:
Or, if you're dead set on IFs, you could always
=IF(A1=1,1.3%,"")&IF(A1=2,...Functions and worksheets, passing arguments to functions?
I just got a book called, Excel for Chemists. But it didnt tell me
something i want to know.
I wonder if someone out there can help me?
Here is the problem, say that i have put some data into a worksheet.
A1 cell = XValues and A2 cell = YValues.
If i have a Function that takes 2 arguments below how do i write code
to pass, XValues, Yvalues to the function Deming?
Function Deming(XValues, Yvalues)
Dim MeanX(), MeanY()
'Get number of cells to use in calculation loop
Ncells = XValues.Count
ReDim MeanX(Ncells / 2), MeanY(Ncells / 2)
N = 0
put code here......do something......Why is copy/paste not copying the correct text?
Microsoft Publisher 2003: Occasionally when I copy something from one
document, something different appears in my publisher text box when I paste.
It's usually something recently pasted. How do I fix this?
...Finding a particular non zero value from a list
I have a column of formulas. The data I am entering will give a result
for each of the formulas sequentially ie there no nonzero results up to
a point. What I need to know is where the nonzero results start and to
log the last nonzero value. The column of formulas is 50 deep. I was
thinking take the average and where the average rises above zero that
cell would be the cell I am after but is there a better way?
Message posted from http://www.ExcelForum.com/
...Advanced dropdown list
I'm trying to create a dropdown box, that is half a field list and
I'm working on a database for a conglomerate of labs. Four of these
are major labs, the other 22 are branch labs.
At the moment, I just have a dropdown box that has a query and pulls
in all of the labs, and this works fine. The problem is, that the four
major labs, are in the list but not at the top.
Ideally I would like to move these 4 labs to the top of the list, have
a space, and then show the rest of the 22. I have created an SQL
statement to remove the 4 labs. Does anyone know how to manua...Check for # of Words in Function
Apologies in advance, I am NOT a coder, I am trying to fix VBA someone wrote
for me by 'slogging' through it on my own. Making some decent headway on
easier stuff but I am at an impasse.
He has a function that creates an Acronym out of a Value. However I want to
modify it so it ONLY does it if the # of words in that value > 1. Can anyone
give me a heads up on how to add that here please? It would be most
Private Function GenerateAcronym(ByVal val As String) As String 'Tested OK
Dim str As String, prom As String, ch As String, res As String
...Multiple sheet references in one function
Sheets 1-4 all list claims but they need to be seperated. The values that
are target...drawing function for simple dll
I am new for C++
I want to create some drawing function and call from VB
so i just try to create dll using VC++6
void _stdcall DrawBox(CDC *Dc, POINT Pt1, POINT Pt2 )
// Dc.MoveTo (Pt1);
// Dc.LineTo (Pt2);
but it give error "CDC is undeclared identifier"
i have include <afxwin.h> also
even it give err
error LNK2005: _DllMain@12 already defined in Test1.obj
what should i have to do
I dont know what you are trying to do this. If you want to repaint, do an
UpdateWindow/InvalidateRect. As far as putting this in a DLL, you will need
to know what type of DLL ...Excel text to columns
In Excel 2000 I downloaded my annual TD Waterhouse
satement. It all downloads to one cel and trying to get
just the last column into a susable for and separate it
into a single column of its own is difficult. Thewre must
be a simple way. Is here someone who might be able to
talk back and forth with me to resolve?
You can use this macro.
For Each c In Range("a2:a161") 'Selection
x = Right(c, InStr(3, c, " "))
If IsNumeric(x) Then c.Offset(, 1) = x
"fil"...Word and using Pop-up lists
This there a way to create a pop-up list, in this case I it is the 12
months. But I want the current month to be the top month so the user doesn't
have to scroll down to find it.
...Drop-down list #2
Any one able to share with me 1)how to create a drop
down list 2) how to have a scroll bar relate to a cell?
1. One way: Use data validation. Have a look at
http://www.contextures.com/xlDataVal01.html for more information
2. Not sure what you mean?
> Any one able to share with me 1)how to create a drop
> down list 2) how to have a scroll bar relate to a cell?
...Text in Attached Word File Changes When Copied to Outlook
When I receive a document as an attachment in Word, I
often need to open the document, copy the contents, put
it in a new Outlook e-mail and send it. The recipient
does not get the same text I copied. It appears that
Word has defaulted to the previous saved version, even
though that's not what was copied. Many tests have
confirmed this. Has anyone experienced this problem?
How about listing complete steps to reproduce the problem and your version
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power User...FIND function
I am using the "find" function to locate a particular letter in a cell.
This works fine except when the letter does not exist in the cell.
Displayed in the cell is "#VALUE!" and is not useable.
Is there a way to
=if(find("G",A1,1) = "nothing found",A1,find("G",A1,1))
will return either the string "nothing found" or the position of the first G in
You could also use =isnumber()
=if(isnumber(find(...)),"found it","not f...