A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mial merge data base problems



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2004, 08:35 PM
Rachael
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

This is a post from last week. I need some help still.
Below is the originals with all the quotes.

Thanks!



Subject: XP asks for database every time

Me: At work I just upgraded from Office 2000 to Office
XP. In
2000 after using a file a couple of times with a mail
merge, it would stop asking me for the database (it would
know where it is automatically).

I assumed the same would be for XP. I've had Office XP
for about a month now and every time I open a mail merge
document, it asks me for the location of the database!!
It's driving me nuts!! It never opens to the right
directory, and I have to locate it each time!

Is there a way around this? 99% of my documents are mail
merged to this same database and I use it constantly
throughout the day. I need a solution.

If there isn't one, I will ask tech to downgrade me
again, because I can't do this every time!
================================================== ======
CM: Hi Rachael,

1. Is this an Access database, or something else?

2. Is the database on your machine, locally, or in the
network?

3. Are you making use of the Recipients dialog box to
choose
records, or does also happen otherwise?

To get you going, you should look at the Word 2002
section
of my website's mail merge FAQ, most especially, the
information on connecting. Try using a DDE or ODBC
connection (if this is Access) and see if things don't
settle down a bit.

================================================== ========


ME: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

The Database is locally on my machine.

I don't know what the recipients dialog box is, but I'm
doing files on an individual per recipient basis. I never
have to send the same letter to more than one person.

(I work in insurance, and these are the claimants who I
send benefits too)

any help would be great.

================================================== ===

Me: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

CM: OK, if you have to navigate to the database in order
to relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?

ME: I don't know what the recipients dialog box is, but
I'm doing files on an individual per recipient basis. I
never have to send the same letter to more than one
person.

CM: Ahhh. OK. This isn't really what mailmerge is meant
for, but people do use it like that :-) So, in order to
choose the single recipient, what do you do, exactly?

================================================== ===

-----Original Message-----
I have no idea if it's an Access Database. It was

already
set when I started here. How could I find that out?

OK, if you have to navigate to the database in order to
relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?


ME: Ok, it's just a .doc file.


I don't know what the recipients dialog box is, but

I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one person.

Ahhh. OK. This isn't really what mailmerge is meant for,

but
people do use it like that :-) So, in order to choose

the
single recipient, what do you do, exactly?


ME: OK. This is the process (sorry if it's long, but I
need to figure this out).

I open the template I want to use in the "open office
document". I open the file and a window pops open that
says: "filename.dot is a mail merge main document. Word
cannot find it's data source, C:\...\filename.doc" and I
get two options: "Find Data Source" and "Options". I
click on "Find Data Source" and manually go to the
location of my filename.doc data source file. Then my
word document opens. It asks this for EVERY WORD FILE
that has a mail merge.

Then, I click on the the button on my toolbar
for "dataform" which is a picture of table with a
pen/pencil and a screen opens up that has all my fields
in the body, "record" at the bottom left (to cycle
through all my records) and a bunch of buttons on the
right ("Add New" "Delete" "Restore" "Find" "View Source"
and "Close").

I click on "Find" (a screen opens) and search by one of
the fields (i.e. last name), by clicking on the "find
first" button in the find screen. When the right record
shows up in the "Data Form" in the background, I click
the close button in the "find" box. Now, because there is
no "OK" button on the "Data Form" if I click on "Close",
the record doesn't update to the document. I have to look
at the bottom of the "Data Form" Screen for the record
number (say #192), click "Close" and go to my record
number space in the toolbar, type in the corect one
(192), press enter, and then it updates to my document
after pressing the "ABC" button (Veiw Merged data).

I'm trying to figure out if there is a better way to do
this.

If I click on the "find" button in the toolbar (the
binoculars one) It doesn't find anything. Of course, that
is related to my other post. Essentially, they are a
related issue.

I don't know anything about Macros. All I did was
customize my toolbar from the ToolsCustomize menu.

Any help would be apreciated. Our tech department doesn't
do Office help.


  #2  
Old May 18th, 2004, 12:54 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

Are you saving the document after locating the data source?

Is it actually a template (*.dot) file or just a document (*.doc) file that
you referred to as a template?

The binocculars button works fine here AS LONG AS THERE IS A MERGE FIELD IN
THE DOCUMENT.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Rachael" wrote in message
...
This is a post from last week. I need some help still.
Below is the originals with all the quotes.

Thanks!



Subject: XP asks for database every time

Me: At work I just upgraded from Office 2000 to Office
XP. In
2000 after using a file a couple of times with a mail
merge, it would stop asking me for the database (it would
know where it is automatically).

I assumed the same would be for XP. I've had Office XP
for about a month now and every time I open a mail merge
document, it asks me for the location of the database!!
It's driving me nuts!! It never opens to the right
directory, and I have to locate it each time!

Is there a way around this? 99% of my documents are mail
merged to this same database and I use it constantly
throughout the day. I need a solution.

If there isn't one, I will ask tech to downgrade me
again, because I can't do this every time!
================================================== ======
CM: Hi Rachael,

1. Is this an Access database, or something else?

2. Is the database on your machine, locally, or in the
network?

3. Are you making use of the Recipients dialog box to
choose
records, or does also happen otherwise?

To get you going, you should look at the Word 2002
section
of my website's mail merge FAQ, most especially, the
information on connecting. Try using a DDE or ODBC
connection (if this is Access) and see if things don't
settle down a bit.

================================================== ========


ME: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

The Database is locally on my machine.

I don't know what the recipients dialog box is, but I'm
doing files on an individual per recipient basis. I never
have to send the same letter to more than one person.

(I work in insurance, and these are the claimants who I
send benefits too)

any help would be great.

================================================== ===

Me: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

CM: OK, if you have to navigate to the database in order
to relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?

ME: I don't know what the recipients dialog box is, but
I'm doing files on an individual per recipient basis. I
never have to send the same letter to more than one
person.

CM: Ahhh. OK. This isn't really what mailmerge is meant
for, but people do use it like that :-) So, in order to
choose the single recipient, what do you do, exactly?

================================================== ===

-----Original Message-----
I have no idea if it's an Access Database. It was

already
set when I started here. How could I find that out?

OK, if you have to navigate to the database in order to
relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?


ME: Ok, it's just a .doc file.


I don't know what the recipients dialog box is, but

I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one person.

Ahhh. OK. This isn't really what mailmerge is meant for,

but
people do use it like that :-) So, in order to choose

the
single recipient, what do you do, exactly?


ME: OK. This is the process (sorry if it's long, but I
need to figure this out).

I open the template I want to use in the "open office
document". I open the file and a window pops open that
says: "filename.dot is a mail merge main document. Word
cannot find it's data source, C:\...\filename.doc" and I
get two options: "Find Data Source" and "Options". I
click on "Find Data Source" and manually go to the
location of my filename.doc data source file. Then my
word document opens. It asks this for EVERY WORD FILE
that has a mail merge.

Then, I click on the the button on my toolbar
for "dataform" which is a picture of table with a
pen/pencil and a screen opens up that has all my fields
in the body, "record" at the bottom left (to cycle
through all my records) and a bunch of buttons on the
right ("Add New" "Delete" "Restore" "Find" "View Source"
and "Close").

I click on "Find" (a screen opens) and search by one of
the fields (i.e. last name), by clicking on the "find
first" button in the find screen. When the right record
shows up in the "Data Form" in the background, I click
the close button in the "find" box. Now, because there is
no "OK" button on the "Data Form" if I click on "Close",
the record doesn't update to the document. I have to look
at the bottom of the "Data Form" Screen for the record
number (say #192), click "Close" and go to my record
number space in the toolbar, type in the corect one
(192), press enter, and then it updates to my document
after pressing the "ABC" button (Veiw Merged data).

I'm trying to figure out if there is a better way to do
this.

If I click on the "find" button in the toolbar (the
binoculars one) It doesn't find anything. Of course, that
is related to my other post. Essentially, they are a
related issue.

I don't know anything about Macros. All I did was
customize my toolbar from the ToolsCustomize menu.

Any help would be apreciated. Our tech department doesn't
do Office help.



  #3  
Old May 18th, 2004, 12:36 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

A possibility...

Are your Mail merge main documents (the .doc files) all connected to the
same template (.dot) (You can find out by opening the .doc, answering any of
the questions you are encountering, and looking at the first field in the
Tools|Templates and Addins dialog box.

The document and the template can theoretically be connected to different
data sources. It may be that the message you are seeing are displayed by
Word because it cannot find the data source attached to the /template/. If
so, you could consider two things:
a. open the template file itself (the .dot) and make sure it is attached to
the data source you want to use. Close the template, and open it again to
verify that you do not see the question about the data source.
b. open the template file and make sure it is not a mail merge main
document (i.e. use the Mail Merge Wizard or the first button on the
mailmerge toolbar to say that it is a normal word document. Then save it.

The problem with doing (b) is that new documents created using the modified
template will not be attached to a data source and you will have to attach
each document to your data source when you create it.

I have always been wary of using templates attached to data sources
precisely because you end up with two connections whenever you open a
document based on that template. If you are using the same data source a
lot, it may be better to create a "skeleton" .doc rather than a proper .dot
template. Connect the skeleton to the data source. Then, when you want a new
mail merge main document, open the skeleton, save it immediately with a new
name, and work with the new document. If you need the other facilities of a
template (styles, macros, autotexts and so on), create the template, but do
not attach it to a data source. Then base your skeleton.doc on your template
using Tools|Templates and Addins. WHen you make a copy of skeleton.doc, the
copy will also be based on the template.

Another possibility is that the full pathname of your data source document
is too long, that Word is not saving the full name, so that when Word
re-opens the document, it does not have the full name and has to ask you. I
do not know what the length limit is, if any, but if you think that might be
a possibility you could make a copy of your data source in a folder with a
very short name (e.g. c:\a ), then connect to that data source instead, and
see if that connection persists. Again, if the template is connected to the
data source, you may also need to modify the template's connection.

I hope you can follow all that!

--
Peter Jamieson

"Rachael" wrote in message
...
This is a post from last week. I need some help still.
Below is the originals with all the quotes.

Thanks!



Subject: XP asks for database every time

Me: At work I just upgraded from Office 2000 to Office
XP. In
2000 after using a file a couple of times with a mail
merge, it would stop asking me for the database (it would
know where it is automatically).

I assumed the same would be for XP. I've had Office XP
for about a month now and every time I open a mail merge
document, it asks me for the location of the database!!
It's driving me nuts!! It never opens to the right
directory, and I have to locate it each time!

Is there a way around this? 99% of my documents are mail
merged to this same database and I use it constantly
throughout the day. I need a solution.

If there isn't one, I will ask tech to downgrade me
again, because I can't do this every time!
================================================== ======
CM: Hi Rachael,

1. Is this an Access database, or something else?

2. Is the database on your machine, locally, or in the
network?

3. Are you making use of the Recipients dialog box to
choose
records, or does also happen otherwise?

To get you going, you should look at the Word 2002
section
of my website's mail merge FAQ, most especially, the
information on connecting. Try using a DDE or ODBC
connection (if this is Access) and see if things don't
settle down a bit.

================================================== ========


ME: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

The Database is locally on my machine.

I don't know what the recipients dialog box is, but I'm
doing files on an individual per recipient basis. I never
have to send the same letter to more than one person.

(I work in insurance, and these are the claimants who I
send benefits too)

any help would be great.

================================================== ===

Me: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

CM: OK, if you have to navigate to the database in order
to relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?

ME: I don't know what the recipients dialog box is, but
I'm doing files on an individual per recipient basis. I
never have to send the same letter to more than one
person.

CM: Ahhh. OK. This isn't really what mailmerge is meant
for, but people do use it like that :-) So, in order to
choose the single recipient, what do you do, exactly?

================================================== ===

-----Original Message-----
I have no idea if it's an Access Database. It was

already
set when I started here. How could I find that out?

OK, if you have to navigate to the database in order to
relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something else?


ME: Ok, it's just a .doc file.


I don't know what the recipients dialog box is, but

I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one person.

Ahhh. OK. This isn't really what mailmerge is meant for,

but
people do use it like that :-) So, in order to choose

the
single recipient, what do you do, exactly?


ME: OK. This is the process (sorry if it's long, but I
need to figure this out).

I open the template I want to use in the "open office
document". I open the file and a window pops open that
says: "filename.dot is a mail merge main document. Word
cannot find it's data source, C:\...\filename.doc" and I
get two options: "Find Data Source" and "Options". I
click on "Find Data Source" and manually go to the
location of my filename.doc data source file. Then my
word document opens. It asks this for EVERY WORD FILE
that has a mail merge.

Then, I click on the the button on my toolbar
for "dataform" which is a picture of table with a
pen/pencil and a screen opens up that has all my fields
in the body, "record" at the bottom left (to cycle
through all my records) and a bunch of buttons on the
right ("Add New" "Delete" "Restore" "Find" "View Source"
and "Close").

I click on "Find" (a screen opens) and search by one of
the fields (i.e. last name), by clicking on the "find
first" button in the find screen. When the right record
shows up in the "Data Form" in the background, I click
the close button in the "find" box. Now, because there is
no "OK" button on the "Data Form" if I click on "Close",
the record doesn't update to the document. I have to look
at the bottom of the "Data Form" Screen for the record
number (say #192), click "Close" and go to my record
number space in the toolbar, type in the corect one
(192), press enter, and then it updates to my document
after pressing the "ABC" button (Veiw Merged data).

I'm trying to figure out if there is a better way to do
this.

If I click on the "find" button in the toolbar (the
binoculars one) It doesn't find anything. Of course, that
is related to my other post. Essentially, they are a
related issue.

I don't know anything about Macros. All I did was
customize my toolbar from the ToolsCustomize menu.

Any help would be apreciated. Our tech department doesn't
do Office help.




  #4  
Old May 18th, 2004, 02:06 PM
Rachael
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

Ok, see below...


-----Original Message-----
A possibility...

Are your Mail merge main documents (the .doc files) all

connected to the
same template (.dot) (You can find out by opening

the .doc, answering any of
the questions you are encountering, and looking at the

first field in the
Tools|Templates and Addins dialog box.


Ok. I have 100's of files that are mail merge, but only
about 20 are templates (These are government forms that I
cannot modify) and the rest are regular documents in word
that I created (common letters to save time).

I went to toolstemplates and addins and there are no
fields there. What does that mean?

The document and the template can theoretically be

connected to different
data sources. It may be that the message you are seeing

are displayed by
Word because it cannot find the data source attached to

the /template/. If
so, you could consider two things:


(when I open both the templates and the regular word
files, I get the same request box asking for the data
source)

a. open the template file itself (the .dot) and make

sure it is attached to
the data source you want to use. Close the template, and

open it again to
verify that you do not see the question about the data

source.

I open the same templates over and over again daily, and
still get that message.

b. open the template file and make sure it is not a

mail merge main
document (i.e. use the Mail Merge Wizard or the first

button on the
mailmerge toolbar to say that it is a normal word

document. Then save it.


When I try to save the template as a regular .doc
(without removing the mail merge), I can only save it as
a template. If I remove the mail merge, save as a .doc,
then add the mail merge back, it still asks me for the
location of the database.

The problem with doing (b) is that new documents created

using the modified
template will not be attached to a data source and you

will have to attach
each document to your data source when you create it.

I have always been wary of using templates attached to

data sources
precisely because you end up with two connections

whenever you open a
document based on that template. If you are using the

same data source a
lot, it may be better to create a "skeleton" .doc rather

than a proper .dot
template. Connect the skeleton to the data source. Then,

when you want a new
mail merge main document, open the skeleton, save it

immediately with a new
name, and work with the new document. If you need the

other facilities of a
template (styles, macros, autotexts and so on), create

the template, but do
not attach it to a data source. Then base your

skeleton.doc on your template
using Tools|Templates and Addins. WHen you make a copy

of skeleton.doc, the
copy will also be based on the template.


I don't think I understand what you are saying. Does that
mean I have to open the skeleton each time, save as a
different name, and write my letters/documents from
scratch?

In terms of the template, I didn't create the template,
it's government. And it always needs to be attached to
the datasource. I work under a strict government
legislation which legislates which information has to be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of the
job, I have to send out these government forms with every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers (there's
a list of about 20 items) (and we actually get in trouble
if information is missing!!)

Another possibility is that the full pathname of your

data source document
is too long, that Word is not saving the full name, so

that when Word
re-opens the document, it does not have the full name

and has to ask you. I
do not know what the length limit is, if any, but if you

think that might be
a possibility you could make a copy of your data source

in a folder with a
very short name (e.g. c:\a ), then connect to that data

source instead, and
see if that connection persists. Again, if the template

is connected to the
data source, you may also need to modify the template's

connection.

IT's possible it's the name, as the file name
is "Claimant Information Data Base 2.doc", and it's
located in a subfolder of My Documents.

How would I modify the templates connection to the data
source? Can you modify the connection to the data source
for regular .doc files?

Something of note is when I locate manually the data
source file, it opens to My DocumentsMy Data Sources. I
put a shortcut to my data source there to make it easier
to get too, but I don't see why it won't link directly
when it has the same file name.

I hope you can follow all that!


I tried my best. Hopefully the above information is
enough to help me.

Rachael


--
Peter Jamieson

"Rachael" wrote in

message
...
This is a post from last week. I need some help still.
Below is the originals with all the quotes.

Thanks!



Subject: XP asks for database every time

Me: At work I just upgraded from Office 2000 to Office
XP. In
2000 after using a file a couple of times with a mail
merge, it would stop asking me for the database (it

would
know where it is automatically).

I assumed the same would be for XP. I've had Office XP
for about a month now and every time I open a mail

merge
document, it asks me for the location of the database!!
It's driving me nuts!! It never opens to the right
directory, and I have to locate it each time!

Is there a way around this? 99% of my documents are

mail
merged to this same database and I use it constantly
throughout the day. I need a solution.

If there isn't one, I will ask tech to downgrade me
again, because I can't do this every time!

================================================== ======
CM: Hi Rachael,

1. Is this an Access database, or something else?

2. Is the database on your machine, locally, or in the
network?

3. Are you making use of the Recipients dialog box to
choose
records, or does also happen otherwise?

To get you going, you should look at the Word 2002
section
of my website's mail merge FAQ, most especially, the
information on connecting. Try using a DDE or ODBC
connection (if this is Access) and see if things don't
settle down a bit.


================================================== ========


ME: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

The Database is locally on my machine.

I don't know what the recipients dialog box is, but I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one person.

(I work in insurance, and these are the claimants who I
send benefits too)

any help would be great.

================================================== ===

Me: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

CM: OK, if you have to navigate to the database in

order
to relink, then you do know the complete file name?

What
extension does it use? *.xls, *.mdb, or something else?

ME: I don't know what the recipients dialog box is, but
I'm doing files on an individual per recipient basis. I
never have to send the same letter to more than one
person.

CM: Ahhh. OK. This isn't really what mailmerge is meant
for, but people do use it like that :-) So, in order to
choose the single recipient, what do you do, exactly?

================================================== ===

-----Original Message-----
I have no idea if it's an Access Database. It was

already
set when I started here. How could I find that out?

OK, if you have to navigate to the database in order

to
relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something

else?

ME: Ok, it's just a .doc file.


I don't know what the recipients dialog box is, but

I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one

person.

Ahhh. OK. This isn't really what mailmerge is meant

for,
but
people do use it like that :-) So, in order to choose

the
single recipient, what do you do, exactly?


ME: OK. This is the process (sorry if it's long, but I
need to figure this out).

I open the template I want to use in the "open office
document". I open the file and a window pops open that
says: "filename.dot is a mail merge main document. Word
cannot find it's data source, C:\...\filename.doc" and

I
get two options: "Find Data Source" and "Options". I
click on "Find Data Source" and manually go to the
location of my filename.doc data source file. Then my
word document opens. It asks this for EVERY WORD FILE
that has a mail merge.

Then, I click on the the button on my toolbar
for "dataform" which is a picture of table with a
pen/pencil and a screen opens up that has all my fields
in the body, "record" at the bottom left (to cycle
through all my records) and a bunch of buttons on the
right ("Add New" "Delete" "Restore" "Find" "View

Source"
and "Close").

I click on "Find" (a screen opens) and search by one of
the fields (i.e. last name), by clicking on the "find
first" button in the find screen. When the right record
shows up in the "Data Form" in the background, I click
the close button in the "find" box. Now, because there

is
no "OK" button on the "Data Form" if I click

on "Close",
the record doesn't update to the document. I have to

look
at the bottom of the "Data Form" Screen for the record
number (say #192), click "Close" and go to my record
number space in the toolbar, type in the corect one
(192), press enter, and then it updates to my document
after pressing the "ABC" button (Veiw Merged data).

I'm trying to figure out if there is a better way to do
this.

If I click on the "find" button in the toolbar (the
binoculars one) It doesn't find anything. Of course,

that
is related to my other post. Essentially, they are a
related issue.

I don't know anything about Macros. All I did was
customize my toolbar from the ToolsCustomize menu.

Any help would be apreciated. Our tech department

doesn't
do Office help.




.

  #5  
Old May 18th, 2004, 02:07 PM
Rachael
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

All my documents have merge fields, but the binoculars
still don't work. They worked in Office 2000, but not in
Office XP.

I have both .doc and .dot files that have the same
problem.


-----Original Message-----
Are you saving the document after locating the data

source?

Is it actually a template (*.dot) file or just a

document (*.doc) file that
you referred to as a template?

The binocculars button works fine here AS LONG AS THERE

IS A MERGE FIELD IN
THE DOCUMENT.

--
Please post any further questions or followup to the

newsgroups for the
benefit of others who may be interested. Unsolicited

questions forwarded
directly to me will only be answered on a paid

consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Rachael" wrote in

message
...
This is a post from last week. I need some help still.
Below is the originals with all the quotes.

Thanks!



Subject: XP asks for database every time

Me: At work I just upgraded from Office 2000 to Office
XP. In
2000 after using a file a couple of times with a mail
merge, it would stop asking me for the database (it

would
know where it is automatically).

I assumed the same would be for XP. I've had Office XP
for about a month now and every time I open a mail

merge
document, it asks me for the location of the database!!
It's driving me nuts!! It never opens to the right
directory, and I have to locate it each time!

Is there a way around this? 99% of my documents are

mail
merged to this same database and I use it constantly
throughout the day. I need a solution.

If there isn't one, I will ask tech to downgrade me
again, because I can't do this every time!

================================================== ======
CM: Hi Rachael,

1. Is this an Access database, or something else?

2. Is the database on your machine, locally, or in the
network?

3. Are you making use of the Recipients dialog box to
choose
records, or does also happen otherwise?

To get you going, you should look at the Word 2002
section
of my website's mail merge FAQ, most especially, the
information on connecting. Try using a DDE or ODBC
connection (if this is Access) and see if things don't
settle down a bit.


================================================== ========


ME: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

The Database is locally on my machine.

I don't know what the recipients dialog box is, but I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one person.

(I work in insurance, and these are the claimants who I
send benefits too)

any help would be great.

================================================== ===

Me: I have no idea if it's an Access Database. It was
already set when I started here. How could I find that
out?

CM: OK, if you have to navigate to the database in

order
to relink, then you do know the complete file name?

What
extension does it use? *.xls, *.mdb, or something else?

ME: I don't know what the recipients dialog box is, but
I'm doing files on an individual per recipient basis. I
never have to send the same letter to more than one
person.

CM: Ahhh. OK. This isn't really what mailmerge is meant
for, but people do use it like that :-) So, in order to
choose the single recipient, what do you do, exactly?

================================================== ===

-----Original Message-----
I have no idea if it's an Access Database. It was

already
set when I started here. How could I find that out?

OK, if you have to navigate to the database in order

to
relink, then you do know the complete file name? What
extension does it use? *.xls, *.mdb, or something

else?

ME: Ok, it's just a .doc file.


I don't know what the recipients dialog box is, but

I'm
doing files on an individual per recipient basis. I

never
have to send the same letter to more than one

person.

Ahhh. OK. This isn't really what mailmerge is meant

for,
but
people do use it like that :-) So, in order to choose

the
single recipient, what do you do, exactly?


ME: OK. This is the process (sorry if it's long, but I
need to figure this out).

I open the template I want to use in the "open office
document". I open the file and a window pops open that
says: "filename.dot is a mail merge main document. Word
cannot find it's data source, C:\...\filename.doc" and

I
get two options: "Find Data Source" and "Options". I
click on "Find Data Source" and manually go to the
location of my filename.doc data source file. Then my
word document opens. It asks this for EVERY WORD FILE
that has a mail merge.

Then, I click on the the button on my toolbar
for "dataform" which is a picture of table with a
pen/pencil and a screen opens up that has all my fields
in the body, "record" at the bottom left (to cycle
through all my records) and a bunch of buttons on the
right ("Add New" "Delete" "Restore" "Find" "View

Source"
and "Close").

I click on "Find" (a screen opens) and search by one of
the fields (i.e. last name), by clicking on the "find
first" button in the find screen. When the right record
shows up in the "Data Form" in the background, I click
the close button in the "find" box. Now, because there

is
no "OK" button on the "Data Form" if I click

on "Close",
the record doesn't update to the document. I have to

look
at the bottom of the "Data Form" Screen for the record
number (say #192), click "Close" and go to my record
number space in the toolbar, type in the corect one
(192), press enter, and then it updates to my document
after pressing the "ABC" button (Veiw Merged data).

I'm trying to figure out if there is a better way to do
this.

If I click on the "find" button in the toolbar (the
binoculars one) It doesn't find anything. Of course,

that
is related to my other post. Essentially, they are a
related issue.

I don't know anything about Macros. All I did was
customize my toolbar from the ToolsCustomize menu.

Any help would be apreciated. Our tech department

doesn't
do Office help.



.

  #6  
Old May 18th, 2004, 07:13 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Mial merge data base problems

Hello Rachael,

OK, we're in danger of talking at cross-purposes here, so for the moment I'm
not going to try to answer all your questions and points.

Can you please try to do the following:
a. open one of the documents (.doc) that is connected to your data source.
Assuming it has lost its data source in the way you have described,
reconnect it to the data source. But don't save it, and don't do a merge.
b. Click File|Save As, and use the "Save as Type" drop-down list at the
bottom of the dialog box to select the file type "Web Page (*.htm, *.html).
The type a name such as myfile.htm in the File Name box. Notice where Word
is saving this file, and click Save.
c. Go into Word Tools|Options|General and check "Confirm conversions at
open".
d. re-open myfile.htm (e.g. from the list of recently opened files in the
Word FIle menu. You should see a dialog box titled "Convert file". Select
"Plain Text" and click OK.
e. you should now see the "source code" of your document in HTML format. It
won't look anything like your actual document, but will probably start

html xmlns="urn..."

Look down the document about 30 lines or so and you should see lines that
show various pieces of information about the mail merge data source, e.g.
the lines starting

w:MailMergeMainDocType
w:MailMergeQueryString

etc. Can you please tell us what the few lines after

w:MailMergeQueryString

and

w:MailMergeDataSource

say?

And/or cut and paste these lines in a message and post them here.

I am expecting the MailMergeQueryString to look something like

SELECT * FROM the full path name of your data source document

and the MailMergeDataSource to look lke

HRef="the full path name of your data source"

If there is a problem with the path name being too long, you may see that
the name is truncated in one or the other of those texts. If neither is
truncated, thepath name length probably isn't the problem.

Finally,

In terms of the template, I didn't create the template,
it's government. And it always needs to be attached to
the datasource. I work under a strict government
legislation which legislates which information has to be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of the
job, I have to send out these government forms with every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers (there's
a list of about 20 items) (and we actually get in trouble
if information is missing!!)


OK, it's clear that if you have to use a specific predefined template then
if there is a problem with the template then it may be impossible to solve
unless someone is allowed to change it. But I get the impression from what
you have said that you are allowed to change some aspects of a template. For
example, if the template is connected to a data source, it will be connected
to a specific file in a specific location in your folders. But if you have a
typical WIndows configuration where your documents are stored in My
Documents, the full path name of /your/ "My Documents" folder will almost
certainly contain some form of logon or user name. Since that name will be
different for each user, each user's copy of the template would either have
to be a bit different, or would (probably) have to have a macro that would
work out the full path name of the data source.

Peter Jamieson




  #7  
Old May 18th, 2004, 08:09 PM
Rachael
external usenet poster
 
Posts: n/a
Default Mail merge data base problems

Wow. That is quite neat! I wouldn't have thought of doing
that.

Here is what I got:

w:MailMergeQueryStringSELECT * FROM C:\Documents and
Settings\ptorrxc\My Documents\Rachael\Claimant
Information Data Base 2.doc/w:MailMergeQueryString
w:MailMergeDataSource
HRef="C:\Documents and Settings\ptorrxc\My
Documents\Rachael\Claimant Information Data Base
2.doc"/w:MailMergeDataSource

I tried it with both the .doc files and the .dot files
(my government files), and both had the same thing
written.

I tried it with the one and only file I know that does
not ask me for the database each time, and it was the
same as well.

Any other ideas?



-----Original Message-----
Hello Rachael,

OK, we're in danger of talking at cross-purposes here,

so for the moment I'm
not going to try to answer all your questions and points.

Can you please try to do the following:
a. open one of the documents (.doc) that is connected

to your data source.
Assuming it has lost its data source in the way you have

described,
reconnect it to the data source. But don't save it, and

don't do a merge.
b. Click File|Save As, and use the "Save as Type" drop-

down list at the
bottom of the dialog box to select the file type "Web

Page (*.htm, *.html).
The type a name such as myfile.htm in the File Name box.

Notice where Word
is saving this file, and click Save.
c. Go into Word Tools|Options|General and

check "Confirm conversions at
open".
d. re-open myfile.htm (e.g. from the list of recently

opened files in the
Word FIle menu. You should see a dialog box

titled "Convert file". Select
"Plain Text" and click OK.
e. you should now see the "source code" of your

document in HTML format. It
won't look anything like your actual document, but will

probably start

html xmlns="urn..."

Look down the document about 30 lines or so and you

should see lines that
show various pieces of information about the mail merge

data source, e.g.
the lines starting

w:MailMergeMainDocType
w:MailMergeQueryString

etc. Can you please tell us what the few lines after

w:MailMergeQueryString

and

w:MailMergeDataSource

say?

And/or cut and paste these lines in a message and post

them here.

I am expecting the MailMergeQueryString to look

something like

SELECT * FROM the full path name of your data source

document

and the MailMergeDataSource to look lke

HRef="the full path name of your data source"

If there is a problem with the path name being too long,

you may see that
the name is truncated in one or the other of those

texts. If neither is
truncated, thepath name length probably isn't the

problem.

Finally,

In terms of the template, I didn't create the template,
it's government. And it always needs to be attached to
the datasource. I work under a strict government
legislation which legislates which information has to

be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of the
job, I have to send out these government forms with

every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers

(there's
a list of about 20 items) (and we actually get in

trouble
if information is missing!!)


OK, it's clear that if you have to use a specific

predefined template then
if there is a problem with the template then it may be

impossible to solve
unless someone is allowed to change it. But I get the

impression from what
you have said that you are allowed to change some

aspects of a template. For
example, if the template is connected to a data source,

it will be connected
to a specific file in a specific location in your

folders. But if you have a
typical WIndows configuration where your documents are

stored in My
Documents, the full path name of /your/ "My Documents"

folder will almost
certainly contain some form of logon or user name. Since

that name will be
different for each user, each user's copy of the

template would either have
to be a bit different, or would (probably) have to have

a macro that would
work out the full path name of the data source.

Peter Jamieson




  #8  
Old May 18th, 2004, 11:29 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Mail merge data base problems

Any other ideas?

None that are likely to lead straight away to The Answer, but just out of
interest, if you uncheck Word Tools|Options|General|"Confirm conversion at
open", then open the .htm version of the file, does Word still complain that
it cannot find the data source?

Wow. That is quite neat! I wouldn't have thought of doing
that.


I got the idea from Cindy Meister.

--
Peter Jamieson

"Rachael" wrote in message
...
Wow. That is quite neat! I wouldn't have thought of doing
that.

Here is what I got:

w:MailMergeQueryStringSELECT * FROM C:\Documents and
Settings\ptorrxc\My Documents\Rachael\Claimant
Information Data Base 2.doc/w:MailMergeQueryString
w:MailMergeDataSource
HRef="C:\Documents and Settings\ptorrxc\My
Documents\Rachael\Claimant Information Data Base
2.doc"/w:MailMergeDataSource

I tried it with both the .doc files and the .dot files
(my government files), and both had the same thing
written.

I tried it with the one and only file I know that does
not ask me for the database each time, and it was the
same as well.

Any other ideas?



-----Original Message-----
Hello Rachael,

OK, we're in danger of talking at cross-purposes here,

so for the moment I'm
not going to try to answer all your questions and points.

Can you please try to do the following:
a. open one of the documents (.doc) that is connected

to your data source.
Assuming it has lost its data source in the way you have

described,
reconnect it to the data source. But don't save it, and

don't do a merge.
b. Click File|Save As, and use the "Save as Type" drop-

down list at the
bottom of the dialog box to select the file type "Web

Page (*.htm, *.html).
The type a name such as myfile.htm in the File Name box.

Notice where Word
is saving this file, and click Save.
c. Go into Word Tools|Options|General and

check "Confirm conversions at
open".
d. re-open myfile.htm (e.g. from the list of recently

opened files in the
Word FIle menu. You should see a dialog box

titled "Convert file". Select
"Plain Text" and click OK.
e. you should now see the "source code" of your

document in HTML format. It
won't look anything like your actual document, but will

probably start

html xmlns="urn..."

Look down the document about 30 lines or so and you

should see lines that
show various pieces of information about the mail merge

data source, e.g.
the lines starting

w:MailMergeMainDocType
w:MailMergeQueryString

etc. Can you please tell us what the few lines after

w:MailMergeQueryString

and

w:MailMergeDataSource

say?

And/or cut and paste these lines in a message and post

them here.

I am expecting the MailMergeQueryString to look

something like

SELECT * FROM the full path name of your data source

document

and the MailMergeDataSource to look lke

HRef="the full path name of your data source"

If there is a problem with the path name being too long,

you may see that
the name is truncated in one or the other of those

texts. If neither is
truncated, thepath name length probably isn't the

problem.

Finally,

In terms of the template, I didn't create the template,
it's government. And it always needs to be attached to
the datasource. I work under a strict government
legislation which legislates which information has to

be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of the
job, I have to send out these government forms with

every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers

(there's
a list of about 20 items) (and we actually get in

trouble
if information is missing!!)


OK, it's clear that if you have to use a specific

predefined template then
if there is a problem with the template then it may be

impossible to solve
unless someone is allowed to change it. But I get the

impression from what
you have said that you are allowed to change some

aspects of a template. For
example, if the template is connected to a data source,

it will be connected
to a specific file in a specific location in your

folders. But if you have a
typical WIndows configuration where your documents are

stored in My
Documents, the full path name of /your/ "My Documents"

folder will almost
certainly contain some form of logon or user name. Since

that name will be
different for each user, each user's copy of the

template would either have
to be a bit different, or would (probably) have to have

a macro that would
work out the full path name of the data source.

Peter Jamieson






  #9  
Old May 19th, 2004, 01:38 PM
external usenet poster
 
Posts: n/a
Default Mail merge data base problems

I got rid of "confirm conversion at open" and it does not
ask for the data source for the .htm version.

Odd.

I will try fiddling around and see if I can change
anything. Maybe I'll try taking the mail merge out,
saving the .dot as .doc and re-merging it, then saving
it. Maybe that will help.


-----Original Message-----
Any other ideas?


None that are likely to lead straight away to The

Answer, but just out of
interest, if you uncheck Word

Tools|Options|General|"Confirm conversion at
open", then open the .htm version of the file, does Word

still complain that
it cannot find the data source?

Wow. That is quite neat! I wouldn't have thought of

doing
that.


I got the idea from Cindy Meister.

--
Peter Jamieson

"Rachael" wrote in

message
...
Wow. That is quite neat! I wouldn't have thought of

doing
that.

Here is what I got:

w:MailMergeQueryStringSELECT * FROM C:\Documents

and
Settings\ptorrxc\My Documents\Rachael\Claimant
Information Data Base 2.doc/w:MailMergeQueryString
w:MailMergeDataSource
HRef="C:\Documents and Settings\ptorrxc\My
Documents\Rachael\Claimant Information Data Base
2.doc"/w:MailMergeDataSource

I tried it with both the .doc files and the .dot files
(my government files), and both had the same thing
written.

I tried it with the one and only file I know that does
not ask me for the database each time, and it was the
same as well.

Any other ideas?



-----Original Message-----
Hello Rachael,

OK, we're in danger of talking at cross-purposes here,

so for the moment I'm
not going to try to answer all your questions and

points.

Can you please try to do the following:
a. open one of the documents (.doc) that is connected

to your data source.
Assuming it has lost its data source in the way you

have
described,
reconnect it to the data source. But don't save it,

and
don't do a merge.
b. Click File|Save As, and use the "Save as Type"

drop-
down list at the
bottom of the dialog box to select the file type "Web

Page (*.htm, *.html).
The type a name such as myfile.htm in the File Name

box.
Notice where Word
is saving this file, and click Save.
c. Go into Word Tools|Options|General and

check "Confirm conversions at
open".
d. re-open myfile.htm (e.g. from the list of recently

opened files in the
Word FIle menu. You should see a dialog box

titled "Convert file". Select
"Plain Text" and click OK.
e. you should now see the "source code" of your

document in HTML format. It
won't look anything like your actual document, but

will
probably start

html xmlns="urn..."

Look down the document about 30 lines or so and you

should see lines that
show various pieces of information about the mail

merge
data source, e.g.
the lines starting

w:MailMergeMainDocType
w:MailMergeQueryString

etc. Can you please tell us what the few lines after

w:MailMergeQueryString

and

w:MailMergeDataSource

say?

And/or cut and paste these lines in a message and post

them here.

I am expecting the MailMergeQueryString to look

something like

SELECT * FROM the full path name of your data source

document

and the MailMergeDataSource to look lke

HRef="the full path name of your data source"

If there is a problem with the path name being too

long,
you may see that
the name is truncated in one or the other of those

texts. If neither is
truncated, thepath name length probably isn't the

problem.

Finally,

In terms of the template, I didn't create the

template,
it's government. And it always needs to be attached

to
the datasource. I work under a strict government
legislation which legislates which information has

to
be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of

the
job, I have to send out these government forms with

every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers

(there's
a list of about 20 items) (and we actually get in

trouble
if information is missing!!)

OK, it's clear that if you have to use a specific

predefined template then
if there is a problem with the template then it may be

impossible to solve
unless someone is allowed to change it. But I get the

impression from what
you have said that you are allowed to change some

aspects of a template. For
example, if the template is connected to a data

source,
it will be connected
to a specific file in a specific location in your

folders. But if you have a
typical WIndows configuration where your documents are

stored in My
Documents, the full path name of /your/ "My Documents"

folder will almost
certainly contain some form of logon or user name.

Since
that name will be
different for each user, each user's copy of the

template would either have
to be a bit different, or would (probably) have to

have
a macro that would
work out the full path name of the data source.

Peter Jamieson






.

  #10  
Old May 19th, 2004, 02:00 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Mail merge data base problems

Going back a few steps, we another experiment you can try is this:
a. open one of the .doc documents that has the problem.
b. go through all the steps necessary to reconnect
c. use Tools|Templates and Add-ins to see what template the document is
attached to. The name, or pathname, of the template should be in the first
textbox (what I previously called a field) to the left of a Browse...
button. If that field is greyed out, your .doc is actually a template. But
assuming it is not, use the browse button to look for the Normal template
and attach that instead.
d. close the .doc
e. re-open it. Do you still see the problem?
--
Peter Jamieson

wrote in message
...
I got rid of "confirm conversion at open" and it does not
ask for the data source for the .htm version.

Odd.

I will try fiddling around and see if I can change
anything. Maybe I'll try taking the mail merge out,
saving the .dot as .doc and re-merging it, then saving
it. Maybe that will help.


-----Original Message-----
Any other ideas?


None that are likely to lead straight away to The

Answer, but just out of
interest, if you uncheck Word

Tools|Options|General|"Confirm conversion at
open", then open the .htm version of the file, does Word

still complain that
it cannot find the data source?

Wow. That is quite neat! I wouldn't have thought of

doing
that.


I got the idea from Cindy Meister.

--
Peter Jamieson

"Rachael" wrote in

message
...
Wow. That is quite neat! I wouldn't have thought of

doing
that.

Here is what I got:

w:MailMergeQueryStringSELECT * FROM C:\Documents

and
Settings\ptorrxc\My Documents\Rachael\Claimant
Information Data Base 2.doc/w:MailMergeQueryString
w:MailMergeDataSource
HRef="C:\Documents and Settings\ptorrxc\My
Documents\Rachael\Claimant Information Data Base
2.doc"/w:MailMergeDataSource

I tried it with both the .doc files and the .dot files
(my government files), and both had the same thing
written.

I tried it with the one and only file I know that does
not ask me for the database each time, and it was the
same as well.

Any other ideas?



-----Original Message-----
Hello Rachael,

OK, we're in danger of talking at cross-purposes here,
so for the moment I'm
not going to try to answer all your questions and

points.

Can you please try to do the following:
a. open one of the documents (.doc) that is connected
to your data source.
Assuming it has lost its data source in the way you

have
described,
reconnect it to the data source. But don't save it,

and
don't do a merge.
b. Click File|Save As, and use the "Save as Type"

drop-
down list at the
bottom of the dialog box to select the file type "Web
Page (*.htm, *.html).
The type a name such as myfile.htm in the File Name

box.
Notice where Word
is saving this file, and click Save.
c. Go into Word Tools|Options|General and
check "Confirm conversions at
open".
d. re-open myfile.htm (e.g. from the list of recently
opened files in the
Word FIle menu. You should see a dialog box
titled "Convert file". Select
"Plain Text" and click OK.
e. you should now see the "source code" of your
document in HTML format. It
won't look anything like your actual document, but

will
probably start

html xmlns="urn..."

Look down the document about 30 lines or so and you
should see lines that
show various pieces of information about the mail

merge
data source, e.g.
the lines starting

w:MailMergeMainDocType
w:MailMergeQueryString

etc. Can you please tell us what the few lines after

w:MailMergeQueryString

and

w:MailMergeDataSource

say?

And/or cut and paste these lines in a message and post
them here.

I am expecting the MailMergeQueryString to look
something like

SELECT * FROM the full path name of your data source
document

and the MailMergeDataSource to look lke

HRef="the full path name of your data source"

If there is a problem with the path name being too

long,
you may see that
the name is truncated in one or the other of those
texts. If neither is
truncated, thepath name length probably isn't the
problem.

Finally,

In terms of the template, I didn't create the

template,
it's government. And it always needs to be attached

to
the datasource. I work under a strict government
legislation which legislates which information has

to
be
on which form and we are not allowed to change it
(unfortunately). As well, because of the nature of

the
job, I have to send out these government forms with
every
piece of mail I send. I even have a legislation that
tells me what items HAVE to be on my fax covers
(there's
a list of about 20 items) (and we actually get in
trouble
if information is missing!!)

OK, it's clear that if you have to use a specific
predefined template then
if there is a problem with the template then it may be
impossible to solve
unless someone is allowed to change it. But I get the
impression from what
you have said that you are allowed to change some
aspects of a template. For
example, if the template is connected to a data

source,
it will be connected
to a specific file in a specific location in your
folders. But if you have a
typical WIndows configuration where your documents are
stored in My
Documents, the full path name of /your/ "My Documents"
folder will almost
certainly contain some form of logon or user name.

Since
that name will be
different for each user, each user's copy of the
template would either have
to be a bit different, or would (probably) have to

have
a macro that would
work out the full path name of the data source.

Peter Jamieson





.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.