Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2018, 09:24 AM
lars-daniel lars-daniel is offline cascaded mailmerge Windows 7 64bit cascaded mailmerge Office 2010 32bit
Novice
cascaded mailmerge
 
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 cascaded mailmerge Windows 7 64bit cascaded mailmerge Office 2010 32bit
Novice
cascaded mailmerge
 
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
cascaded mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
cascaded mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
cascaded mailmerge Mailmerge dkub Mail Merge 35 12-07-2011 11:35 PM
Help with mailmerge??? foxtrot1981 Mail Merge 0 12-03-2010 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft