How do I find the Source folder?

macropod · #2 04-20-2011, 07:27 PM

Hi Phil,

If you add the following macro to, say, Word's 'Normal' template, running it will tell you whether the active document is a mailmerge main document and, if so, where it thinks the data source should be.

Code:

Sub FindmergeSource()
With ActiveDocument.MailMerge
  If .MainDocumentType <> wdNotAMergeDocument Then
    MsgBox .DataSource.Name
  Else
    MsgBox "Not A Merge Document"
  End If
End With
End Sub

For help on installing/using macros, see: http://www.gmayor.com/installing_macro.htm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2010 View Source	tbragsdae	Outlook	2	07-25-2012 06:33 PM
tracking source when pasting between documents	kirko	Word	0	08-22-2010 09:15 PM
Can't find Task Folder	kc300c	Outlook	0	08-02-2010 09:22 PM
Issue with formula's from an outside source	phroche	Excel	0	11-07-2008 03:08 PM
Installation Source Corrupted	browneyes	Office	1	01-23-2006 02:33 PM