Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge refresh data
I have Office 2007. Before our upgrade from Office 2000, with a mailmerge,
it will open up the excel sheet. In this excel sheet we had a 'refresh data' macro that would update the fields automatically upon open. With 2007, it doesn't "open" the excel sheet and therefore the sheet (data) does not get updated. Is there anyway to get around this so when I open up the mailmerge the data in the excel sheet is updated? thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge refresh data
In Word, click on the Pizza Button and then on the Word Options item on the
bottom border of the dialog that appears and then click on the Advanced item in the Word Options list and scroll down to the General section of the dialog and check the box against the "Confirm file format conversion on Open" Then when you attach the data source to the mail merge main document, you should be presented with a dialog in which you can select the method by which the data source is attached. Selecting the DDE method will probably give you back the functionality that you previously were used to. I do question however, why the spreadsheet is needing to be updated. -- 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 "joe schmo" wrote in message ... I have Office 2007. Before our upgrade from Office 2000, with a mailmerge, it will open up the excel sheet. In this excel sheet we had a 'refresh data' macro that would update the fields automatically upon open. With 2007, it doesn't "open" the excel sheet and therefore the sheet (data) does not get updated. Is there anyway to get around this so when I open up the mailmerge the data in the excel sheet is updated? thanks. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge refresh data
The spreadsheet needs to be updated because it gets its data from an oracle
database. Yes, I've tried the DDE method, but it's much too slow with office 2007. I think there may be an msquery section in tools or something, I'll check it out. "Doug Robbins - Word MVP" wrote: In Word, click on the Pizza Button and then on the Word Options item on the bottom border of the dialog that appears and then click on the Advanced item in the Word Options list and scroll down to the General section of the dialog and check the box against the "Confirm file format conversion on Open" Then when you attach the data source to the mail merge main document, you should be presented with a dialog in which you can select the method by which the data source is attached. Selecting the DDE method will probably give you back the functionality that you previously were used to. I do question however, why the spreadsheet is needing to be updated. -- 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 "joe schmo" wrote in message ... I have Office 2007. Before our upgrade from Office 2000, with a mailmerge, it will open up the excel sheet. In this excel sheet we had a 'refresh data' macro that would update the fields automatically upon open. With 2007, it doesn't "open" the excel sheet and therefore the sheet (data) does not get updated. Is there anyway to get around this so when I open up the mailmerge the data in the excel sheet is updated? thanks. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge refresh data
I would suggest using a Query in Access that makes use of a table(s) that is
linked to the Oracle database. -- 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 "joe schmo" wrote in message ... The spreadsheet needs to be updated because it gets its data from an oracle database. Yes, I've tried the DDE method, but it's much too slow with office 2007. I think there may be an msquery section in tools or something, I'll check it out. "Doug Robbins - Word MVP" wrote: In Word, click on the Pizza Button and then on the Word Options item on the bottom border of the dialog that appears and then click on the Advanced item in the Word Options list and scroll down to the General section of the dialog and check the box against the "Confirm file format conversion on Open" Then when you attach the data source to the mail merge main document, you should be presented with a dialog in which you can select the method by which the data source is attached. Selecting the DDE method will probably give you back the functionality that you previously were used to. I do question however, why the spreadsheet is needing to be updated. -- 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 "joe schmo" wrote in message ... I have Office 2007. Before our upgrade from Office 2000, with a mailmerge, it will open up the excel sheet. In this excel sheet we had a 'refresh data' macro that would update the fields automatically upon open. With 2007, it doesn't "open" the excel sheet and therefore the sheet (data) does not get updated. Is there anyway to get around this so when I open up the mailmerge the data in the excel sheet is updated? thanks. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge refresh data
In Word 2007, you should be able to link directly to an Oracle table or view
using either the Microsoft's OLE DB provider or ODBC driver for Oracle databases or Oracle's own driver/provider. Microsoft's provider/driver only supports Oracle up to version 6 but may work OK with later versions of Oracle as long as you do not need to use features that did not exist in 6. Or you can do it the way Doug suggests, which would also use the MS or Oracle ODBC provider and should allow you to create the query you really need if you are not allowed to create what you need on the server itself. It's probably also simpler than the "direct" method. To do it "directly" from Word, you either have to use MS Query, which uses ODBC, or rather more directly using OLE DB, in which case you have to set up a ".odc" file (Office Data Connection) file. To do that in Word, when you get to the "Select Data Source dialog", you should see a "New Source" button. Click that, and select "Oracle" to use Microsoft's provider, or Other/advanced if you have Oracle's OLE DB provider installed (after that, you have to choose the correct provider). During theis process a .odc file is created which you then select as the data source. Unfortunately, to make it all work, you will probably end up having to embed your login/password information either into the Word .document itself or into the .odc file. Peter Jamieson "joe schmo" wrote in message ... The spreadsheet needs to be updated because it gets its data from an oracle database. Yes, I've tried the DDE method, but it's much too slow with office 2007. I think there may be an msquery section in tools or something, I'll check it out. "Doug Robbins - Word MVP" wrote: In Word, click on the Pizza Button and then on the Word Options item on the bottom border of the dialog that appears and then click on the Advanced item in the Word Options list and scroll down to the General section of the dialog and check the box against the "Confirm file format conversion on Open" Then when you attach the data source to the mail merge main document, you should be presented with a dialog in which you can select the method by which the data source is attached. Selecting the DDE method will probably give you back the functionality that you previously were used to. I do question however, why the spreadsheet is needing to be updated. -- 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 "joe schmo" wrote in message ... I have Office 2007. Before our upgrade from Office 2000, with a mailmerge, it will open up the excel sheet. In this excel sheet we had a 'refresh data' macro that would update the fields automatically upon open. With 2007, it doesn't "open" the excel sheet and therefore the sheet (data) does not get updated. Is there anyway to get around this so when I open up the mailmerge the data in the excel sheet is updated? thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Recipients refresh | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
data in mail merge letter being cut off - data source field size? | Mailmerge | |||
Refresh Data from MS Access | New Users |