Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Publisher

LinkBack Thread Tools Display Modes
Old 01-14-2018, 01:21 PM
phixate phixate is offline Windows 7 64bit Office 2016
Join Date: Jan 2018
Posts: 1
phixate is on a distinguished road
Default Batch mail merge and print

I'm trying to find a way to automate the printing of 167 newsletters (which are 10-20 pages each) for the 157 subscribers on my list. These "newsletters" are a series of teachings that subscribers receive bi-weekly via mail (it's a prison ministry). I have a database in Access which keeps track of what each person has received and what they should receive next. What I need is a VBScript or PowerShell solution or something that will look in the table of the database which shows how many of each newsletter to print, open each Publisher file (or PDF if possible), merge the contact info into the mailing label section for each recipient and print. It should automatically open each file, merge and print in a batch with the push of a single button. Does anyone have any idea of how to accomplish this? I have some knowledge of macros and VBScript (limited). I might be willing/able to pay someone to help me put a solution together for this. If anyone has any suggestions please let me know. Thanks!

EDIT: My system right now is Windows 7 but I'll be moving to Windows 10 within the month.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using mail merge to print labels scooterspal Mail Merge 6 03-12-2016 09:50 AM
Batch edit mail merge macros? kbash Word 0 04-30-2014 08:32 AM
Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
Mail merge to print each record as it is created PNGento Mail Merge 1 01-26-2012 02:00 PM
Mail merge will not print! Delta223 Mail Merge 0 12-08-2009 05:46 PM

All times are GMT -7. The time now is 11:42 AM.

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