mail merge

  • Thread starter Thread starter SVC
  • Start date Start date
S

SVC

I use mail merge and the sorce data is a sheet (file contains 3 sheets) from
excel file.

the problem is:

when ever i open the word document it says
Opening this document will run the following SQL command:

SELECT * FROM "Brk Addr$"

Data from your database will be placed in the document. Do you want to
continue?

[TAB's] Yes No
 
Thank you. that solved the problem
now a new one has erupted
when ever i update the data source which is a excel file the result is not
reflected in mail merge document.


garfield-n-odie said:
See http://support.microsoft.com/?kbid=825765 "You receive the 'Opening
this will run the following SQL command' message when you open a Word mail
merge main document that is linked to a data source".
I use mail merge and the sorce data is a sheet (file contains 3 sheets)
from excel file.

the problem is:

when ever i open the word document it says
Opening this document will run the following SQL command:

SELECT * FROM "Brk Addr$"

Data from your database will be placed in the document. Do you want to
continue?

[TAB's] Yes No
Click to expand...
Click to expand...
 
You have to rerun the mail merge to get the new data into Word.
Thank you. that solved the problem
now a new one has erupted
when ever i update the data source which is a excel file the result is not
reflected in mail merge document.


See http://support.microsoft.com/?kbid=825765 "You receive the 'Opening
this will run the following SQL command' message when you open a Word mail
merge main document that is linked to a data source".

SVC wrote:

I use mail merge and the sorce data is a sheet (file contains 3 sheets)
from excel file.

the problem is:

when ever i open the word document it says
Opening this document will run the following SQL command:

SELECT * FROM "Brk Addr$"

Data from your database will be placed in the document. Do you want to
continue?

[TAB's] Yes No
Click to expand...
Click to expand...
Click to expand...
 
what is the meaning of rerun mail merge. should i close and reopen word?
well i tried that but it didnt seem to work.

BTW how can we remove the data sorce [filename] associated to a mail merege.
so that i can freshly re associate the data sorce file.
garfield-n-odie said:
You have to rerun the mail merge to get the new data into Word.
Thank you. that solved the problem
now a new one has erupted
when ever i update the data source which is a excel file the result is
not reflected in mail merge document.


See http://support.microsoft.com/?kbid=825765 "You receive the 'Opening
this will run the following SQL command' message when you open a Word
mail merge main document that is linked to a data source".

SVC wrote:


I use mail merge and the sorce data is a sheet (file contains 3 sheets)
from excel file.

the problem is:

when ever i open the word document it says
Opening this document will run the following SQL command:

SELECT * FROM "Brk Addr$"

Data from your database will be placed in the document. Do you want to
continue?

[TAB's] Yes No
Click to expand...
Click to expand...
Click to expand...
 
By "rerun mail merge", I mean you open the main document and click the
"Merge to New Document" button on the Mail Merge toolbar to re-merge the
main document with the updated Excel data source.

Quoting from Word help on "Select a different data source for a main
document":
1. If the main document is not already open, open it.
2. If the Mail Merge Wizard is not displayed, point to Letters and
Mailings on the Tools menu, and then click Mail Merge Wizard.
3. Go to step 3 of the wizard (Select recipients) by clicking Next.
4. Click Select a different list.
5. In the Select Data Source dialog box, locate and select the data
source you want, and then click Open. The list of recipients appears in
the Mail Merge Recipients dialog box, where you can refine the list of
recipients to include.

what is the meaning of rerun mail merge. should i close and reopen word?
well i tried that but it didnt seem to work.

BTW how can we remove the data sorce [filename] associated to a mail merege.
so that i can freshly re associate the data sorce file.
You have to rerun the mail merge to get the new data into Word.

SVC wrote:

Thank you. that solved the problem
now a new one has erupted
when ever i update the data source which is a excel file the result is
not reflected in mail merge document.


message

See http://support.microsoft.com/?kbid=825765 "You receive the 'Opening
this will run the following SQL command' message when you open a Word
mail merge main document that is linked to a data source".

SVC wrote:



I use mail merge and the sorce data is a sheet (file contains 3 sheets)

from excel file.

the problem is:

when ever i open the word document it says
Opening this document will run the following SQL command:

SELECT * FROM "Brk Addr$"

Data from your database will be placed in the document. Do you want to
continue?

[TAB's] Yes No
Click to expand...
Click to expand...
Click to expand...
 
Back
Top