Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2006

Tip: Looking for answers? Try searching our database.

Merginging into Word 2003 from Access/SQL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RSMITH - 02 Jun 2006 14:14 GMT
lright I know things were always better in the past but in this case
Mailmerge in Word 2000 worked brilliantly and simply.  The same cannot be
said for 2003.  It would appear that you cannot turn the wizard off and use
the same method that 200 did so well.  Does anyone know why when I link a
table from SQL into Access 2000 and then attempt to merge into a W2003
document all the tables are transposed (postcode field shows data from the
address field, etc.)  Better still, does anyone know if the Mailmerge wizard
can be turned off?
Graham Mayor - 02 Jun 2006 15:28 GMT
You can certainly use the method you used in Word 2000 including the use of
the mail merge helper if you want, and you don't have to use the merge
wizard. The only thing that has really changed is the default method of
connection to the data, and even that isn't insurmountable.

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> lright I know things were always better in the past but in this case
> Mailmerge in Word 2000 worked brilliantly and simply.  The same
[quoted text clipped - 4 lines]
> (postcode field shows data from the address field, etc.)  Better
> still, does anyone know if the Mailmerge wizard can be turned off?
Peter Jamieson - 02 Jun 2006 15:41 GMT
> Does anyone know why when I link a
> table from SQL into Access 2000 and then attempt to merge into a W2003
> document all the tables are transposed (postcode field shows data from the
> address field, etc.)

I don't, but...

> Better still, does anyone know if the Mailmerge wizard
> can be turned off?

You don't have to use it.

You can enable the Mailmerge toolbar (it doesn't appear/disappear the way it
did in Word 2000) using Tools|Customize.

To get the old Mail merge helper back, go into Tools|Customize|Commands,
select category All Commands, then locate MailMergeHelper in the right hand
column and drag it to a toolbar (e.g. the MailMerge Toolbar).

However, none of those things will get back the old default connection
mechanism (DDE) - to do that, check Word Tools|Options|General|Confirm
conversion at open, try going through the connection process again, and
select DDE when offered, or ODBC, if that is what you used before (in which
case you would have used the Select Method checkbox in the old Open Data
Source dialog)

That may be enough to make things work right again, but if you have not yet
tried reconnecting using the new method (OLEDB) I think it is worth one more
go.

Peter Jamieson

> lright I know things were always better in the past but in this case
> Mailmerge in Word 2000 worked brilliantly and simply.  The same cannot be
[quoted text clipped - 6 lines]
> wizard
> can be turned off?
RSMITH - 05 Jun 2006 15:50 GMT
Peter - many thanks - that solved the problem of the new wizard perfectly -
co-incidently it has resolved the problem of data being transposed into the
wrong column.  
Roger Smith

> > Does anyone know why when I link a
> > table from SQL into Access 2000 and then attempt to merge into a W2003
[quoted text clipped - 38 lines]
> > wizard
> > can be turned off?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.