Distribution group problem
I have over 700 address contacts that have been "tagged"
into various categories. I know how to set up a new
distribution group. However, when I choose "select names"
the names from my list apear as first name, last name
instead of last name , first name. This makes it almost
impossible to scroll up and down looking for the name I
want to select and add to my distribution group. Please
advise of any suggestions.
In Outlook XP, select Tools, Options, then click Contact Options. Change the
Default File Order to Last, First.
"Randal" <randal.langley@...named cell list
Could some kind person please tell me how to list the named cells of a XL
2007 spreadsheet in a worksheet. I have just upgraded from 2003 where I used
the Lotus help but cant find it in 2007.
On Sat, 29 Aug 2009 11:45:22 +1000, "Keith" <firstname.lastname@example.org>
>Could some kind person please tell me how to list the named cells of a XL
>2007 spreadsheet in a worksheet. I have just upgraded from 2003 where I used
>the Lotus help but cant find it in 2007.
Have a look here:
http://rhftech.com/hd/excel-print-a-list-of-n...Scotiabank not listed in Canada-version Microsoft Money 2006
I am located in Toronto, Ontario.
I just bought Microsoft Money 2006- Canada version today (11/16/2006).
To my amazement . . . SCOTIABANK . . . which is one of the BIGGEST banks in
all of Canada is *not listed as an bank* from which I can download my
checking account data directly into Microsoft Money.
Scotiabank tech support says I have to contact Microsoft.
How can I ad Scotiabank to MM . . . for AUTOMATIC downloads (I don't want to
have to manually download data each time!)
Why there#W$#@$ isn't Scotiabank on the list of banks?
Jim (now located in Toronto)
...Word doc. list to excell worksheet, how to?
Its great to be able to use a chart/worksheet made in excel and transfer it
to a word doc. but what I really need now is a solution to how to transfer a
word doc. list into a brand new worksheet.
You may be able to save it as a text file and then import into Excel. It's
not clear what you have in your word doc however.
> Its great to be able to use a chart/worksheet made in excel and transfer it
> to a word doc. but what I really need now is a solution to how to transfer a
> word doc. list into a brand new work...Hide Membership in Hidden Distribution Lists
Hi there. I've got a question from one of the managers regarding showing
membership in a Hidden Distribution List.
The DL is hidden from the GAL, using the checkbox. We have also set the
Hide Membership thru Exchange Tasks.
However if you open Properties of a user, Member Of tab, you can see they're
in that Hidden DL. (although if you go properties of the DL you don't see all
the members). Is there a way to not display that ? And I can't check Hide
from Address Book on the user either, because then they don't show up in the
GAL at all.
Anybody know ?
...Advanced Find #2
The security role has been set so that it read for user.
User can still see records created by other users.
Set the security role on core records so that read is only for userr.
Apply this role to a user.
Do an advanced find.
Find in activities:
Field: Created by
Condition: Does not equal
Type:User (here you should only be able to select the current users)
Enter go and the list of activities for everyone in the whole organization
It is my understanding that this should not occur with the role set with the
core record to user.
I would expect that there be no...Problems with distribution groups in Exchange 2003
I have a small business server 2003 with SP1 for both windows and exchange
server installed. It recieves mail for two domains. cleevelink.co.uk and
cleevehillnursing.co.uk. There are two distribution groups setup both called
info one for each domain. The problem occurs when mail is sent to
email@example.com it is routed to the correct members, however
mail sent to firstname.lastname@example.org is routed to the members of
cleevehillnursing.co.uk not the cleevlink.co.uk
Any thoughts greatly recieved.
On Sat, 26 Nov 2005 08:05:02 -0800, "Kevin Cook"
<KevinCook@discussio...Cannot find share.exe
I'm trying to assist a friend with re-installing Excel.
He has a old version of Excel (doesn't know for sure -
possibly 97) and is running Windows ME.
He previously had this installed but ended up
reformatting his system. He's now going back trying to
re-install his software.
He starts to install Excel using the licensed
installation disks but gets an error, "Cannot find
share.exe on system".
Can anyone tell me how to fix this? Is it just a matter
of getting a copy of this file? Where does it belong?
Any advice would be appreciated
Message posted...I am setting up newsgroup in outlook but can not find the "news" .
I was told to drag the "news" command to the category "go" to set up news
group...but I can not find the command "news"......can any one help please ?
Look in tools, customize...
Then got to the Programs tab in Control Panel | Internet Options and change
the default newsreader to Outlook Express. If OE prompts you to make it
your default newsreader the next time you launch it, click the "Don't ask
me again" box and then click the No button.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
...adding data from one sheet to another sheet as a dropdown list bo.
I want to add a drop-down list box on a seperate worksheet that my data is on
On this other sheet that holds your data, select the range that you want to
use in the Data Validation list and name it via Insert - Name - Define and
type in the name, like "MyList" without the quotes.
Then in the cell where you want the Data Validation cell, click Data
Validation, select List, and type "=MyList" without the quotes. Done. HTH
"gatorguy" <email@example.com> wrote in message
&g...Re: clicking on single option dropdown list in IE7 causes browser to c
It looks like any password manager will cause this issue - I am using
Bio-Cert and it handles the passwords for all applications - I tried
disabling it in IE7 version.13CO but did not resolve issue. Once I
uninstalled the application and removed all instances in the registry,
I was able to correct the Drop Down issue in IE7 version.13Co and 11.CO
Hope this helps someone.
...copying list items
Ok, I have a list of names on my first sheet (list) and several sheet
after it (1,2,3,etc). How do I get the first value in the list to cop
into sheet 1, the second value to copy into sheet two and the thir
value down to go into the thrid etc..?
Say into cell C3.
Any Ideas welcome
Hru48's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2489
View this thread: http://www.excelforum.com/showthread.php?threadid=47143
...Entourage EWS - Send on behalf
> Ce message est au format MIME. Comme votre programme de lecture de courriers ne comprend pas
ce format, il se peut que tout ou une partie de ce message soit illisible.
Our Entourage users want to send email on behalf of a distribution group, AD
permission has been set and it work just fine with Outlook 2007.
Once we add the distribution group in the delegated accounts in entourage
2008, it appears as (unconnected) in the left frame and user can't send
...Displaying buddy list on a dialog
I am new to MFC programming so please help me out
Actually i have a dialog bases application and on that
i want to display a list which consists of groups and within
that group there is list of people in that group.I want to display
it as that the groups should have an + icon and if i click on it it
becomes minus and the list of people is displayed but i want to diplay in
a vertical fashion,one below the other,all the groups and people
in one vertical line,not like in CTreeCtrl in which case it is in
tree like format..Something like
(-)O...related records in advanced find doesn't work
I have an advanced find where I am trying to bring in some information from
the 'related to' lead on an appointment. No matter what lead field I
select, no data is returned for that column. Has anyone seen this behavior
or had any issues with this?
The 'related to' fields work as a seach filter criteria so you are
specifying here which records to include in your search. The 'edit columns'
option dictate the data columns visibly returned from the query.
> I have an advanced find w...using vlookup to find exact match
I have two spreadsheets with same field called IDs.
I want to know whether the IDs in the ID column of the first sheet is in
the ID column of the second.
I want to create a new column on the first sheet to return Yes/No depending
on the result. I think I could use vlookup formula but have no idea how.
Can anyone help me?
Message posted via http://www.officekb.com
and drag down. Assumes your ID column is column A on both sheets.
"Janice Lee via OfficeKB.com&...CRM List Web Part
I am currently setting up sharepoint to display CRM contracts for engineers.
I have built the sharepoint site, and installed and configured the List Web
Part application, and now I have a page with a view of all our current
contracts on, which i have filtered down using a new view in CRM.
I would like to give people the ability to search via a different field than
the Primary Field (in this case contract name is the primary field, and i
would like to search by a newly created field.)
Does anyone know how i can configure this? Ideally, I would only like to
allow the option to searc...remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has
about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
in the big list as well. How do I extract those 6,000 entries from the larger
list? My expected result is a mailing list with 10,000 names.
Chip Pearson has some techniques at:
Howie J. wrote:
> I have two mail lists on excel. The first has 16,000 names, the second has
> about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
> in the big list as well. How do ...Create two related list box
I don't know if I can asking questions regarding Access in this foru
or not, but hopefully can get some answers.
In my Access form, I want to create 2 list box where the first list bo
with 3 sections (morning, afternoon, evening) and the second list box i
for the time(7-8am, 8-9am, 9-10am, 10-11am, 11-12pm, 12-1pm,.......).
So, when the user choose "morning" under the sections list box, the
the choices he has to choose from are 7-8, 8-9, 9-10, 10-11am. Afte
the time is chose, some information related are displayed out. How thi
can be done :confused: ?
I hope someone...A way to list which backorders are ready to transfer to order
When items are received in PO (via a Receiving Transaction Entry) and then
posted, one of the reports automatically generated is "Back-Ordered Items
Received". That is good and tells us which backorders can now be fulfilled.
However, what if that paper report is not printed, or it is lost? Is there
another Inquiry or Report that can tell us again what was on that report?
Also - is there an automated SOP function that would allow us to select only
"fulfillable" (ie. there's stock on the items now) backorders and transfer
them to orders?
I appreciate your com...Advanced Find Result Set
The result set from an advanced find query over multiple entities resturns
the same record multiple times.
For example: A user is looking for accounts, but these accounts must met
some criteria of a related entitie. The results shows the same account
multiple times, because the criteria of the related entity where met multiple
It looks like the 'Group by' of the query is not working.
Any ideas how to solve this??
...find simillar variables in 2 different sheets
i have 2 different sheets with the same indentifier numbers am trying to
figuer out how to get the same numbers
> i have 2 different sheets with the same identifier numbers
> am trying to figure out how to get the same numbers
Just hazarding a hunch that what you're after is something to do with or
which can be done with either VLOOKUP or INDEX/MATCH
Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her:
There...finding unique records
I have a column (B) that can be anywhere from 1 to several hundred rows. In
this column can be listed any three digit Project #, up to five unique
Project numbers in this column. Some may be listed many times. There may be
less than 5 unique records, but no more.
Then in a separate summary table to the right I have expenses summed in 5
columns (J,K,L,M,N), each of the five columns corresponding to the unique
records in B. If there are only 3 unique Project numbers among the 100 or so
records in Col B, then only J,K,L will show summary figures.
I'd like the header cells for columns ...How do I find a lost Excel file in Windows XP
Due to problems with new Windows XP, I lost an excel file. The shortcut still
points to the location of the file, but is unable to find any file with that
name. I have tried a search function but still am unable to find the file
Double-check your recycle bin, in case it ha been deleted. Try using partial
filenames to search, such as filename.*, file*.* or *.xls in case the file
has somehow been renamed. If this fails, try taking the enquiry to a Windows
XP newsgroup as this is not an Excel-specific problem.
"m2babs" <firstname.lastname@example.org> wrote in m...Excel Lists
A few months ago client requested I create an "Excel Database" by
which she meant an Excel list. Recently she sent it back for help
because the insert row (the one with the asterisk) at the bottom
disappeared. For the life of me I cannot figure out what the problem
is. I have not been successful in getting it to reappear either.
Anyone have any advice?
You need xl2003+.
Select your range
> A few months ago client requested I create an "Excel Database" by
> which she meant an Excel list. Recently she sent it back for...