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 / July 2006

Tip: Looking for answers? Try searching our database.

MailMergeBeforeRecordMerge not firing for all records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chachi - 26 Jul 2006 16:25 GMT
hi everybody, i've been having this problem for a while now and have
been unsuccessful in finding a solution.  we have a recruitment program
(recruitment plus, if anyone wants to know) at work that we use for
doing mail and email merges.  i open my program, find what it is that i
want to merge, hit merge, and word opens with the finished product.
whenever i merge documents with vb code, the MailMergeBeforeRecordMerge
method only fires on the last record.

what i'm trying to do is change the text of a mergefield, then insert
that modified text into boomark.  i'm doing all of this inside
MailMergeBeforeRecordMerge.  it works perfectly... except for the fact
that it only works for the last record.  (before i change the info in
each record, i have a little popup window tell me what record i'm
merging, and it only pops up on the last record)

i know that there's a problem with the MailMergeBeforeMerge method only
firing when called from the mail merge wizard, i'm wondering if maybe
there's a similar problem with MailMergeBeforeRecordMerge...?

can anyone can shine some light on my situation?
Peter Jamieson - 27 Jul 2006 10:26 GMT
I've tried something similar here using VBA to write the Event code, and I
don't see this unless I set Cancel = True for exvery record except the last.
Could you be doing the same?

If not, please post the relevant parts of your code here and I'll try to
have a look.

Peter Jamieson

> hi everybody, i've been having this problem for a while now and have
> been unsuccessful in finding a solution.  we have a recruitment program
[quoted text clipped - 16 lines]
>
> can anyone can shine some light on my situation?
chachi - 27 Jul 2006 18:57 GMT
i looked, and i definitely don't have anything saying cancel.  i did
however find a different - and MUCH easier - solution to my problem.
so, thanks for responding to my post, i appreciate it

> I've tried something similar here using VBA to write the Event code, and I
> don't see this unless I set Cancel = True for exvery record except the last.
[quoted text clipped - 25 lines]
> >
> > can anyone can shine some light on my situation?
Peter Jamieson - 27 Jul 2006 20:51 GMT
Glad you fixed it, but would you mind sharing your solution?

Thanks,

Peter Jamieson

>i looked, and i definitely don't have anything saying cancel.  i did
> however find a different - and MUCH easier - solution to my problem.
[quoted text clipped - 31 lines]
>> >
>> > can anyone can shine some light on my situation?
 
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.