How to use outlook address in Excel
I have an Excel sheet which I use as an invoicing-application. I would like
to retrieve address-data from Outlook where I keep all my contact-data of my
customers. So, I want to select a customer from my Outlook contactlist when I
am writing a new invoice in Excel.
In Word, I have a macro which does this, but unfortunately the
Application.GetAddress does not work in Excel.
Can somebody help me ?
"Henny Slokker" wrote:
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...After Re-Install
HELP!!! After a crash and a re-install of Office we are now getting user
name and password errors in Outlook 2002. We can access the same accounts
via a www interface with the same account information. PLEASE help. I've
downloaded all the service packs for XP and Office and I've tried
un-installing and re-installing including deleting all of the profile
information I can find and deleting Outlook's registry, but to no avail. I'm
obviously missing something. Any help would be fabulous. Please e-mail
Thanks so much!!!
...Global domain identifier (Country, ADMD, PRMD) in first Trace Info
Messages are timing out and NDRing with the below event id. This server was
originally installed in one RG, then moved to different one. I understand
this may have something to do with it but cannot find anything on MPO (trying
to avoid opening yet another case)
Thanks for the help.
Event Type: Warning
Event Source: MSExchangeMTA
Event Category: X.400 Service
Event ID: 209
Time: 8:02:26 AM
Global domain identifier (Country, ADMD, PRMD) in first Trace Information of
message C=US;A= ;P=MGC;L=SVR-ORW-EXC-08-041026230220Z-...produce list automatically from choice of drop down list
I have a drop down column where the choices are say 1 to 100
From the choices listed, I want to create a list automatically from the
results so I can set up if formulas against the choices selected.
Column A Column B
Choice (drop down box) Automatically adds look
selections from column
using column B
1 to 100 ...Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...Identifying other users
I am looking to display a message box, automatically, to identifying any
other users currently accessing a privately networked excel file when that
file is first opened. So that in the event of a 'read only' scenario they
know who to contact. A share option is not appropriate in this particular
...End user wants to create items in Global Address List
I have an end user who wants to be able to create distribution lists and
entries in the global address list. Any idea how I can configure him to do
he would have to have Exchange permissions, and that isn't a particularly
"Douglas McIver" <email@example.com> wrote in message
> I have an end user who wants to be able to create distribution lists and
> entries in the global address list. Any idea how I can configure him to
...Problems with address books
I've had to re-install outlook '97 a couple of times to sort out some
problems. Now I find that contacts isn't the default mail list. That's to
say when I want to send an email the list of people is from an old address
book and not from the contact list I have in front of me!
How do I make sure that when I want to send an email or fax that I'm
presented with a choice from my contact list?
How can I safely delete the old address books which are now a waste of
...exporting to address book
I want to export address's from excell into address book for the mac.
DIF is not available and
have tried other formats to no avail. Anyone know how to do this. I
have 1000 names,
address's, phone numbers and email address's and wish to email to this
I would look at either csv or txt output (File>Save as...), there are very
few address books in the PC world certainly that don't offer these import
Microsoft MVP - Excel
"Scotty&...Data Validation Allow List
Is there a way to click on the resulting combo box and have ALL the list
items show up instead of just what seems like the default of about 8--I can
scroll, but would like to just point and choose?
Also, is there a way to change the font of this combo box? The resulting
look like they are about 6 or 8 points.
Any help is appreciated.
Is this the right forum doug?
If you are using a combo box (from the control toolbox) as opposed to a
validation list you can change visible rows but not if you use validation
Debra has a solution here
R...allow user to highlight field on form
I have a database which records info about disabled people. One form is used
to input comments about the the person and has several memo fields. The user
wants to be able to highlight a field if the information is important and
needs to be highlighted to other users of the system. I cannot use
conditional formatting because the decision to highlight the field is made by
the user depending on different circumstances.
Any help would be appreciated
On Mon, 3 May 2010 16:52:01 -0700, aussiebob wrote:
> I have a database which records info about disabled people. One form is used...Obtain data from list
I want to get the data from the list on to a cell in
I have 2 sheets - On Sheet 1 - I have drop downs.
Whatever is selected in the list - I want to show that
value in a cell on Sheet 2.
Any help is greatly appreciated.
I think if you just change the properties of your dropdown
so that the linked cell refers to the cell on your other
sheet, it should work fine. Right-click on the dropdown
and goto properties...Linkedcell.
>I want to get the data from the list on to a cell in
>I have 2 sheets -...2 accounts being sent under one address
I currently have two accounts in my Outlook 2000. firstname.lastname@example.org &
PPP@provider.net. The PPP@provider.net is the primary account. When sending
an email from the email@example.com, it still shows as the PPP@provider.net
address, so in turn I get any replies to the firstname.lastname@example.org back to the
PPP@provider.net. Is there any way to make the reply address or the address
of sender shown to the email@example.com account?
You said you had 2 accounts.
You then listed 2 email addresses.
Those are not the same thing.
Clarify your post.
"jeepstr9" ...Where can I delete an old/incorrect email address?
I'm using Outlook 2003
So I have, say, Sandy in my contacts book.
Her email is SW@......
Later her email changes to SAW@......
I make the change in my contacts.
But when I'm creating a new email and I start to type "Sandy..." in the TO
field, it still finds the old "SW@..." address. Why?
How can I delete that old & incorrect address forever?
(Without starting from scratch and loosing all my old email?)
use arrow keys to highlight 'bad' address then hit delete btn
"jabadoodle" <firstname.lastname@example.org> wrote in message
n...Delete Search in explorer
I want to delete the Search... from explorer when you right click, but
I can't find the registry key for it..
Anyone one knows where it is at?
Mint <email@example.com> typed:
> I want to delete the Search... from explorer when you right click, but
> I can't find the registry key for it..
> Anyone one knows where it is at?
Why do you think every program feature has a registry key?
On Apr 12, 9:37=A0pm, "Greg Russell" <gruss...@invalid.co...How to exclude one user from being affected by mailbox limits.
We are using Exchange 2003 Stadard Edition.
We have put a 300MB limit on the mailbox store. However we would like the
manager to have a 500MB limit but we can't find anything that would exclude
him from being affected from the limits.
Can someone shed some light on this for me please?
Thanks for your help,
Jamie Tanner <JamieTanner@discussions.microsoft.com> typed:
> We are using Exchange 2003 Stadard Edition.
> We have put a 300MB limit on the mailbox store. However we would like...the same outbound SMTP address for multible users
Her is a tricky one
Is it possible to configure
Microsoft Exchange 2003 recipients so the emails seems
to be comming from the same sender SMTP address e.x.
when the sends email outside the organisation
it must be done on the server level and not in Outlook using "From" field
Thanks in advance
B.Hansen MCP Denmark
On Thu, 4 Jan 2007 21:25:12 +0100, "Bjarne Hansen"
>Her is a tricky one
>Is it possible to configure
>Microsoft Exchange 2003 recipients so the emails see...Are my tasks visible to other users?
It is possible to share tasks with other users if you are on an Microsoft Exchange Server. In Outlook 2003, click on Tasks, and in the Navigation Pane (The column on the left side of the
Outlook window) click on Share My Tasks if available. This option is not available unless you are using an Exchange Server e-mail account.
It is on the Permissions tab that you can set whether or not you would like to share your tasks with other users. You can specify the people who can access your Tasks, as well as their
Important If you select the Private check box in a Ta...How to create drop down list that determines another drop down list?
Here is an example of what I am trying to do. I have a list of ten
baseball teams with 20 players on each team. I want to create a drop
down box that will allow me to select one of the ten teams and then a
second drop down box below the first that will give me the list of the
20 players on the team I have selected in the first box. Then I want
to choose that player to enter his statistics. Is this possible? Any
help is much appreciated.
THANKS in advance,
You can use the selection from the first pulldown as the defined name for the second selection list
Then in t...how do I delete documents from the start list in word and excel?
how do I delete documents from the start list in word and excel?
You can not clear it whenever you want. You can however set the no of file
names to be displayed to 0 which clears the list...
In Excel 2003
Enter 0 against 'Recently Used File List' of clear the check box.
Word has a similar option.
For 2007 versions or if you want to play with Registry Settings (not advised
unless you understand it well) see
http://www.mydigitallife.info/2008/01/13/how-to-clear-and-delete-recent-documents-list-in-office-2007-word-excel-p...Keeping Archive File in Folders List
I have a colleague who placed the Archive file at the top
of her list of folders in Outlook so it is easy to open
the Archive file and search for a message or appointment
if necessary. She can't remember how she managed to do
this and I would love to do this myself.Any suggestions?
File-> OPen-> Outlook Data File... and browse to archive.pst
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Joan" <firstname.lastname@example.org....Content Boxes not appearing on list forms (newform.aspx)
FYI: I have posted this question on the sharepoint msdn forums and got
directed to the SBS newsgroup, I asked this same question there and have been
directed to here, i would be very greatfull if someone could please help.
I have many workstations (95% now) now not displaying text boxes/content
boxes within sharepoint (2003 SBS version). Any other site will display forms
sharepoint. This does not seem to effect all machines and seems to have
nothing to do with permissions as i have tried with all types of users. I
have tried changing all the security settin...Shared calendars
I am implementing a new mail domain (e2k3) on a Windows
2003 AD structure.
I have about 1200 users in the new domain, nobody is using
it yet though, they were migrated from another AD domain.
These users will all have new mail accounts on my new
exchange box, but I have been asked to set it up so that
ALL users have READ access BY DEFAULT to ALL other users
I see where I can give them full control to the entire
mailbox, but where can I give them specific control to
just the calendars?
Why do not create a Public Folder with a general Calendar on it and grant
access t...how to store user responses
Using Excel 2000, I have a userform--userform1, with a textbox--
I'm trying to get the user to enter the quantity for a part number in
a quote. There could possibly be as many as 40 different quantities
requested by the customer.
When the user enters the quantity and presses enter, I'd like to ask
them if they have another quantity to enter, or at least provide
another textbox so they could enter another quantity and keep
generating textboxes until the user is through adding quantities.
When they are finished entering the last quantity, the user needs to
c...Viewing other users Calendar
We've recently installed CRM 3.0, desktop client, and I noticed that since
the install, I can no longer see anyone else's availability on outlook's
We're using outlook 2003 -
Anyone see this before? Any suggestions?