To my knowledge, it's never possible to run a 2nd-pass mail merge.
**** Hope it helps! ****
~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
Well on the second pass, I don't want to run a mail merge, I want to scan
the document for certain fields (iterating the Fields collection), replacing
them with OLE Links. Another approach I think would be to "INCLUDEPICTURE"
on some dummy .jpg and then scan the InlineShapes on the second pass. A bit
of a hack but it might work. I know the INCLUDEPICTURE field remains after
a merge.
> To my knowledge, it's never possible to run a 2nd-pass mail merge.
> **** Hope it helps! ****
[quoted text clipped - 18 lines]
>>
>> Robin
Robin Tucker - 29 Sep 2004 21:10 GMT
Actually, i see I can embed a link, but not give it a subject (ie. { LINK
MyType.MyImageType } ). This survives the mail merge and I can iterate the
fields collection later, looking for these links and giving them proper
subjects. So no need for INCLUDEIMAGE here :)
> Well on the second pass, I don't want to run a mail merge, I want to scan
> the document for certain fields (iterating the Fields collection),
[quoted text clipped - 25 lines]
>>>
>>> Robin