Synch excel list with contacts distribution list

[Resi]

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?

 

[Russ Valentine [MVP-Outlook]]

In theory. That's what the Update Now button is for in a DL. It rarely works
as expected, however. Try it and see.

 

[Resi]

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

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]

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?

 

[Russ Valentine [MVP-Outlook]]

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?

 

[Resi]

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

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]

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?

 

[Russ Valentine [MVP-Outlook]]

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]

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

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]

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?

 

[Resi]

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

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]

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

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]
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?

 

[aheart14]

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.

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

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]

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


:

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]
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?

 

[Russ Valentine]

Time has already spoken. Update Now does not work reliably and never has.
--
Russ Valentine

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.

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

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]
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


:

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]
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?