Run macro inside a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Garry - 24 Mar 2004 12:49 GMT

is there a way of running a macro from inside a merge? I
know there's the MacroButton field, but that only seems
to work as a double-click event. Also, is there a way of
moving to a particular part of a document from inside a
merge? I'm converting some WordPerfect mailmerge docs and
struggling to come up with the Word equivalents.

All help appreciated.

Garry

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Mar 2004 13:09 GMT

Describe what you are trying to achieve and we might be able to tell you
if/how it can be done, Converting WordPerfect mailmerge docs doesn't mean a
thing.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> is there a way of running a macro from inside a merge? I
> know there's the MacroButton field, but that only seems
[quoted text clipped - 6 lines]
>
> Garry

Reply to this Message

Garry - 24 Mar 2004 13:46 GMT

There's a WP merge command called NESTMACRO that allows
you to run a macro at any point. They use it for
calculating a value based on other values on the page,
and then pasting that value into the document. Some of
the values are typed by the user at runtime

I'm already thinking that this could be solved with a
formula field?

The GO merge command allows you to skip a section of a
merge by moving further down the page. For example, they
test the value of a field to see if it's Y. If it is, it
merges in a field. If it isn't, then the value merged
depends on the outcome of 5 IF tests. To avoid a complex
else section in an IF, it would be easier to simply jump
to a bookmark.

Thanks for your help Doug,

Garry

Reply to this Message