Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Hide dialogs on mailmerge
How do I hide the DataSource dialog and the Header dialog on mail merge?
For example, when the following code runs, I don't want to see it: If ActiveDocument.MailMerge.DataSource.Name = "" Then MergeSetup GoTo getDataSource End If TIA |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Hide dialogs on mailmerge
Not sure which particular problem you are encountering.
Is the DataSource dialog appearing when you execute the ActiveDocument.MailMerge.DataSource.Name = "" line (it doesn't here if there is no mail merge data source) or as a result of code in your MergeSetup routine? I would say the main point is that once you call OpenDataSource, you are at the mercy of the method and if it chooses to display a dialog box, you won't be able to suppress it (except possibly by working directly with the Windows API). The only way to avoid that is to ensure that the method always works, i.e. the data source is always where you say it is, there are never any "gotchas" opening it, and the OpenDataSOurce always provides enough info. to avoid the dialog. IMO that is in the general case impossible, not least becasue with some types of data source, you can't avoid a dialog. You may also need to look at the following KB article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document" at http://support.microsoft.com?kbid=825765 Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... How do I hide the DataSource dialog and the Header dialog on mail merge? For example, when the following code runs, I don't want to see it: If ActiveDocument.MailMerge.DataSource.Name = "" Then MergeSetup GoTo getDataSource End If TIA |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Hide dialogs on mailmerge
Thank you, Peter, for your help.
The system is very simple, so the method always work (hopefully (!)) -- (there's a built-in loop such that if there is not enough info, it loops to find it), so it ALWAYS has enough data to merge. I hear you saying there's no way to turn off the dialogs. (Rats!) st. "Peter Jamieson" wrote in message ... Not sure which particular problem you are encountering. Is the DataSource dialog appearing when you execute the ActiveDocument.MailMerge.DataSource.Name = "" line (it doesn't here if there is no mail merge data source) or as a result of code in your MergeSetup routine? I would say the main point is that once you call OpenDataSource, you are at the mercy of the method and if it chooses to display a dialog box, you won't be able to suppress it (except possibly by working directly with the Windows API). The only way to avoid that is to ensure that the method always works, i.e. the data source is always where you say it is, there are never any "gotchas" opening it, and the OpenDataSOurce always provides enough info. to avoid the dialog. IMO that is in the general case impossible, not least becasue with some types of data source, you can't avoid a dialog. You may also need to look at the following KB article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document" at http://support.microsoft.com?kbid=825765 Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... How do I hide the DataSource dialog and the Header dialog on mail merge? For example, when the following code runs, I don't want to see it: If ActiveDocument.MailMerge.DataSource.Name = "" Then MergeSetup GoTo getDataSource End If TIA |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Hide dialogs on mailmerge
No, what I was saying is that for most types of connection, if the
connection info. in your OpenDataSource call is correct and complete then the user shouldn't see prompts for either "Select Data Source", or the "Data Link Dialog". Trouble is that in some circumstances Word pops up the OLEDB Data Link dialog and/or the equivalent ODBC dialog if it doesn't think it has enough info. to make the connection. What kind of data source(s) are you trying to open, and what OpendDataSource parameters are you passing? (BTW if you search my articles in this NG via Google Groups or some such you should find plenty of info. about this, though there is doubtless more to know :-) ) Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... Thank you, Peter, for your help. The system is very simple, so the method always work (hopefully (!)) -- (there's a built-in loop such that if there is not enough info, it loops to find it), so it ALWAYS has enough data to merge. I hear you saying there's no way to turn off the dialogs. (Rats!) st. "Peter Jamieson" wrote in message ... Not sure which particular problem you are encountering. Is the DataSource dialog appearing when you execute the ActiveDocument.MailMerge.DataSource.Name = "" line (it doesn't here if there is no mail merge data source) or as a result of code in your MergeSetup routine? I would say the main point is that once you call OpenDataSource, you are at the mercy of the method and if it chooses to display a dialog box, you won't be able to suppress it (except possibly by working directly with the Windows API). The only way to avoid that is to ensure that the method always works, i.e. the data source is always where you say it is, there are never any "gotchas" opening it, and the OpenDataSOurce always provides enough info. to avoid the dialog. IMO that is in the general case impossible, not least becasue with some types of data source, you can't avoid a dialog. You may also need to look at the following KB article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document" at http://support.microsoft.com?kbid=825765 Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... How do I hide the DataSource dialog and the Header dialog on mail merge? For example, when the following code runs, I don't want to see it: If ActiveDocument.MailMerge.DataSource.Name = "" Then MergeSetup GoTo getDataSource End If TIA |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Hide dialogs on mailmerge
Thanks for the help and direction, Peter. I will search your articles, as
you suggest. st. "Peter Jamieson" wrote in message ... No, what I was saying is that for most types of connection, if the connection info. in your OpenDataSource call is correct and complete then the user shouldn't see prompts for either "Select Data Source", or the "Data Link Dialog". Trouble is that in some circumstances Word pops up the OLEDB Data Link dialog and/or the equivalent ODBC dialog if it doesn't think it has enough info. to make the connection. What kind of data source(s) are you trying to open, and what OpendDataSource parameters are you passing? (BTW if you search my articles in this NG via Google Groups or some such you should find plenty of info. about this, though there is doubtless more to know :-) ) Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... Thank you, Peter, for your help. The system is very simple, so the method always work (hopefully (!)) -- (there's a built-in loop such that if there is not enough info, it loops to find it), so it ALWAYS has enough data to merge. I hear you saying there's no way to turn off the dialogs. (Rats!) st. "Peter Jamieson" wrote in message ... Not sure which particular problem you are encountering. Is the DataSource dialog appearing when you execute the ActiveDocument.MailMerge.DataSource.Name = "" line (it doesn't here if there is no mail merge data source) or as a result of code in your MergeSetup routine? I would say the main point is that once you call OpenDataSource, you are at the mercy of the method and if it chooses to display a dialog box, you won't be able to suppress it (except possibly by working directly with the Windows API). The only way to avoid that is to ensure that the method always works, i.e. the data source is always where you say it is, there are never any "gotchas" opening it, and the OpenDataSOurce always provides enough info. to avoid the dialog. IMO that is in the general case impossible, not least becasue with some types of data source, you can't avoid a dialog. You may also need to look at the following KB article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document" at http://support.microsoft.com?kbid=825765 Peter Jamieson "zSplash" zNOSPAMSplash@ gci.net wrote in message ... How do I hide the DataSource dialog and the Header dialog on mail merge? For example, when the following code runs, I don't want to see it: If ActiveDocument.MailMerge.DataSource.Name = "" Then MergeSetup GoTo getDataSource End If TIA |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 how do I hide text in mailmerge labels w blank record? | Mailmerge | |||
Mailmerge picture from an Access Database | Microsoft Word Help | |||
Word Mailmerge with Access via DDE | Mailmerge | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge | |||
Included Property in Word 2003 MailMerge | Mailmerge |