A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Synch excel list with contacts distribution list



 
 
Thread Tools Display Modes
  #1  
Old May 1st, 2007, 11:48 AM posted to microsoft.public.outlook.contacts
Resi
external usenet poster
 
Posts: 41
Default Synch excel list with contacts distribution list

HI
I have a list of our volunteers which keeps being updated on a daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?


  #2  
Old May 1st, 2007, 08:41 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Synch excel list with contacts distribution list

In theory. That's what the Update Now button is for in a DL. It rarely works
as expected, however. Try it and see.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?




  #3  
Old May 1st, 2007, 09:49 PM posted to microsoft.public.outlook.contacts
Resi
external usenet poster
 
Posts: 41
Default Synch excel list with contacts distribution list

Thanks for your reply. However how do I make the link between an eexcel list
and a distribution list in the first place. I know about importing from
Excel, but so far contact just end up in the main contact list not in a
specific distribution list.
aslo, can I link to an Access (I think) database. all our vols are listed in
a database called Reiser's Edge and I can export, in a long and convoluted
way.., to excel, would be great to link it to an outlook dis list.
Thanks
Resi


"Russ Valentine [MVP-Outlook]" wrote:

In theory. That's what the Update Now button is for in a DL. It rarely works
as expected, however. Try it and see.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?





  #4  
Old May 1st, 2007, 10:12 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Synch excel list with contacts distribution list

Post more clearly.
You said you were adding or updating a Contact. That's Outlook. Excel does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know why you
would use a DL if you have a list in Excel. Why not just use that list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?




  #5  
Old May 3rd, 2007, 04:59 PM posted to microsoft.public.outlook.contacts
Resi
external usenet poster
 
Posts: 41
Default Synch excel list with contacts distribution list

sorry. I have a list of people names and e-mail address in Excel. I like for
all the e-mail addresses to be in a distribution list in Outlook and this
distribution list to be kept up-to-date with the excel entries when I make
any changes in the excel file.

otherwise can I e-mail stright out of Excel?
Thanks


"Russ Valentine [MVP-Outlook]" wrote:

Post more clearly.
You said you were adding or updating a Contact. That's Outlook. Excel does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know why you
would use a DL if you have a list in Excel. Why not just use that list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?





  #6  
Old May 3rd, 2007, 09:23 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Synch excel list with contacts distribution list

You cannot import into a DL. You already have a far more robust and editable
group of recipients in an Excel spreadsheet that you would ever hope to have
in a DL. Use your Excel spreadsheet as the datasorce for a mail merge to
electronic mail.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
sorry. I have a list of people names and e-mail address in Excel. I like
for
all the e-mail addresses to be in a distribution list in Outlook and this
distribution list to be kept up-to-date with the excel entries when I make
any changes in the excel file.

otherwise can I e-mail stright out of Excel?
Thanks


"Russ Valentine [MVP-Outlook]" wrote:

Post more clearly.
You said you were adding or updating a Contact. That's Outlook. Excel
does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know why
you
would use a DL if you have a list in Excel. Why not just use that list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?







  #7  
Old May 4th, 2007, 03:09 PM posted to microsoft.public.outlook.contacts
Resi
external usenet poster
 
Posts: 41
Default Synch excel list with contacts distribution list

Thanks it makes sense, did not know i could mailmerge to an outlook message.
just did not think about it! thanks again

"Russ Valentine [MVP-Outlook]" wrote:

You cannot import into a DL. You already have a far more robust and editable
group of recipients in an Excel spreadsheet that you would ever hope to have
in a DL. Use your Excel spreadsheet as the datasorce for a mail merge to
electronic mail.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
sorry. I have a list of people names and e-mail address in Excel. I like
for
all the e-mail addresses to be in a distribution list in Outlook and this
distribution list to be kept up-to-date with the excel entries when I make
any changes in the excel file.

otherwise can I e-mail stright out of Excel?
Thanks


"Russ Valentine [MVP-Outlook]" wrote:

Post more clearly.
You said you were adding or updating a Contact. That's Outlook. Excel
does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know why
you
would use a DL if you have a list in Excel. Why not just use that list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?








  #8  
Old March 15th, 2010, 10:23 PM posted to microsoft.public.outlook.contacts
aheart14
external usenet poster
 
Posts: 1
Default Synch excel list with contacts distribution list

The original question Resi asked is my question too. I need a DL (at work) to
update for other employees once I update it...I always click on UPDATE NOW
but thus far I am the only that has used the DL. Only time will tell if this
works.

"Resi" wrote:

Thanks it makes sense, did not know i could mailmerge to an outlook message.
just did not think about it! thanks again

"Russ Valentine [MVP-Outlook]" wrote:

You cannot import into a DL. You already have a far more robust and editable
group of recipients in an Excel spreadsheet that you would ever hope to have
in a DL. Use your Excel spreadsheet as the datasorce for a mail merge to
electronic mail.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
sorry. I have a list of people names and e-mail address in Excel. I like
for
all the e-mail addresses to be in a distribution list in Outlook and this
distribution list to be kept up-to-date with the excel entries when I make
any changes in the excel file.

otherwise can I e-mail stright out of Excel?
Thanks


"Russ Valentine [MVP-Outlook]" wrote:

Post more clearly.
You said you were adding or updating a Contact. That's Outlook. Excel
does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know why
you
would use a DL if you have a list in Excel. Why not just use that list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or remove
contact) automatically it updates my outlook distribution list.
is this possible at all?








  #9  
Old March 15th, 2010, 10:33 PM posted to microsoft.public.outlook.contacts
Russ Valentine
external usenet poster
 
Posts: 1,155
Default Synch excel list with contacts distribution list

Time has already spoken. Update Now does not work reliably and never has.
--
Russ Valentine
"aheart14" wrote in message
...
The original question Resi asked is my question too. I need a DL (at work)
to
update for other employees once I update it...I always click on UPDATE NOW
but thus far I am the only that has used the DL. Only time will tell if
this
works.

"Resi" wrote:

Thanks it makes sense, did not know i could mailmerge to an outlook
message.
just did not think about it! thanks again

"Russ Valentine [MVP-Outlook]" wrote:

You cannot import into a DL. You already have a far more robust and
editable
group of recipients in an Excel spreadsheet that you would ever hope to
have
in a DL. Use your Excel spreadsheet as the datasorce for a mail merge
to
electronic mail.
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
sorry. I have a list of people names and e-mail address in Excel. I
like
for
all the e-mail addresses to be in a distribution list in Outlook and
this
distribution list to be kept up-to-date with the excel entries when I
make
any changes in the excel file.

otherwise can I e-mail stright out of Excel?
Thanks


"Russ Valentine [MVP-Outlook]" wrote:

Post more clearly.
You said you were adding or updating a Contact. That's Outlook.
Excel
does
not have Contacts.
You can only synch a DL with Contacts in Outlook. I don't even know
why
you
would use a DL if you have a list in Excel. Why not just use that
list?
--
Russ Valentine
[MVP-Outlook]
"Resi" wrote in message
...
HI
I have a list of our volunteers which keeps being updated on a
daily/weekly
basis.
I would like to set it up so that when I make a change (add or
remove
contact) automatically it updates my outlook distribution list.
is this possible at all?









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.