Marketing list fails???
I could see that when use the last two options to select accouns or contacts
to integrate to a list, this "advance search" fails, this does'nt find
nothing.... it's possible???
thanks in advance
the functionality goes right, It was my error,this two types of search it's
about existing accounts inside marketing list and not includes accounts
> I could see that when use the last two options to select accouns or contacts
> to integrate to a list, this "advance search" fails, ...Count if criteria is part of list
Want to be able to count all value in particular range that have a
value that appear in list of multiple values
eg have spreadsheet all different types computers and what versions of
o/s and service pack they are running
Windows XP Professional SP2 Dell Inc.
Windows XP Professional SP2 Dell Inc.
Windows 2000 Professional SP4 Compaq
Windows 2000 Professional SP4 Dell Inc.
Windows 2000 Professional SP4 Dell Inc.
Windows 98 sr2 ...Moderated Distribution Lists? Public Folders?
I have an Exchange 2003 Distribution List that has a bunch of email
addresses. My boss has this moderated so only certain people are allowed to
send to it... set in Exchange Properties. Unauthorized users that send to it
get an NDR.
Right now if someone needs to send to it... we have to temporarily add them
to the list... they send... then we have to remove. This is time consuming
and not practical.
Is there any way to make this moderation process automatic. Ideally... I
would want someone to send to the list... then the "list owner" would get an
email to either appro...How to create Auto Regenerating Dropboxs in data entry forms
I'm trying to create an auto generating drop box on a data entry form. That
is, someone would be entering data that may pertain to more that one project.
I'd like to have a drop down menu that, once a value is selected from it, an
exact duplicate appears underneath, and the user can enter as many projects
as are associated with that data. I'm not sure how to do this.
Make your combo box an unbound control. In the After Update event of the
combo, set the Default Value of the control you want to populate to the value
in the combo.
I am assuming the combo is on the main fo...Auto Sort #3
I have a chart that the range is A9:AR25 with the headings being in ro
8(A8:AR8). I am trying to find out how I can have this char
automatically sort the data when a new value is entered, sort first b
column AR, if tied then by column AI and finally if still tied b
Message posted from http://www.ExcelForum.com
record a macro of your sort and then place within a worksheet change event
in the sheet module
"Rob04 >" <<Rob04.email@example.com> wrote in message
news:Rob04.firstname.lastname@example.org...Distribution List Conflict
I set up a distribution list in Outlook and gave it a name.
Then I needed to remove one email address from the distribution list. Since
I couldn't figure out how to remove one email address from the list, I just
deleted the list and created a new list using the same name.
My outlook auto-fills previously entered email addresses in the To field and
now whenever it auto-fills the distribution list name, it says that
distribution list is no longer valid. This is most likely happening because
the distribution list I deleted had the same name as the new one I replaced
it wit...Outlook [To] List (aka Select Names) Dialog
I installed NewsHound as recommended on ....
NewsHound works OK, except for one annoying problem.
Whenever I use [To] for email (or any of the other post address
options), the "Select Names" dialog opens with the Newsgroup List
instead of Contacts List. I have to use the dropdown and manually
Is there a way to set Contacts as default list in the "Select Names"
And, yes, I've contacted NewsHound Support and still waiting answer.
Computer System Specialist
IT ...Two stores listed in System Configuration folder
We migrated from an Exchange 5.5 single-server installation to a Exchange
2003 single-server installation. We think we have correctly moved all data
and roles to the new exchange 2003 server. We have been using the 2003 for
over 6 months with no problems.
Our old server is still listed under the "Servers" folder but we don't see
much more evidence of the old server than that. We are ready to delete the
old 5.5 server from the directory following the instructions in the MS KB
articles. The physical server is no longer available.
My question/concern is this:
Under ...How do I create a list in excel that contains external data?
I have spreadsheets linked to external data sources but I also need to add
data to them. Whenever the data source is refreshed rows are correctly added
or deleted from the columns containing external data but not from the columns
containing my data. My rows end up not corresponding to the external data
rows. I thought designating the entire data range as alist might help but I
recieved an error that says you can't make a list that contains external
data. Any one have suggestions?
You could store the related data on a separate sheet. Then, on the
worksheet with the external data...Money auto-assign category to downloaded transactions
It's happened several times, but I can't quite pinpoint the trigger to
it. Every now and then, when I download transactions into Money, it
random assigns a category to all the transactions, and the category is
the same one. For example, just earlier today, every transactions
downloaded was assigned "automobile" as the category. I have tried
different options under Tools - Setting - Online Sevices Setting, but
I can't quite figure out how to prevent this from happening. Any idea?
In microsoft.public.money, namsilat wrote:
>It's happened several times, but I can...Global Address List and a Shared Contact List
Thank you in advance!
I continue to have communication problems with e-mail stemming from the
fact that we have two locations for Our Staff in Outlook 2000(Exchange). We
listed in what is called the "Global Address List" and another, more
accurate version, in "Our Staff" listed under "Public Folders". When
someone wants to write a new e-mail, the "To" in their dialogue box directs
them to what is now the default "Global Address List" that contains a
Staff listing that is not as up to date or accurate. I attempted to add same
I am familiar with using an Access database and populating fields in Word,
can you do the same thing in Excel.
Not really sure what you mean but is Data>Form... what you are looking for?
Microsoft MVP - Excel
"Sharon" <Sharon@discussions.microsoft.com> wrote in message
>I am familiar with using an Access database and populating fields in Word,
> can you do the same thing in Excel.
>...Problems with Auto Forward on SBS 2003
I'm try to add a distribution Group/List under "Exchange General> Delivery
Options> Forward to:"
on a Small Business Server 2003
When I click on the modify button next to the "Forward to:" field I can only
see "other objects" and "users" under "Object Types" field.
I can't see the distribution list I created... Is this because it is Small
Business Surver 2003???
Any help would be appritiated!
no, have you used "Exchange tasks" to set the e-mail address on the
Only "mail-enab...how to write updated list to excel without having to close the browser first?
this code writes a single line to an excel sheet followed by a list of names
coming from a table in the database. The table is chosen from a
This works properly.
My problem is: suppose i wrote all the names of a table to excel. Then i
return to the main menu of the application without closing the browser.
Suppose now that the same table with the names is updated (e.g. by another
user who adds some new names). If i start this code below again and then
opening the new excel sheet (or first saving on my desktop), i see exactly
the same names as the previous ti...How do you create a drop-down menu within a cell in Excel?
How do you create a drop-down menu within a cell in Excel?
You can use data validation. There are instructions in Excel's Help, and
> How do you create a drop-down menu within a cell in Excel?
Excel FAQ, Tips & Book List
Every time I ry to drop a cap at the beginning o a nw chapter, it puts it on
top of the text instead of beside it were it should be. What do I need to do
to fix this
Which option are you choosing when you create the drop cap?
Note that in order to set drop cap options, you can right-click the border
of the drop cap and then click the Drop Cap command on the context menu.
Microsoft Word MVP
"Carl F" <Carl F@discussions.microsoft.com> wrote in message
> Every time I ry to drop ...Auto colour based on adjacent cell
How to set cell color automatically based on the color of another cell
How does the first cell get coloured? By Conditional formatting or
manually? If by conditional formatting then use he same conditin=ons to
change the second cell.
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"crapit" <email@example.com> wrote in message
> How to set cell color automatically based on the color of another cell
&g...Populate empty fields with a number
I have a a column which has 3 possibilites, 1,2 or 3. I have already
populated fields with either a 1 or 2 based on another query. I wish to
populate the remainder of fields which have no content with 3.
I have tried to write the query as UPDATE dbase SET dbase.[field] = 3 WHERE
dbase.[field] <> 1 AND <> 2. But this doesn't work, and have tried UPDATE
dbase SET dbase.[field] = 3 WHERE dbase.[field] = "", and this doesn't work
either. Data type mismatch occurs on last query.
Any help would be great?
You might try:
UPDATE dbas...Auto fill cell addresses by not 1
Is there a way to auto-increment the cell address in a formula by an
increment other than 1. For example by 15:
I have rather complex formulas that point to data on another excel
sheet where the data is organize into blocks (it is generated by
another program) rather than in nice sequential columns. Having to
manual enter the cell addresses for 200 rows is a PITA!
How about a little work?
Say I want the formula in row 1 (say E1).
I'd put this formula in E1:
="$$$=Fubar(a" & (...Outlook 2003 Auto Send/Receive #2
Hi, i need help please, In my Outlook 2003 the Auto Send/Receive stopped
working, to check my mails i have to manually click on send/receive so
that i receive emails. I did check all the necessary options, and all
are OK. and i did check to see if Work Offline is checked and its not.
the Include this group in send/receive is checked, and Schedule an
automatic send/receive every 10 min. is checked.
I use regular POP3 mail with windows xp sp2.
please if someone can help me solve this problem of mine.
With Outlook closed, find and delete the .srs file you will find us...outlook 2003 and Exchange 5.5 (client drops to offline)
I have a number of workstations that are using outlook 2003 without any
problem. However I have one workstation that continues to drop to offline
mode and cannot send or recieve may. I uncheck the offline mode and then it
goes in connected mode for about 10 minutes and then fails again. It then
asks for username and password which it rejects, even using administrator.
Anyone have any suggestions on how to troubleshoot this one?
Checked the physical connection already?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Properly back-up and ...Exchange 2003 Public Folder NDR Loop on Auto Reply
A specific public folder is set to collect resumes of employment candidates
that respond to job posted in local newspapers. Occasionally, spammers email
in to the public folder with a legitimate reply domain.com but a non-existant
firstname.lastname@example.org. Because the server name is legit but the user isn't, the
"Thank you for sending your resume." reply bounces off that server and it
sends the public folder an NDR. The Public Folder interperates this as
another inbound resume and resends the "Thank you", which in turn generates
another NDR. This happens up t...Import Master Category List in Outlook 2003 ?
I asked this in microsoft.public.outlook.general but did not receive a
Can anyone tell me how to import the Master Category List from my old
installation of Outlook 2003 into my new install of the same
version ? I exported everything else into a .pst file and got all my
contacts etc but the Category List doesn't 't seem to be included ?
Probably a result of the import. Importing a .PST file does two things:
A. You lose the following information:
1. Custom Forms
2. Custom Views
3. Connections between contacts and activities
4. Received dates on mail...Not Auto-forwarding Spam Filtered by SpamBayes
I'm using SpamBayes on Outlook 2000 for Exchange Server. I have set
an auto-forwarding rule. Currently this rule, forwards all the
messages including Certain Spam and Possible Spam messages as
identified by SpamBayes to another e-mail address. I would, however,
like to modify this rule such that Certain Spam will not be forwarded?
Is there a way?
The folder list for 3 users are out of order. All of the
folders are listed alphebetically except for Outlook
Today - [Mailbox - User] which "all of a sudden" is placed
at the end of the list...any suggestions?