It just occurred to me that maybe it is asking you for a source each time because you are not actually performing the merge. Don't forget... previewing the merge is not merging.

I am attaching my template Petition.dot and also the data source which is one table in an Access database. Maybe you can see what might be wrong. Every time I record a macro and try to run it, it tells me the "requested object is not available" and is not finding the data source.

If I manually double click Petition.dot, then it says it is going to run the SQL and finds the data source. When I click Merge to New document, it wants to save the connection to the data source.

Here is my macro:
Sub Test()
'
' Test Macro
' Macro recorded 6/15/2010
'
Documents.Add Template:= _
"C:\Bergemann\Forfeiture\WordMailMerge\Petition.do t", NewTemplate:=False, _
DocumentType:=0
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
Windows("Letters1").Activate
End Sub

Thank you.

Brandi

Attached Files

	Petition.zip (6.4 KB, 13 views)
	Forfeiture.zip (13.5 KB, 11 views)

hi, I have been swamped here at work today, but will find time to have a look hopefully before the end of the day!

I am stumped. I believe I have done everything you said.
Nothing seems to work as I need it to.

1. I need to open a document based on a template from a network location. Is this possible? It cannot be placed in the Templates folder.

Currently I am opening a document by double clicking the dot file. A document opens and asks to link to the SQL source. When I choose Merge to New Document, Letters1.doc opens. This is the document I save. When I open Letters1.doc, it still asks to link to the SQL source, and then it displays the document with the saved data (no matter what the source currently is) If I was to choose File, New, Templates on My Computer, I don't see how I can point to the dot file on my network drive.

2. Once I have Merged to a New document and saved the new document' I don't want to be prompted to open the SQL source when I open that saved document.

3. I am trying to attach macros to buttons that will open a new document based on my template. The macros keep saying "requested object is not available" and yet if I double click the dot file, I am prompted for the data source and a new document opens.

Should I be able to do what I want to do?

Thank you.
Brandi

If you are tired of helping me just say so and I can start a new post.