#1
|
|||
|
|||
Mail merge macro that considers edited recipient list?
Hi guys
Just wondering how you would tackle a Word mail merge macro that takes into consideration if the 'Edit Recipient List' has some unticked recipients? For recordNumber = 1 To totalRecord With myMerge.DataSource .ActiveRecord = recordNumber: .FirstRecord = recordNumber: .lastRecord = recordNumber End With Not sure how to get it to recognise if any recipients have been unticked, as the above code (just an excerpt of course) would obviously just process ALL the recipients. Thanks a lot! James |
#2
|
||||
|
||||
I guess the questions here are:
1. why are you looping through the records?; and 2. what is your SQL statement?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
I guess I've not got that far yet. I'm just wondering that if you (or anyone) were writing a basic mail merge macro, how would you get it to notice if you had unticked records in the recipient list? This side of things is new to me, so be gentle! |
#4
|
||||
|
||||
For a basic mailmerge macro that would honor your record selection, see the first macro in the Mailmerge Tips & Tricks 'Sticky' thread:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
Wow thank you! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Edit mailmerge recipient list using a macro | hhorber | Mail Merge | 0 | 12-17-2019 11:48 AM |
Mail Merge using edit recipient list option not working properly | Dsr122076 | Mail Merge | 1 | 12-03-2015 04:19 PM |
Creating recipient list for mail-merge | Roger Keeling | Mail Merge | 2 | 05-23-2015 04:34 AM |
Editing recipient list in mail merge from word 2007 not working | dlaslett | Mail Merge | 4 | 03-16-2015 02:02 AM |
Edit mail merge recipient list | Freddies_grandad | Mail Merge | 7 | 12-10-2012 11:05 PM |