Thread: Merge source
View Single Post
  #9   Report Post  
Graham Mayor
 
Posts: n/a
Default

As long as you know the field names, you can manually insert fields into
your document without first attaching a data file using CTRL+F9 to set the
field boundaries and the following syntax - {Mergefield fieldname}

--

Graham Mayor - Word MVP

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





Dixie wrote:
My main problem is how do I get the fields into the mailmerge
document in the first place if it has no source for the mailmerge
data nominated inside?

dixie

"Doug Robbins" wrote in message
...
Check out OpenDataSource in the Visual Basic help file. It attaches
a data source to the specified document, which becomes a main
document if it's not one already.

Here is the example that is given the

With docNew.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource _
Name:="C:\Program Files\Microsoft Office" & _
"\Office\Samples\Northwind.mdb", _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:="TABLE Orders"
End With

--
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
"Dixie" wrote in message
...
I read all that Doug and I must admit that I don't see how it
relates to my problem. I am happy with my automation code, but
just need to be able to build many templates for my automated
letters which receive the instruction for where their merge data
file is located from the automation code itself and not have it
inserted in the mailmerge template. This way, it doesn't matter
which directory the data text file is sent to, the mailmerge will
still find it.

dixie

"Doug Robbins" wrote in message
...
It certainly is. Take a look at the information on fellow MVP
Albert Kallal's website at

http://www.members.shaw.ca/AlbertKal...rge/index.html


--
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
"Dixie" wrote in message
...
I just need to know at this stage if this is possible. Can I
automate Word 2000 mailmerge from Access 2000 such that the
automation code has the location of the merge data in it and the
mailmerge letter does not itself need to know where to look for
its merge data? I know you can tell it where the data is in the
automation code in Access, but I don't seeem to be able to build
a mailmerge Word template that doesn't have a destination for the
data to merge.