Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saved Mailmerge Document Emailed to Outsider
How do I suppress the Reconnect to database when a document created with
mailmerge is sent outside the company? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saved Mailmerge Document Emailed to Outsider
If you want to e-mail the /result/ of the mailmerge, then merge to a new
document and send that. The new document should not be connected to a merge data source, unless (unfortunately) it is attached to a template that is connected to a data source, in which case things may be different. If you want to send a Word mailmerge main document, you'll have to disconnect the data source before you e-mail it. In all cases, changing the document type from e.g. Form Letters to "Normal Word Document" (e.g. by using the MailMerge toolbar) will disconnect the data source, lose any filter/sort settings, but retain all fields. Peter Jamieson "WordHazIt" wrote in message ... How do I suppress the Reconnect to database when a document created with mailmerge is sent outside the company? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saved Mailmerge Document Emailed to Outsider
Excellent observation. If I create my merge fields to an excel spreadsheet
in a DOC file, it does not prompt. If I use a template to create the document, it prompts. So for the million dollar question, is there a way to turn it off if you have a template other than "cleaning" the document? "Peter Jamieson" wrote: If you want to e-mail the /result/ of the mailmerge, then merge to a new document and send that. The new document should not be connected to a merge data source, unless (unfortunately) it is attached to a template that is connected to a data source, in which case things may be different. If you want to send a Word mailmerge main document, you'll have to disconnect the data source before you e-mail it. In all cases, changing the document type from e.g. Form Letters to "Normal Word Document" (e.g. by using the MailMerge toolbar) will disconnect the data source, lose any filter/sort settings, but retain all fields. Peter Jamieson "WordHazIt" wrote in message ... How do I suppress the Reconnect to database when a document created with mailmerge is sent outside the company? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saved Mailmerge Document Emailed to Outsider
It's probably better to have the following situation:
a. the template isn't attached to the data source b. an AutoNew macro in the template connects new documents created from the template to the data source. e.g. something like the following for an Excel file with a Sheet called "mysheet" Sub AutoNew() Dim strPathName As String Dim strQuery As String ' Put the pathname of your Excel .xls strpathName = "c:\myworkbooks\mywb.xls" ' Construct the Query - you may also need WHERE and ORDER BY ' clauses for filtering and sorting strQuery = _ "SELECT * FROM `mysheet$`" ' The following should be enough in Word 2003 ' If you do not need WHERE clauses etc. you ' can delete the SQLStatement line ActiveDocument.MailMerge.OpenDataSource _ Name:=strPathName, _ SQLStatement:=strQuery ' Set the merge type you want ActiveDocument.MailMerge.MainDocumentType = wdFormLetters ' optionally set the destination you want ActiveDocument.MailMerge.Destination = wdSendToNewDocument End Sub If you aren't in a position to use macros, I'd say the simplest approach is probably to do the same thing, but connect manually each time, which is tedious, but will probably do the trick. It may be worth veryifying whether or not the resultant document is trying to open the data source because /it/ has a data source attached, or because its template has. If it's only because the template has, then that suggests that you have already distributed the template to your recipients. Otherwise, if /their/ version of the template didn't have a data source attached, the document would not try to open a data source, IYSWIM. (I'd research this better but it's not going to happen this evening). Peter Jamieson "WordHazIt" wrote in message ... Excellent observation. If I create my merge fields to an excel spreadsheet in a DOC file, it does not prompt. If I use a template to create the document, it prompts. So for the million dollar question, is there a way to turn it off if you have a template other than "cleaning" the document? "Peter Jamieson" wrote: If you want to e-mail the /result/ of the mailmerge, then merge to a new document and send that. The new document should not be connected to a merge data source, unless (unfortunately) it is attached to a template that is connected to a data source, in which case things may be different. If you want to send a Word mailmerge main document, you'll have to disconnect the data source before you e-mail it. In all cases, changing the document type from e.g. Form Letters to "Normal Word Document" (e.g. by using the MailMerge toolbar) will disconnect the data source, lose any filter/sort settings, but retain all fields. Peter Jamieson "WordHazIt" wrote in message ... How do I suppress the Reconnect to database when a document created with mailmerge is sent outside the company? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can Iget a mailmerge document to hold merge file every time op | Mailmerge | |||
Programmatically inserting mailmerge fields into a document | Mailmerge | |||
page number printing on a merged report | Mailmerge | |||
recover Word document that was not saved | Microsoft Word Help | |||
How do I undo a saved document? | Microsoft Word Help |