run macro after mail merge

D

Darryl Naidoo

Hi! I'm new to this forum, but have found no help by searching

I have a merged document that I want a series of macros to run. Th
macros run fine when I open the document from MS Word. When I do th
merge, the macros do not want to run

Please may I have some help on how to solve this

Darry
 
S

Stefan Blom

You'd have to explain more in detail what the macros do and how you run them...
 
D

Darryl Naidoo

Hi Stefan

The macro converts to pdf and saves to the hard drive. I need them t
run after the mailmerge. The AutoRun macro does not run after th
merge.

regards,
Darryl


'Stefan Blom[_3_ said:
;493224']You'd have to explain more in detail what the macros do and ho
you run them...

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" (e-mail address removed) wrote in message

Hi! I'm new to this forum, but have found no help by searching.

I have a merged document that I want a series of macros to run. The
macros run fine when I open the document from MS Word. When I do the
merge, the macros do not want to run.

Please may I have some help on how to solve this.
Click to expand...
 
S

Stefan Blom

Darryl,

I suspect that running the whole process (the merge and the saving) in a macro
would be the most efficient way. However, I'd recommend that you repost in a VBA
forum, such as the Word Developer forum at TechNet
(http://social.msdn.microsoft.com/Forums/en-US/worddev/threads). You'd have to
register a Live ID, if you haven't already got one.

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in message
Hi Stefan

The macro converts to pdf and saves to the hard drive. I need them to
run after the mailmerge. The AutoRun macro does not run after the
merge.

regards,
Darryl


'Stefan Blom[_3_ said:
;493224']You'd have to explain more in detail what the macros do and how
you run them...

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" (e-mail address removed) wrote in message

Hi! I'm new to this forum, but have found no help by searching.

I have a merged document that I want a series of macros to run. The
macros run fine when I open the document from MS Word. When I do the
merge, the macros do not want to run.

Please may I have some help on how to solve this.
-
Click to expand...
 
D

Darryl Naidoo

Hi Stefan

Thanks for the help. I am running the merge from a SAP report, so th
macros have to run after the merge.

I have heard something about Mail Merge Events but do not know how t
code it.

Darryl

'Stefan Blom[_3_ said:
;493243']Darryl,

I suspect that running the whole process (the merge and the saving) in
macro
would be the most efficient way. However, I'd recommend that you repos
in a VBA
forum, such as the Word Developer forum at TechNet
(http://social.msdn.microsoft.com/Forums/en-US/worddev/threads). You'
have to
register a Live ID, if you haven't already got one.

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in messag

Hi Stefan

The macro converts to pdf and saves to the hard drive. I need them to
run after the mailmerge. The AutoRun macro does not run after the
merge.

regards,
Darryl


'Stefan Blom[_3_ Wrote:-
;493224']You'd have to explain more in detail what the macros do an
how
you run them...

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" (e-mail address removed) wrote in message

Hi! I'm new to this forum, but have found no help by searching.

I have a merged document that I want a series of macros to run. The
macros run fine when I open the document from MS Word. When I do the
merge, the macros do not want to run.

Please may I have some help on how to solve this.
Click to expand...
 
S

Stefan Blom

That's definitely a situation where a developer forum would be more helpful
then. :)

Good luck!

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in message
Hi Stefan

Thanks for the help. I am running the merge from a SAP report, so the
macros have to run after the merge.

I have heard something about Mail Merge Events but do not know how to
code it.

Darryl

'Stefan Blom[_3_ said:
;493243']Darryl,

I suspect that running the whole process (the merge and the saving) in a
macro
would be the most efficient way. However, I'd recommend that you repost
in a VBA
forum, such as the Word Developer forum at TechNet
(http://social.msdn.microsoft.com/Forums/en-US/worddev/threads). You'd
have to
register a Live ID, if you haven't already got one.

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in message

Hi Stefan

The macro converts to pdf and saves to the hard drive. I need them to
run after the mailmerge. The AutoRun macro does not run after the
merge.

regards,
Darryl


'Stefan Blom[_3_ Wrote:-
;493224']You'd have to explain more in detail what the macros do and
how
you run them...

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" (e-mail address removed) wrote in message

Hi! I'm new to this forum, but have found no help by searching.

I have a merged document that I want a series of macros to run. The
macros run fine when I open the document from MS Word. When I do the
merge, the macros do not want to run.

Please may I have some help on how to solve this.
Click to expand...
 
D

Darryl Naidoo

Thanks for all the assistance Stefan.

'Stefan Blom[_3_ said:
;493256']That's definitely a situation where a developer forum would b
more helpful
then. :)

Good luck!

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in messag

Hi Stefan

Thanks for the help. I am running the merge from a SAP report, so the
macros have to run after the merge.

I have heard something about Mail Merge Events but do not know how to
code it.

Darryl

'Stefan Blom[_3_ Wrote:-
;493243']Darryl,

I suspect that running the whole process (the merge and the saving) i
a
macro
would be the most efficient way. However, I'd recommend that yo
repost
in a VBA
forum, such as the Word Developer forum at TechNet
(http://social.msdn.microsoft.com/Forums/en-US/worddev/threads). You'd
have to
register a Live ID, if you haven't already got one.

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" wrote in message

Hi Stefan

The macro converts to pdf and saves to the hard drive. I need them to
run after the mailmerge. The AutoRun macro does not run after the
merge.

regards,
Darryl


'Stefan Blom[_3_ Wrote:-
;493224']You'd have to explain more in detail what the macros do and
how
you run them...

--
Stefan Blom
Microsoft Word MVP




"Darryl Naidoo" (e-mail address removed) wrote in message

Hi! I'm new to this forum, but have found no help by searching.

I have a merged document that I want a series of macros to run. The
macros run fine when I open the document from MS Word. When I do the
merge, the macros do not want to run.

Please may I have some help on how to solve this.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Need Help with Macro Security 1
Macro warning in word 1
Macros not usable by other users 0
Menu Macro Not Executing - Need Help 1
Document Merge Formatting Issue 0
Auto Populate One Pages from spreadsheet 0
Setting column width in a table with a macro is not working 0

Top