Peter,
I'm trying to understand your directions... please bear with me, I don't
know a lot about how any of this works... I've sort of hacked my way through
Word and discovered how to do things, but delving into things like "tables"
is beyond me.
But I'm not totally clueless, so if you could give me some clarification?
You said, "If your previous "databases" were created in the older version of
Mail
Merge, then they are probably tables in Word documents - you can open those
documents and edit them directly in Word"
How do I do this exactly? For instance, I'm looking at the screen and I see
a whole page full of:
«FirstName» «LastName»
«Address1»
«City», «State» «PostalCode»
«Next Record»«FirstName» «LastName»
«Address1»
«City», «State» «PostalCode»
From there, I usually click on the icon for "Mail Merge Recipients" then
Edit and I keep adding contacts. But the things I need to add are secondary
address, phone number, etc to the fields I already have (like name, primary
add, etc.).
Any help you can give is so appreciated.
Thanks,
April
"Peter Jamieson" wrote:
I have to first answer "yes" to a pop up that asks, "Opening
this document will run the following SQL command: Select *From (file's
location). Data from your database will be placed in the document. Do
you
want to continue?"
There's a discussion about this that started a few days ago with a message
titled
" KB 825765 - just making sure..."
which you might want to read. However, the simple workaround is to make the
registry change described in the following Knowledgebase article:
http://support.microsoft.com/kb/825765
I click yes, then I get into the database, but when I click on Edit, I
cannot find a way to add additional fields to what I already have.
I notice that when I create a new Mail Merge database in Word 2003, I can
click on Edit and add fields, but not, seemingly, from databases saved
from
before the Word update.
Yes, the rules have changed /and/ even when the Edit button is not greyed
out it does not necessarily do what you expect.
Can anyone advise me on how to customize (add fields) to my old Mail Merge
stuff?
If your previous "databases" were created in the older version of Mail
Merge, then they are probably tables in Word documents - you can open those
documents and edit them directly in Word. Although you may find that Word
still successfully notices the changes you make without saving/closing the
data source document, I would save and close anyway these days.
For almost all data sources you have to open the source in the "creating
application", e.g. open a .mdb in Access, a .xls in Excel and so on. The new
format used by Word when you create a list in mailmerge is an "Office
Address List" which is a .mdb file in a particular format that Word
recognises and lets you edit. In some cases you may find that you cannot
have your Mail merge Main document and the data source open at the same time
(e.g. probably with Excel worksheets).
Peter Jamieson
"April B." wrote in message
...
We updated to Word 2003 and when I try to go back into previously saved
Mail
Merge databases, I have to first answer "yes" to a pop up that asks,
"Opening
this document will run the following SQL command: Select *From (file's
location). Data from your database will be placed in the document. Do
you
want to continue?"
I click yes, then I get into the database, but when I click on Edit, I
cannot find a way to add additional fields to what I already have.
I notice that when I create a new Mail Merge database in Word 2003, I can
click on Edit and add fields, but not, seemingly, from databases saved
from
before the Word update.
Can anyone advise me on how to customize (add fields) to my old Mail Merge
stuff?