How to use outlook address in ExcelHello,
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:
> Hello,
>
> 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 #2I 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
that.
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 ListI 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
this?
Douglas
he would have to have Exchange permissions, and that isn't a particularly
good idea...
"Douglas McIver" <douglas@nospam.com> wrote in message
news:OFGd$QhiEHA.1104@TK2MSFTNGP10.phx.gbl...
> 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
> this?
>
> Douglas
>
>
...
Problems with address booksI'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
space?
Peter
...
Problem in Setting up CRM serverHi
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 '04I'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
tried:
regsvr32 msxml3.dll in start|run
also have un-installed and re-installed
cookies enabled
...
exporting to address bookI 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
group. Thanks
Scotty
Scotty
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
formats
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"Scotty&...
2 accounts being sent under one addressI currently have two accounts in my Outlook 2000. xxx@provider.net &
PPP@provider.net. The PPP@provider.net is the primary account. When sending
an email from the xxx@provider.net, it still shows as the PPP@provider.net
address, so in turn I get any replies to the xxx@provider.net back to the
PPP@provider.net. Is there any way to make the reply address or the address
of sender shown to the xxx@provider.net account?
You said you had 2 accounts.
You then listed 2 email addresses.
Those are not the same thing.
Clarify your post.
--
Russ Valentine
[MVP-Outlook]
"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?)
Thanks
Gary
use arrow keys to highlight 'bad' address then hit delete btn
"jabadoodle" <jabadoodle@yahoo.com> wrote in message
n...
problems with toolbar-can't access certan commands i.e.hyperlinkcan't access some commands - was working fine - now some commands are in grey
- the commands disappeared from the pull down in the commands bar.
Help
magnus wrote:
> 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
http://ed.mvps.org
Trial version? You may have run out of time.
Some pulldowns only work when you are creating a ...
Creat a time bookI'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 versionhey everyone
both on my main computer and my brothers laptop word isnt working! its so
annoying!
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 usersHi group
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.
info@domain.com
when the sends email outside the organisation
(not internal)
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"
<bhansen1@hotmail.com> wrote:
>Hi group
>
>Her is a tricky one
>Is it possible to configure
>Microsoft Exchange 2003 recipients so the emails see...
Problem exporting/importing .psfHi 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) colourshello all,
when the color-palette from the windows-desktop (properties)
is set to 16-bit (65536), the print preview does not show the
bitmaps properly.
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...
any ideas?
thanx a lot,
tschu.
the code:
BOOL CDib::Draw(CDC* pDC, CPoint origin, CSize size)
{
if(m_lpBMIH == NULL) return FALSE;
if(m_hPalette !...
new document and framework problemHi,
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
better idea.
Thanks,
scott
I don't think OnDraw is appropriate at all because that gets called all the
time.
How about OnInitialUpdate?
--
Jonathan Wood
SoftCircuits
http://www.softcircuits....
CRM 4.0 VPC ProblemI 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
"Toi Day" <ToiDay@discussions.microsoft.com> wrote in message
news:50BF3D76-10D8-4CF0-90BC-EFF8E0D925A0@microsoft.com...
> 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?
110272
110277
1103
110329
110338
11033
--
65Stan
-----------------------------------------------------------------------
65Stang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1500
View this threa...
JWalk Chart Tools series label problemI 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 CListCtrlI'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
statement:
m_List.SetItem (pos, 0, LVIF_STATE, NULL, 0, LVIS_SELECTED, LVIS_SELECTED,
0);
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?
-Eric
>I'm having trouble with a CListCtrl object. I'm trying to automatically
>set the selected ite...
Printing Problems...Hello All..
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,
etc etc
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.
Sub delivery_copy()
Dim sh As Worksheet
For Each sh In ThisWorkbo...
Windows Service problemHello all,
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
timely fashion".
Does anybody have any ideas why this same program will not work on
different
operating systems?
...
Address Lists #4This is a multi-part message in MIME format.
------=_NextPart_000_006A_01C524AC.4E5782E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 #2Hello,
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
article/webcast:
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fwc061600%2FWCT061600.asp
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 fileHi there,
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.
Regards.
Avinash
Outlook 97-2002 pst-files can only be up to 2GB. You can r...