Deleting the merge file from within VBA   

Is it possible to unlink and delete the merge file (an excel spreadsheet) 
after the merge-to-new-file has been accomplished.  I can't seem to get 
around the "busy file" problem.

BruceP

date: Sat, 29 Oct 2005 07:05:52 GMT   author:   Support Team

Re: Deleting the merge file from within VBA   

How are you trying to do it?

When the mailmerge main document is the activedocument, the following should 
work

ActiveDocument.MailMerge.DataSource.Close

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

"Support Team"  wrote in message 
news:kbF8f.3625$Hj2.2601@news-server.bigpond.net.au...
> Is it possible to unlink and delete the merge file (an excel spreadsheet) 
> after the merge-to-new-file has been accomplished.  I can't seem to get 
> around the "busy file" problem.
>
> BruceP
>

date: Sat, 29 Oct 2005 17:34:44 +0200   author:   Doug Robbins - Word MVP