Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2010, 08:08 AM
Kimberly Kimberly is offline Merge to New Document - saved letter continues to ask for SQL source Windows 7 Merge to New Document - saved letter continues to ask for SQL source Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Oh yeah, I forgot you are also having a problem with .Destination, so change the macro to this instead:



Code:
 
Sub MergePetition()
 
Documents.Add Template:= _
"C:\Bergemann\Forfeiture\WordMailMerge\Petition.dot" _
, NewTemplate:=False, DocumentType:=0
With ActiveDocument.MailMerge
.Destination = 0
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
With ActiveDocument
.AttachedTemplate = "C:\YourPathToTheNormalTemplate\Normal.dot"
End With
End Sub
AND, I believe it will work fine with actually changing the fake path to Normal.dot to the real path. (We just want to unattach the Petition template.)

Last edited by Kimberly; 06-16-2010 at 08:10 AM. Reason: clarification
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge to New Document - saved letter continues to ask for SQL source Lost Word Document and cant find it!!! I saved it but it ISNT there!! APAV Word 9 10-09-2017 01:17 PM
Outlook continues to run after I close it Shawn76 Outlook 1 08-23-2010 12:30 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM
Auto Letter Hannes Word 1 10-29-2009 06:27 AM
Letter Templates happymouth Word 8 05-17-2009 02:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft