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
|
|||
|
|||
Saving mail merges
Hello everyone,
I am having a problem that when I delete the file that contains the source data (usually an Excel file with names, addresses, ect.) for my mail merge I am no longer able to open the mail merge document because it seems to be pulling form the source file whenever I open it. Is there a way to save the values in the mail merge document so that I can delete the source file and still be able to open the mail merge? I am using Word 2002 SP3. -- Thanks, David |
#2
|
|||
|
|||
Saving mail merges
It sounds like you are not actually executing the merge. If you want to
save a file that contains the result of the merge, you must execute the merge to a new document. I would suggest that you display the mail merge toolbar as it contains buttons for all of the actions required to initiate and perform a mail merge including buttons on the right hand end of the toolbar for executing the merge to the various destinations - Printer, Document or Email (depending upon the type of merge that is being performed, as a Directory type merge can only be executed to a new document and a Label type merge cannot be executed to Email) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "David" wrote in message ... Hello everyone, I am having a problem that when I delete the file that contains the source data (usually an Excel file with names, addresses, ect.) for my merge I am no longer able to open the mail merge document because it seems to be pulling form the source file whenever I open it. Is there a way to save the values in the mail merge document so that I can delete the source file and still be able to open the mail merge? I am using Word 2002 SP3. -- Thanks, David |
#3
|
|||
|
|||
Saving mail merges
Thanks Doug. That is exactly what I needed.
-- Thanks, David "Doug Robbins - Word MVP on news.microsof" wrote: It sounds like you are not actually executing the merge. If you want to save a file that contains the result of the merge, you must execute the merge to a new document. I would suggest that you display the mail merge toolbar as it contains buttons for all of the actions required to initiate and perform a mail merge including buttons on the right hand end of the toolbar for executing the merge to the various destinations - Printer, Document or Email (depending upon the type of merge that is being performed, as a Directory type merge can only be executed to a new document and a Label type merge cannot be executed to Email) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "David" wrote in message ... Hello everyone, I am having a problem that when I delete the file that contains the source data (usually an Excel file with names, addresses, ect.) for my merge I am no longer able to open the mail merge document because it seems to be pulling form the source file whenever I open it. Is there a way to save the values in the mail merge document so that I can delete the source file and still be able to open the mail merge? I am using Word 2002 SP3. -- Thanks, David |
Thread Tools | |
Display Modes | |
|
|