Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2004

Tip: Looking for answers? Try searching our database.

Retain macros after mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bao Le - 17 Mar 2004 02:04 GMT
How can I carry the macros from the main document to the
merged form letter?  I'm running mail merge in word 2002.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 17 Mar 2004 02:17 GMT
I think you might be trying to do something that is not possible.  What is
the purpose of the macros?

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

> How can I carry the macros from the main document to the
> merged form letter?  I'm running mail merge in word 2002.
Bao Le - 17 Mar 2004 17:31 GMT
I want to run a macro to format the tables in the form
letter after the merge.  I'm using the DATABASE fields in
the main document to set up the tables and don't seem to
have alot of formatting options here.
>-----Original Message-----
>I think you might be trying to do something that is not possible.  What is
>the purpose of the macros?
>
>> How can I carry the macros from the main document to the
>> merged form letter?  I'm running mail merge in word
2002.

>.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Mar 2004 00:53 GMT
The macro does not have to be in the document produced by the mailmerge for
it to run.  Assuming that your macro refers to the ActiveDocument then run
the macro when that document is the active document.

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

>I want to run a macro to format the tables in the form
> letter after the merge.  I'm using the DATABASE fields in
[quoted text clipped - 21 lines]
>>
>>.
Bao Le - 18 Mar 2004 02:51 GMT
I built the macro "FormatTable" in the main
document "Master.doc".  After the the mailmerge, I tried
to run the macro on the result document but the macro
wasn't there.
>-----Original Message-----
>The macro does not have to be in the document produced by the mailmerge for
[quoted text clipped - 28 lines]
>
>.
Charles Kenyon - 18 Mar 2004 02:57 GMT
Try putting your macro in the template that is the attached template of your
Master.doc. That should be the attached template for your merge result doc
as well.
Signature


Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I built the macro "FormatTable" in the main
> document "Master.doc".  After the the mailmerge, I tried
[quoted text clipped - 48 lines]
> >
> >.
Bao Le - 18 Mar 2004 23:41 GMT
    I put the macro "FormatTable" into the template "Bao.dot" and attach it to the Master.doc (the main document).  I also removed all the macros off Master.doc to avoid confusion.  After the mailmerge, when I tried to run the macro in the new document' a strange thing happened: in the macros dialog box, the RUN button got gray out when the Macros in dropdown says "All active templates and documents".  I had to change the dropdown to point to "Bao.dot" in order to run the macro "FormatTable"
    ----- Charles Kenyon wrote: ----
   
    Try putting your macro in the template that is the attached template of you
    Master.doc. That should be the attached template for your merge result do
    as well
    --
   
    Charles Kenyo
   
    See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome
     --------- --------- --------- --------- --------- --------
    This message is posted to a newsgroup. Please post replie
    and questions to the newsgroup so that others can lear
    from my ignorance and your wisdom
   
    "Bao Le" <anonymous@discussions.microsoft.com> wrote in messag
    news:a9ed01c40c8b$929a26e0$a001280a@phx.gbl..
    > I built the macro "FormatTable" in the mai
    > document "Master.doc".  After the the mailmerge, I trie
    > to run the macro on the result document but the macr
    > wasn't there
    >>-----Original Message----
    >>The macro does not have to be in the document produced b
    > the mailmerge fo
    >>it to run.  Assuming that your macro refers to th
    > ActiveDocument then ru
    >>the macro when that document is the active document
    >>>>--
    >>Please post any further questions or followup to th
    > newsgroups for th
    >>benefit of others who may be interested.  Unsolicite
    > questions forwarde
    >>directly to me will only be answered on a paid consultin
    > basis
    >>>>Hope this help
    >>Doug Robbins - Word MV
    >>"Bao Le" <anonymous@discussions.microsoft.com> wrote i
    > messag
    >>news:c0b301c40c3d$3eae86a0$a601280a@phx.gbl..
    >>>I want to run a macro to format the tables in the for
    >>> letter after the merge.  I'm using the DATABASE field
    > i
    >>> the main document to set up the tables and don't seem t
    >>> have alot of formatting options here
    >>>>-----Original Message----
    >>>>I think you might be trying to do something that is no
    >>> possible.  What i
    >>>>the purpose of the macros
    >>>>>>>>--
    >>>>Please post any further questions or followup to th
    >>> newsgroups for th
    >>>>benefit of others who may be interested.  Unsolicite
    >>> questions forwarde
    >>>>directly to me will only be answered on a pai
    > consultin
    >>> basis
    >>>>>>>>Hope this help
    >>>>Doug Robbins - Word MV
    >>>>"Bao Le" <anonymous@discussions.microsoft.com> wrote i
    >>> messag
    >>>>news:e69801c40bbb$c7378170$a401280a@phx.gbl..
    >>>>> How can I carry the macros from the main document t
    > th
    >>>>> merged form letter?  I'm running mail merge in wor
    >>> 2002
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.