Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-11-2018, 09:24 AM
lars-daniel lars-daniel is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Mar 2018
Posts: 6
lars-daniel is on a distinguished road
Default cascaded mailmerge

Hi there!

I have a rather annoying problem with some kind of a cascaded mailmerge. The document should be printed at our service provider, which also does the franking. So they can't run VBA or any special things.

I have got a word-document with a two-page cover letter (part A) and eight subsequent pages (part B), i. e. a total of 10 pages. The mail merge has 100 copies in total.

I wrote the serial letter into a new document, which now has 1,000 pages. I had to do this because part B had to be reworked with a VBA script (columns had to be colored according to their value, work-arounds/hacks were not possible).

I added new fields to part A after merging via VBA because the mailroom has to feed the addresses (privacy stuff). However, if I generate a new mail merge letter, the 1,000 pages will of course be repeated for every hundred copies.

Anybody have any idea how I can work this out? Unfortunately, the mail service is not allowed to run VBA and cannot process PDF files.

Best,
Lars-Daniel
Reply With Quote
  #2  
Old 03-12-2018, 11:29 AM
lars-daniel lars-daniel is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Mar 2018
Posts: 6
lars-daniel is on a distinguished road
Default

Not solved, but can be closed, since I need to change the concept.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you CC somebody on a MailMerge? constructionjasont Mail Merge 2 06-28-2017 06:01 AM
Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Mailmerge dkub Mail Merge 35 12-07-2011 11:35 PM
Help with mailmerge??? foxtrot1981 Mail Merge 0 12-03-2010 08:21 AM


All times are GMT -7. The time now is 10:34 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft