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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|