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 / February 2007

Tip: Looking for answers? Try searching our database.

delete mail merge table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
prmagpie - 02 Feb 2007 20:46 GMT
I have created several tables from Excel which then transfer over to word to
be used in mail merge.  I would like to delete some of the tables which
display on the word side of the application.  There appears to be no method
of doing that.  Is there any way that this can be done?
Doug Robbins - Word MVP - 03 Feb 2007 07:49 GMT
How do these tables "transfer over to Word"?  Please describe in more detail
what you originally did to achieve that.

Signature

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

>I have created several tables from Excel which then transfer over to word
>to
> be used in mail merge.  I would like to delete some of the tables which
> display on the word side of the application.  There appears to be no
> method
> of doing that.  Is there any way that this can be done?
prmagpie - 27 Feb 2007 16:25 GMT
I have followed the instructions in excel to create the mail merge tables.  
When you then go to Word and click on the source excel document the tables
present themselves.  I have deleted all tables on the Excel side but when I
go to word and click on the source excel document every mail merge table that
I have ever created is there.  Since I have added information to the Excel
document I would like to create new tables for mail merge and delete the old
ones.  I cannot find a method to get the tables out of the Word side of
mailmerge.

> How do these tables "transfer over to Word"?  Please describe in more detail
> what you originally did to achieve that.
[quoted text clipped - 5 lines]
> > method
> > of doing that.  Is there any way that this can be done?
Graham Mayor - 28 Feb 2007 07:38 GMT
What you have written makes no sense at all.
Where are you seeing the 'tables'?
If you open attempt to add a data source to a Word mail merge, by default it
will seek that data source in the 'My Data Sources' folder. This folder like
any other folder can contain a variety of files.
Maybe http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  will help by
giving you an overview of mail merge?

Signature

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

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

> I have followed the instructions in excel to create the mail merge
> tables. When you then go to Word and click on the source excel
[quoted text clipped - 22 lines]
>>> to be no method
>>> of doing that.  Is there any way that this can be done?
Peter Jamieson - 28 Feb 2007 08:23 GMT
It sounds as if you are creating each new mail merge data source in the same
Excel workbook. If so, you will have multiple Excel worksheets in that
workbook and you will see one "tab" for each worksheet near the bottom of
the Excel window when you have the workbook open.

When you try to open the workbook in Word as a data source, Word lists all
the worksheets in the workbook.

If that is what is happening, what you should probably do is
a. start creating each new merge data source in a new Excel workbook in
your My Data Sources folder (or wherever you want)
b. when you have finished using that Excel workbook, move it out of the My
Data Sources" folder so that it is no longer available for selection, or
delete it if you really do not need it any more.

If you want to tidy up your existing workbook, you can right-click on each
worksheet's tab and delete that sheet. If you need to keep the data, you can
export the sheet's data first.

Peter Jamieson

>I have followed the instructions in excel to create the mail merge tables.
> When you then go to Word and click on the source excel document the tables
[quoted text clipped - 19 lines]
>> > method
>> > of doing that.  Is there any way that this can be done?
 
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.