Hi All,

I open a word document and preform a search and replace using VBA in
MS Access everything works great.

However, now I want to put a signature into the Word document based on
a field I have in tblSignatures.strFullSignaturePath where
strFullSignaturePath is:
C:\Signatures\BarryWright.jpg

Two questions:
1) What kind of place holder do I use in the Word document to hold the
signature image?
2) How do I populate this "place holder" with C:\Signatures
\BarryWright.jpg using VBA?

All ideas are appreciated.

Thanks,
Barry

Try:

1. A bookmark e.g
YourWordApplication.Selection.GoTo wdGoToBookmark, Name:="Signature"

2 YourWordApplication.Selection.InlineShapes.AddPict ure FileName:= _
strFullSignaturePath, LinkToFile:=False, SaveWithDocument:= _
True
HTH

Jon

"Barry Edmund Wright" <barry.edmund.wright (AT) witstoronto (DOT) ca> wrote

SQL Server Reporting Services can embed whatever you need.. and it exports to Word -beautifully-.

Using Access in the year 2010 is worse than pen and paper.