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...Problems with public folders #2
I am having two problems which may or may not be related.
1) In System Manager when I try to view or work with the public folder tree,
I get the following error "The token supplied to the function is invalid",
ID no:80090308. I cannot see any public folders or manage them at all after
2) Whenever anyone clicks on send/receive in outlook 2003, they get the
following error "Task 'Microsoft Exchange Server' reported error
(0x8004010F):'The operation failed. An object could not be found.'"
Does anyone have an idea of what the problem is for either...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
...Problem in Setting up CRM server
We are trying to install CRM server. but we getting following error message
and we don't know the reason for this.
Action Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction failed. --->
Microsoft.Crm.Setup.Common.SetupException: Setup could not complete this
action. This might be due to the fact that there are multiple Domain
Controllers and they have not replicated new Microsoft CRM information yet.
If this is the case you have several options: 1. Go to the domain controller
and manually force synchronization. 2. Wait 15 minutes (typically) until
the domain controller synchron...Money '04
I'm trying to use the 'Money Browser' w/in MSN Money 2004
and get "Page Cannot Be Displayed" or sometimes "Action
Cancelled", but I can surf the web just fine with my
cable modem...what's up with that? I've read on this
forum that other users are having difficulties w/ this
particular issue, any resolution would be helpful. I've
regsvr32 msxml3.dll in start|run
also have un-installed and re-installed
...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&...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...problems with toolbar-can't access certan commands i.e.hyperlink
can't access some commands - was working fine - now some commands are in grey
- the commands disappeared from the pull down in the commands bar.
> can't access some commands - was working fine - now some commands are in grey
> - the commands disappeared from the pull down in the commands bar.
The hyperlink option may only appear when you are creating a Web
Publication in certain versions of Publisher.
Ed Bennett - MVP Microsoft Publisher
Trial version? You may have run out of time.
Some pulldowns only work when you are creating a ...Creat a time book
I'm building a semi automated time book in Access.
what i want is to be able to give access a two week period prefferably by
specifying the beginning and end dates and have access add an entry to a
table i'm going to call the 'Time Book' for each person in a personnell table
for each day.
the best i have been able to come up with is to pack a Macro with 14
queries, each adds one more day to a specified starting point.
one of the problems i'm running into is that some of the shifts run over
night and Access doesn't calculate the shift end correctly.
I wo...Word problems 2003 and 2007 version
both on my main computer and my brothers laptop word isnt working! its so
on my desktop PC i have windows xp and word 2003. after getting a virus
which stopped the internet from working i had to do a system restore - which
got rid of the virus. but when i click on word it says that "this shortcut
only applies to installed products", and when i go to word through program
files it says "this product is not installed on this user" - but there is no
setup thing i can press - will i need the disc maybe?
on my bro's laptop he got the sa...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...Problem exporting/importing .psf
Hi guys, I searched the community before and couldn't
find anything regarding this issue. I am trying to export
an Outlook 2000 mailbox from one user account to another.
However, when I try and import it, I get the message
saying that "Personal Folders "Properties for this
information service must be defined prior to use". I have
looked up solutions for this and they say to make sure
its not read only. I tried this and it doesnt work, its
currently NOT read only.
Please note: This is a computer where the Outlook folder
source for the export is on a user account no...StretchDIBits problem with 16-bit (65536) colours
when the color-palette from the windows-desktop (properties)
is set to 16-bit (65536), the print preview does not show the
I guess the ::StretchBlt(...)/::StretchDIBits(...)/::BitBlt(...)
don't work properly.
the bitmap is divided in 2 parts, the right (1/3 from the bitmap) is put
on the left place and the left is displaced to the right.
at all the other color-settings there's no problem: 8-bit, 24-bit...
thanx a lot,
BOOL CDib::Draw(CDC* pDC, CPoint origin, CSize size)
if(m_lpBMIH == NULL) return FALSE;
if(m_hPalette !...new document and framework problem
I have a dialog I need to display at the start of a new
document in my SDI app. My problem is the first time
through, it will show before the app is drawn. Where
should I put a call to run the dialog if I want to be
sure to only do so after the app is initially drawn?
I currently use a check in the view's OnDraw, but I'm
hoping someone else who knows the framework better has a
I don't think OnDraw is appropriate at all because that gets called all the
How about OnInitialUpdate?
http://www.softcircuits....CRM 4.0 VPC Problem
I downloaded CRM 4.0 VPC, extracted them, and I got MSDYCRM40VPC_BASE.vhd.
After I create a new virtual machine for this vhd, I got an message "Reboot
and Select proper Boot device or Insert Boot Media in selected Boot device"
when I clicked Start. So, it have not brought me to WINDOW LOGIN SCREEN.
Anyone had this CRM 4.0 VPC worked, please help me how to get it work to get
away from a message above.
Thanks and Appreciations
"Toi Day" <ToiDay@discussions.microsoft.com> wrote in message
> I...Number Format Problem Prevents Proper Sorting
I have a long list of numbers that were exported from anothe
application that I can't seem to format properly to sort in ascendin
order. I have changed the format from General to Number and back wit
no success. I'm sure that this is an easy fix, but I'm not seeing th
answer. The third entry below (1103) should be toward the top of th
list. Any ideas?
65Stang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1500
View this threa...JWalk Chart Tools series label problem
I am using John Walkenbach's "JWalk Chart Tools" add-in to label a data
series with values from other cells. (I want percentages as data labels even
though the series is charted as actual values.) The two cells I'm using to
label the two points in my series are not next to each other, if this is
important. I CTRL-click the two cells and they are listed in the selection
window with a comma, like this: 'Source data'!$D$8, 'Source data'!$AG$8 .
This looks good to me. But while the values in D8 and AG8 are 5.33% and
5.16%, the labels show up as 5.33% and 21.93%
B...Problems with CListCtrl
I'm having trouble with a CListCtrl object. I'm trying to automatically
set the selected items of the list from my code. I try the following
m_List.SetItem (pos, 0, LVIF_STATE, NULL, 0, LVIS_SELECTED, LVIS_SELECTED,
The SetItem function returns non-zero, which supposedly means it was
successful. However, I don't see any selection showing up. I even called
RedrawItem on this list item, but it didn't help either.
Anyone know about this?
>I'm having trouble with a CListCtrl object. I'm trying to automatically
>set the selected ite...Printing Problems...
I am trying to get my worksheets to play nicely..but no success.
I have say 10 worksheets, and in cell "B4" I have Client Copy (across all
sheets), so it needs to print all those sheets...
Then I need to change "B4" to Delivery Copy, then print all those sheets,
Problem is at the moment, it goes through all the sheets, and only prints
the Dock Copy sheets (the last set). I see the text at "B4" change to what it
should, but just keeps going and ignoring the print call.
Dim sh As Worksheet
For Each sh In ThisWorkbo...Windows Service problem
I have a program that I'm running as a service on a Window's NT machine,
I used 'Srvany.exe' to install it, and it's running fine.
But, when I try to do the same thing on a Window's 2000 machine, I get a
"Error 1053: The service did not respond to the start or control request in a
Does anybody have any ideas why this same program will not work on
...Address Lists #4
This is a multi-part message in MIME format.
Does anyone know of a solution (MS, script or 3rd Party) to get the =
5000+ external contacts I have in public folders into an address list? =
I know how to set that up on clients to display the public folder. Some =
people need access to 5 or so different PF and we are looking at various =
CRM solutions that would created more nested public folder contact =
lists... just looking for another solutions...OWA attachment problem #2
I'm experiencing unexpected behaviour in Outlook Web Access.
When i attach a Level1FileType-file to an e-mail and i save it in the drafts
folder instead of sending it, then i should not be able to access the
attachment when i re-open the e-mail from the drafts-folder according to this
Since this article states:
if you're working on a message and you attach one of these Level 1
attachments and you work for awhile and then you close the message to save it
i...Problem with the pst file
I'm facing a problem in opening a pst file(zile size
2.1GB). I have scanned the file using scanpst.exe several
times but the problem still persists. I have also used the
tool which minimises the size of the file..but no luck.
I really don't know why this problem occurs..is it due to
the file size..or one of the mails has got corrupt.
Also if by change if iam able to retrieve the file can i
export the same to Outlook Express so that the problem
doens't arise again..?
Thanks in advance.
Outlook 97-2002 pst-files can only be up to 2GB. You can r...