Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
Hi,
Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
Don't use the AddressBlock. It causes more problems than it solves.
-- 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 "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
Thanks Doug! Unfortunately, I can't tell my client this (at least until
things get desperate) ... - Sri Doug Robbins - Word MVP wrote: Don't use the AddressBlock. It causes more problems than it solves. -- 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 "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
If your software has to disconnect the data source as part of the process,
all the mappings will be lost. If that is what is happening (and it seems quite likely to me) then either your software can inspect the mappings before the original data source is disconnected, or it is not. If it can, then you /may/ be able to save and restore the mappings, as long as all the column names used in the original data source also exist in the one you attach (of course) If it cannot, then I think the only way to proceed, other than dissuading your client from using the ADDRESSBLOCK field, is to provide some software that saves the mapping information, before the mail merge main document is saved into the Oracle database, and get your software to restore the info. when it extracts the document. For example, you could save the mapping info. in a set of document variables. (But I haven't verified that youcan restore the mapping - I seem to remember that there can be problems in this area). This is one of the many problems that make it easier to avoid using the ADDRESSBLOCK as Doug suggests - unless of course, it just happens to work with the data source you happen to have (in which case the chances are you won't have to do any mappings anyway). Peter Jamieson "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
Why not? AddressBlock doesn't work properly.Your client is presumably paying
you for advice. Better to give him good advice. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ramudu wrote: Thanks Doug! Unfortunately, I can't tell my client this (at least until things get desperate) ... - Sri Doug Robbins - Word MVP wrote: Don't use the AddressBlock. It causes more problems than it solves. -- 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 "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
Thanks guys. It looks like I'll have to dissuade from using
AddressBlock. The reason they were using this is that we have multiple Address fields and AddressBlock formats them in a much neater way. - Sri Graham Mayor wrote: Why not? AddressBlock doesn't work properly.Your client is presumably paying you for advice. Better to give him good advice. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ramudu wrote: Thanks Doug! Unfortunately, I can't tell my client this (at least until things get desperate) ... - Sri Doug Robbins - Word MVP wrote: Don't use the AddressBlock. It causes more problems than it solves. -- 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 "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Address block match fields do not get saved
There is nothing preventing the user from arranging the individual fields in
exactly the same arrangement as that used by the addressblock. -- 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 "ramudu" wrote in message oups.com... Thanks guys. It looks like I'll have to dissuade from using AddressBlock. The reason they were using this is that we have multiple Address fields and AddressBlock formats them in a much neater way. - Sri Graham Mayor wrote: Why not? AddressBlock doesn't work properly.Your client is presumably paying you for advice. Better to give him good advice. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ramudu wrote: Thanks Doug! Unfortunately, I can't tell my client this (at least until things get desperate) ... - Sri Doug Robbins - Word MVP wrote: Don't use the AddressBlock. It causes more problems than it solves. -- 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 "ramudu" wrote in message ups.com... Hi, Our software has a mail merge functionality where we get the data source for the Word document (Office 2003) from an Excel spreadsheet. The software allows you to create the template document and then later send out correspondence as and when required by writing out the data to the spreadsheet and linking the Word document to it. Once the template Word document is created, it is then picked up by the software as a byte stream and stored in a (SQL Server 2000) database as an image field. The problem I am facing is that one of our clients tried using the Match Fields functionality of the Address Block and when the person opened the document again from the software the fields which were previously linked to the spreadsheet were now dropped. I tried manually opening (from the disk) the Word document and I saw the Match Fields were still there. So it seems to be a problem when the file is saved into the database and then retrieved. What can I do to resolve this issue? If anybody needs any code snippets from the application I can provide that on request. Thanks! - Sri |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert extra fields in Address Block for Mail Merge? | Mailmerge | |||
Change the address block in standard envelope to include Company | Microsoft Word Help | |||
Why does a space precede the name in the address block? | Mailmerge | |||
Need job title in mail merge Address block item | Microsoft Word Help | |||
Excluding fields in address | Mailmerge |