| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Link excel and word in mail merge without losing your data source?
I'm trying to make labels and envelopes but I want Excel as my data source to
be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. |
|
#2
|
|||
|
|||
|
Is the Excel file on your PC drive or on a network drive?
-- Sincerely, Michael Colvin "angie" wrote: I'm trying to make labels and envelopes but I want Excel as my data source to be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. |
|
#3
|
|||
|
|||
|
It's on a PC Drive
"Michael" wrote: Is the Excel file on your PC drive or on a network drive? -- Sincerely, Michael Colvin "angie" wrote: I'm trying to make labels and envelopes but I want Excel as my data source to be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. |
|
#4
|
|||
|
|||
|
Unless you do something special (share a folder on your pc and always leave that
pc on), the other users can't see the data. It would be much easier to put that excel file on a common network folder. angie wrote: It's on a PC Drive "Michael" wrote: Is the Excel file on your PC drive or on a network drive? -- Sincerely, Michael Colvin "angie" wrote: I'm trying to make labels and envelopes but I want Excel as my data source to be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. -- Dave Peterson |
|
#5
|
|||
|
|||
|
It's on a PC Drive.
"angie" wrote: I'm trying to make labels and envelopes but I want Excel as my data source to be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. |
|
#6
|
|||
|
|||
|
Can you store it on a network drive that all have access to?
-- Sincerely, Michael Colvin "angie" wrote: It's on a PC Drive. "angie" wrote: I'm trying to make labels and envelopes but I want Excel as my data source to be linked in the Word mail merge in case of changes to the data source and then it will automatically change in the mail merge. I can do that part but when I ready to share this information with other people within the organization, it states it can't find the data source that I've used. Please help, if would save me a lot of time. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) | |||
| Embed picture in excel mail merge into word? | Excel Discussion (Misc queries) | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| Merge mail excel to word | Excel Discussion (Misc queries) | |||
| Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
Hybrid Mode
