I usually attach .xls files as data sources but have tried the imbedded data source using the wizard and have used Word tables just to see if one type of data source would activate the "View Source" button but to no avail
----- Cindy M -WordMVP- wrote: ----
Hi FrankM,
> After attaching a merge file in Word 2002 and click
> on "Mail Merge Recipients",then "Edit", the "View Source"
> button that would allow viewing the merge fields in
> tables is dimmed
> How can I activate this feature
This feature will only work for certain kinds of data sources. So our first question must be: what type of file is your data source
Cindy Meiste
INTER-Solutions, Switzerlan
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003
http://www.word.mvps.or
This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-
Hi =?Utf-8?B?RnJhbmtN?=,
> I usually attach .xls files as data sources but have tried the imbedded data source using the wizard and have used Word tables just to see if one type of data source would
activate the "View Source" button but to no avail.
>
Yes, the "View Source" really only works with a data source created by Word, and in Word
2002 and later this would be an Access database (*.mdb), but only one created by Word.
You can look at Word table or text file data in a form by actually opening that file in
Word and using the "Data form" toolbar button.
If you're used to being able to work in the Excel file during a merge in earlier versions
of Word, creating a DDE rather than OLE DB link to the data might help you. Activate
"Confirm conversions on open" in Tools/Options/General, then select the data source
file, choosing DDE when prompted.
> > After attaching a merge file in Word 2002 and click
> > on "Mail Merge Recipients",then "Edit", the "View Source"
[quoted text clipped - 3 lines]
> >
> This feature will only work for certain kinds of data sources. So our first question must be: what type of file is your data source?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)
FrankM - 16 Apr 2004 01:51 GMT
Cindy
Thank you for your interest. Since I do not have Access on my computer I will not have the luxury of viewing the data source. My database is Alpha 5 and I export my records into Excel 4.0 files and merge them into Word. I would like to have Word 97 back
FrankM
Cindy M -WordMVP- - 16 Apr 2004 10:53 GMT
Hi =?Utf-8?B?RnJhbmtN?=,
> Thank you for your interest. Since I do not have Access on my computer I will not have the luxury of viewing the data source. My database is Alpha 5 and I export my
records into Excel 4.0 files and merge them into Word. I would like to have Word 97
back.
The Access database Word mail merge can look at is one Word creates; Access does not
have to be present on the system.
As I mentioned in my last message (if you'd read it carefully to the end), you can get
the functionality back that you had in Word 97.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)
FrankM - 18 Apr 2004 03:11 GMT
Cindy
Your latest suggestion will work. I can edit my records in Excel
Thanks for your help
FrankM