Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel worksheets
Hi there,
I am trying to merge an excel spreedsheet that utilizes 3 worksheet for various calculations, however I only want to import the first worksheet into the mail merge. It seems that word is automatically importing all 3 worksheets creating. Any ideas? THANKS PEOPLES |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel worksheets
In Word, from the Tools menu, select Options and then go to the General tab
and check the box against the item "Confirm conversions at open." After you do that, when you attach the data source to the mail merge main document, you will be given a choice of the method by which the attachment should be made. Select the DDE option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "BANKBOY" wrote in message ... Hi there, I am trying to merge an excel spreedsheet that utilizes 3 worksheet for various calculations, however I only want to import the first worksheet into the mail merge. It seems that word is automatically importing all 3 worksheets creating. Any ideas? THANKS PEOPLES |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging multiple rows in Excel to one word document. | Mailmerge | |||
Linking multiple excel worksheets into Word | Microsoft Word Help | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge | |||
Insert Excel Worksheets into Word Document | Microsoft Word Help |