Mail Merge with Excel

[David Cornwell]

I'm using office XP and am trying to use mail merge with
an Excel spreadsheet. Everything is OK except for when I
click to edit the data source the edit button is greyed
out. Is there a way that I can edit/add data from this
point ie: from the word mail merge wizard, or as the data
is stored in Excel do I have to edit/add directly from
Excel?
Any help is much appreciated.
David

 

[Doug Robbins - Word MVP]

Hi David,

If you want to be able to do that, you must connect to the datasource using
DDE. If that option is not presented when attaching the datasource, from
the Tools menu in Word, select Options and then go to the General tab and
check the box next to "Confirm conversion at Open".

--
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