views:

104

answers:

0

Not really hard core programming, but it's been bugging me. I need to do a simple mail merge and in the merge I need to personalize the url.

It seems like the only option is to use a macro (alt-f9 field editing doesn't work as expected), but I just cant get it running.

I've created an EventClassModule as described here: http://msdn.microsoft.com/en-us/library/bb221264.aspx#Write

I've implemented a few event handlers:

- Private Sub App_MailMergeBeforeMerge(ByVal Doc As Document, _
    ByVal StartRecord As Long, ByVal EndRecord As Long, _
    Cancel As Boolean)
- Private Sub App_MailMergeBeforeRecordMerge(ByVal Doc As Document, Cancel As Boolean)

but it seems none is getting called (breakpoints are ignored, debug.print doesn't print anything, messages are not shown...

Any ideas what might be wrong? Or any other way of inserting a merge field into hyperlink?

Thanks