Importing five row list from word 2003 to excel
I have a Word five row list I would like to import into Excel in a five
column list. Every hundred items or so their is a new heading. What do I do?
If it is in a word table you can cut and paste it. But you will have to
Once you get it into excel you can sort it and delete the duplicate
Message posted from http://www.ExcelForum.com/
...Contacts are not listed in address book
When I open my address book, there are only two contacts. When I open my
contact list it lists all my contacts. What do I need to do to get my full
contact list into my address book?
Depends a bit on what you have done so far and which version you have. You
have given us very little information.
Try this: right click your Contacts folder | Address Book | set as an
Outlook addess book (tick the box). If it doesn't work, tell us version and
how you got your Contacts into Outlook (import etc).
"Docmoney" <Do...Contacts in OWA
I have a public folder with all of our corporate
contacts. When I open this contacts folder in OWA each
contact is dsiplayed as a message. The creator is in the
from field,the subject is the contact name, and the
description is the actual message. It is obvious
something is not setup correctly. They work in Outlook
but how do I get my contacts to diplay correct in OWA?
http://support.microsoft.c...List of files
All I want to do is get a list of files in a directory so
they can be deleted. How do I get this list ?
> All I want to do is get a list of files in a directory so
> they can be deleted. How do I get this list ?
You can use FindFirstFile/ FindNextFile/FindClose API functions for
If you want to remove directory with its content take a look at
SHFileOperation in MSDN.
Kobi Ben Tzvi
"John" <firstname.lastname@example.org> wrote in message
> All I want to do is get a list of files in...Text to Columns from drop down list update
I need to perform a Text to Column conversion from a drop down list, but I
also need the extracted value to be updated if the value in the list is
Drop down list has 2 values:
If the user selects 1 I can easily extract out to another cell the value 1
using Text to columns, however if the user then changes the choice to 2 the
text to columns extraction is not updated to 2.
Is there a way to update changes in the original cell using text to columns?
Or is there another way I can assign a value to a drop down menu choice in a
different cell while havi...Favorite Folders reverts to default list when computer shut-down
I have no problem adding, deleting or moving folders in the Favorite Folders pane. The problem is that they all disappear and revert to the default list everytime my computer is shut down. So I have to keep adding the folders back in
Is there a way to keep the shortcut folders in the Favorite Folders pane?
I would like to have combo box functionality for the data validation feature
in Excel 2000. This doesn't seem to be available in the native validation
setup dialog box. Am I missing something? I would like to display the
validated items list in the leftmost column and have column(s) of
description display to the right of each list item (so I can tell which list
item I should select). Suggestions?
Debra Dalgleish has instructions for creating dependent DV lists.
Gord Dibben Excel MVP
On Tue, 08 Jun 20...How do I print a list of my E-mail folders?
I need to print a list of my e-mail folders.
"AHD23" <AHD23@discussions.microsoft.com> wrote in message
>I need to print a list of my e-mail folders.
I don't believe there's a way to do that, except as a screen shot.
Brian Tillman [MVP-Outlook]
This might be a workaround for you:
In example #1, replace the line
After running the code,...Usage Question
Not sure if this is the proper arena for this post, but.... Have a usage /
functional question regarding Outlook, suspect this is a common problem with
Here is the scenario:
1. Send an email to someone, do NOT copy the email to myself so it just goes
in my sent mail.
Here are two problems that arise out of this function:
1. If I am awaiting for a response / need a response to that email what is
the BEST way to re-tickle myself if in fact a response to that email is not
At this time I remember manually in some form a flag, task or just plain old
2. Once ...How can I transfer Hotmail contacts to MS Office Outlook?
I'd like to transfer my "contacts" in MSN Hotmail into my MS Office Outlook
Express. How does one go about this?
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, al...Constant List
Is there an easy way to return the values of the ChartType
constants? Excel 97 does not seem to list them in help and
I have not been able to find them in google.group
Select xlChartTypes in the Classes pane of the object browser. The
constants are named in the members panel. If you select one, it provides
the numeric equivalent at the bottom of the object browser, e.g.,
Const xlArea = 1
Member of Excel.XlChartType
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> Is there...I would like to export the data from a drop-down list to a table
I have a form with several drop-down lists, I need to have the information in
these lists in another document/spread sheet. Is there an easy way to copy
the data in these lists to another location?
The long way would be to re-type all of it.
...'Recently used file' list.
When I open Excel nine filenames appear on the RHS as 'recently
used files' (this number was set via Tools/Options/General, of
course). In the middle of this list are 3 no-longer-used files.
Though the files themselves have been deleted their names remain in
Is there an easy way to remove those entries from that list,
There is an entry in the help file "Display or hide recently used workbooks
on the File menu" which says uncheck the 'recently used files' checkbox, the
click OK. Then, basically, start again.
"DB.&...Outlook 2003 contact limit
I have a excel spred sheet with 1300 contacts in it, i have some problems importing them into Outlook 2003 a lot of the contacts are not imported
Is there a limit on how many contacts you can have?
or am i doing something wrong
Here is what i have done
I have exported my contacts to a spread sheet and then added a lot of contacts and then tryed to import it again without success
You are far below what the item count limit is.
Outlook 97-2002 Personal folders
65,000 items per folder
(max file size for pst is 2GB)
Personal Folders (unicode) personal folders
(artificial lim...Business Contact Manager #33
Is anyone else experiencing ongoing problems with
Business Contact Manager/Outlook 03. It operates ok then
for no reason it just crashes & burns. Where can i go for
agreed! it has never worked well for me either! I need to
uninstall and reinstall about 1/mo. Thought I would find
some answers here, but no luck. I am going to check for
>Is anyone else experiencing ongoing problems with
>Business Contact Manager/Outlook 03. It operates ok then
>for no reason it just crashes & burns. Where can i go
True or Faled The Table Template is used to automate data entry in a table.
We don't typically answer school questions in these newsgroups, but even if
we were going to, we generally like the question to be complete and make
"deborah Camp" <deborahCamp@discussions.microsoft.com> wrote in message
> True or Faled The Table Template is used to automate data entry in a
Scott M. wrote:
> "deborah Camp" <deborahCamp@discussions.microsoft.com> w...Need to remove Contact Folder in Outlook 2000
i have a lot of duplicate entries (1000), need to remove
the entire folder.
Do you want to delete them or do something else with them, have you looked
at the duplicate checkers here
"Rob Smith" <email@example.com> wrote in message
> i have a lot of duplicate entries (1000), need to remove
> the entire folder.
Need to remove the entire Contact Folder.
>Do you want to delete them or do something else with
...Address list filter rules
I am trying to create a new address list in Exchange 2003. What I want is
all employees and all employee distribution groups. After trying several
combinations I added a custom attribute to each employee and to each
employee distruction group and entered "Employee" as the value.
I then created a new address list with the filter rule which said if the
custom attribute 1 = Employee include in the list. Everything is fine
except that Query based distribution groups do not show up.
So I create a new address list and found that using any filter rule rejects
all query based distributi...CC automatically from distribution list
I am trying to set up a distribution list and trying to
automatically cc people from this list (but now all). Is
there someway to do this or a macro that can allow this
...Outlook shared contacts/emails
Can someone provide advice?
Computer #1 -- WinXP Home, Outlook SBE 2003
Computer #2 -- WinXP Home, Outlook SBE 2002 (note the year)
My contacts and email accounts are on Computer #1.
I wish for Computer #2 to have access to contacts for email sending, while
storage remains ONLY on Computer #1, but view/response capabilities for
I can find no way to share files and my research has only totally confused
me. I have been an Outlook Express user and have just setup Outlook for its
Computer #2 is an occasional user, so this won't justify much in time ...MSCRM 4.0 ISV Custom buttons not visible in Contact Detail Toolbar
After enabline isv integration in 4.0, I can see in the Accounts detail
level toolbar the sample isv buttons, but when I goto Contacts detail
toolbar, none are visible.
I just added a button to the detail level toolbar in CRM 4.0. It was added
basically to the same place as my old 3.0 in the isv.config, but after adding
it wasn't visible.
I then went to the ReadyServer image from Microsoft, and noticed that the
isv.config was not present! (isv.xsd was present and accounted for).
Since I could see the isv buttons in the account entity detail toolbar, I
added my custom butto...how do I find a list of databases with correpsponding company name
I need to know how in GP to pull up a list of our companies with their
corresponding SQL database names. I've done this a long time ago and
remember it being easy but cannot remember where to do this.
SELECT INTERID, CMPNYNAM FROM DYNAMICS..SY01500
"Tim Quiggle" <Tim Quiggle@discussions.microsoft.com> wrote in message
> I need to know how in GP to pull up a list of our companies with their
> corresponding SQL database names. I've done this a long time ago and
> rem...File Conversion Question
backup.pst Outlook 2003 version
Can this be converted to be restored into Outlook 2002?
What other possible solutions could be employed?
firstname.lastname@example.org <email@example.com> wrote:
> backup.pst Outlook 2003 version
> Can this be converted to be restored into Outlook 2002?
Only by using Outlook 2003 to create a 2002-format PST and then copying or
exporting the data to the 2002-format PST.
>...OWA Question #10
Hello, we're running Exchange 2003 and I have the following situation.
Several employees in our company decided to start a different branch.
Instead of creating a separate domain we just created a new account in AD
with a different domain suffix. So let's say they used to have
account@companyA.com. But now they have account@companyB.com. They've been
able to access email via Outlook just fine but when accessing it via OWA,
they are unsuccessful. We've tried logging them in with both companyA.com
and companyB.com domains in the login screen. companyA.com just retur...continous form question
I have a 'continous form' which gets its data from a table.
Im using a form for ease of use by the operator and data is displayed in
My form has 6 columns and thousands of rows - so many records in the table.
(its pretty much like an excel spreadsheet).
However, on my form, i have a text box and i want the text box to change to
eg VBred, if the time on the current record matches the time on the next
record. (obvousley time is one of the pieces of data and displayed as hh:mm)
As my form is a continous form, if i add my 'colour' text box to ...