Mail Merge with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Cornwell - 13 Jun 2004 22:43 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2004 22:57 GMT

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

Signature

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

> I'm using office XP and am trying to use mail merge with
> an Excel spreadsheet. Everything is OK except for when I
[quoted text clipped - 5 lines]
> Any help is much appreciated.
> David

Reply to this Message