[Archana Paldana]

while saving OLEObject from the SQL DB to a physical file(.doc) it opens the MS Word and displays the error
?word could not merge the main document with the data source because the data records were empty?

Used the following code:
OLE1.object.SaveAs strDir & "\" & strFileName & ".doc"

Need to save it silently without opening anything




Louverri wrote:

Remove datasource from Word document
02-Jun-08

Thanks !!!!

"Doug Robbins - Word MVP" wrote:

Previous Posts In This Thread:

On Friday, May 30, 2008 1:11 PM
Louverri wrote:

Remove datasource from Word document
I want to remove the recipients and the datasource completely from a Word
document - previously used in an aborted attempt to mail merge the document
to email (the e-mail field does not appear in the contacts list - anotehr
open question on this).

How can I return the document to a normal one - without the datasource box
coming up every time you open it.

I cannot mail merge from Outlook (my plan b) while this is attached.

Thanks
Lou

On Friday, May 30, 2008 6:52 PM
Doug Robbins - Word MVP wrote:

Open your mail merge main document and then from the Mailings tab, Click on
Open your mail merge main document and then from the Mailings tab, Click on
the Start Mail Merge pulldown and then on Normal Word Document from the list
of available choices. Then save the document.

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

"Louverril" wrote in message
...

On Saturday, May 31, 2008 7:53 AM
Walter Briscoe wrote:

Remove datasource from Word document
In message of Sat, 31 May 2008
08:52:40 in microsoft.public.word.mailmerge.fields, Doug Robbins - Word
MVP writes

I infer this advice is relevant to Word 2007. (I know of no Word 2003
Mailings tab.) What is the corresponding advice for Word 2003?
--
Walter Briscoe

On Saturday, May 31, 2008 8:26 AM
Doug Robbins - Word MVP wrote:

Yes, the post to which I was responding concerned 2007 (based on another post
Yes, the post to which I was responding concerned 2007 (based on another
post from the same person.

In Word 2003, it would be somewhere in ToolsLetters and MailingsMail
Merge. Sorry, I do not have access to a machine with 2003 on it at the
moment so cannot give you more precise instructions.

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

"Walter Briscoe" wrote in message
...

On Saturday, May 31, 2008 9:51 AM
Graham Mayor wrote:

Remove datasource from Word document
It's also on the merge toolbar -
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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



Doug Robbins - Word MVP wrote:

On Monday, June 02, 2008 9:09 AM
Louverri wrote:

Remove datasource from Word document
Thanks !!!!

"Doug Robbins - Word MVP" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
IIS 7.0 Extensionless UrlRewriting (Short urls)
http://www.eggheadcafe.com/tutorials...nless-url.aspx