Questions tagged [mailmerge]

A software function which provides the ability to create multiple (and potentially large numbers of) documents from a single template form and a structured data source.

Mail merge is a software function which provides the ability to create multiple (and potentially large numbers of) documents from a single template form and a structured data source. Often these documents are letters and/or labels to be sent to a number of recipients (hence the term).

It is expected that questions about mail merging relate to programming in some way. You should tag your question with the programming language or technology you are using to perform the mail merge.

Related Tags:

Links:

707 questions
1
vote
1 answer

Google App Script - Send long email from google sheet - email broken into lines

I tried to autosend mass emails from google script editor, using a list of email addresses on google sheet. I followed this tutorial. I used my other gmail address as a test and succeeded in receiving the email, but I found that some longer…
Alice Wong
  • 31
  • 3
1
vote
1 answer

Add filter to Publisher mail merge from Excel

I have a macro in Excel that runs a mail merge in Publisher. How do I add this filter to the current code? sheet="ALL Sections$", colIndex= icol, criteria="part1name" Code to run mail merge in Publisher: Dim strWorkbookName As String Dim…
1
vote
1 answer

How to increase the performance of Syncfusion ConvertToPDF method

I use the following method to generate a PDF document using MS Word Mail merge. The “PaymentPlanDetails” has 7050 records and its data model has 9 string fields, an int field, a decimal field and a DateTime field. private MemoryStream…
1
vote
0 answers

Trying to include print command into a mail merge excel code (Updated code)

Can't make the document printout command work... I am running a mail merge, and that part works perfectly. My only issue is printing the doc after the mail merge runs. I have tried researching this on line, but have not been able to find anything…
ChipsWorld
  • 13
  • 4
1
vote
1 answer

How to Add another document to mail merge for the same record

Using a code I found on here posted by user dandarii, I can mailmerge a word.doc. When that mail merge is done I'd like to mailmerge a separate word.doc with the same record. I do not want to have to merge the two word.docs to one word.doc Was…
NoobCoder
  • 25
  • 4
1
vote
2 answers

Word VBA Create chart on each page

I work for a school district. We need letters to go out to parents with their students absences. Data is already used from an Excel Document to create a mail merge. From Excel document I am pulling 3 fields into a "hidden table" Student name,…
RobStone
  • 13
  • 2
1
vote
2 answers

Word / Office 365 Mail Merge - Alternative to UDL file for SQL connection string

We provide a large software suite, which amongst its functionality includes the ability to perform Mail Merges in MS Word / Office 365. In order for Word to know where to get the merge field list and data from, we set up a .UDL file:- [oledb] ;…
LMS
  • 642
  • 6
  • 22
1
vote
3 answers

How do I suppress blank lines in a Microsoft Word 2007 mail merge?

I'm setting up a mail merge file that reads from a CSV file. In the CSV file, there are ~20 Boolean fields that produce the body of the Word mail merge file. The problem is that if the first 19 fields are all "N", then the Word mail merge file…
CheeseConQueso
  • 5,831
  • 29
  • 93
  • 126
1
vote
1 answer

Merge user defined html template with user defined json data

I am trying to create generic utility class that builds email template body taking in two inputs html template with placeholders (it can have repeating records) json data Expected output is to generate html file combining html template and…
Maulik Modi
  • 183
  • 3
  • 18
1
vote
1 answer

Error when saving individual docs from a mail merge

I Have been using a VBA code to individually save all letters separately from a mail merge into a designated folder. It has always worked previously howver with the document I am trying to do it for now it is onyl saving the first document and then…
MattD
  • 33
  • 5
1
vote
2 answers

Mail Merge Word 2003 Header Fields C#

I am in the process of writing a small library that will perform a MailMerge on a word 2003 .DOT document in C#. I am able to retrieve and replace all of the document body fields like so: foreach (Field mergeField in document.Fields) { if…
Sean Hunter
  • 1,041
  • 8
  • 19
1
vote
1 answer

Excel MailMerge Export to PDF

Im trying to generate offer letters based on details provide and mail merge it. But i want my output in PDF Format instead of word. Since it exports the file in word, i want that the final output that is generated is a PDF. But whenever i am trying…
1
vote
2 answers

Merge fields in Office 2007 or 2003 using C#

I want to set up a template document along the lines of this: ================ Doc content ---------------- Merge Field1 Merge Field2 Merge Field3 ---------------- More doc content ================ I then want to be able to open the document,…
Craig
  • 36,306
  • 34
  • 114
  • 197
1
vote
0 answers

Open Office mail merge - pick text colour based on field value (formulas / scripting)?

Is there a simple way (via formulas if possible rather than scripting) in Open Office text documents (.odt) to format characters via a formula based on the value of a mail-merge field? The File -> New -> Label is great to create mail merge in…
asoundmove
  • 1,292
  • 3
  • 14
  • 28
1
vote
1 answer

How to merge entirely different pages based on value of merge field

At my office we use documents with merge fields from Microsoft Word for a number of different functions. However, I can't find a way to merge entire pages based on the value of a merge field. For instance, there are different forms you have to use…
NameHere
  • 35
  • 1
  • 8