Stack Overflow
Stack Overflow

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

Error! Unknown Op code for conditional MS Word 365

I am trying to do a mail merge and am using the code below. Note: the {} are made with CTRL +F9. and I keep getting the above error. A similar code is use in many other parts of my document and are working fine. Can anyone help with what is…
CRogers
  • 305
  • 6
  • 15
1
vote
1 answer

Attempting to assign mail merge to open excel file

Sub MyTemplate() Dim wordApp As Word.Application Dim wordDoc As Word.Document Dim wordMailMerge As Word.MailMerge Dim wordPath As String Dim excelPath As String CurrentWorksheet = ActiveSheet.Name excelPath =…
Scott Cannon
  • 47
  • 6
1
vote
1 answer

cc not working mail merge (google scripts in google sheets), am beginner

So, basically I am writing some code for a teacher to be able to mail student their grades while cc-ing their parents. I don't really know what's happening, but it only cc one parent... Here's the code, most of it is basic google code that was…
Kitten Dude
  • 11
  • 1
1
vote
0 answers

In Word is there a formula for getting the difference between two mergefield dates?

I have two merge fields in Word that I am needing to do a calculation for another field which needs to contain the difference between these two dates. Is there a way to have that calculated upon merge?
LawGirl
  • 11
  • 3
1
vote
0 answers

VBA Print Word Doc as PDF with password from Mailmerge Field

I am performing a mail merge exercise on a large excel data set. I need to merge PDFs from a word document with individual passwords - the password being a field in my excel file. My code below requests a batch number and a location. I have certain…
mathuna90
  • 11
  • 2
1
vote
1 answer

Is there a way to remove the limitation of 255 columns when importing data for mail merge from Excel to Word?

I am using mail merge in MS Word for generating some documents and all the data comes from a specific Excel worksheet. However it looks like that there is some kind of limitation for the columns you can use in your Excel worksheet for such…
GSabev
  • 25
  • 4
1
vote
1 answer

Mail Merge on Google Sheets and Apps Script

I currently have a script that will take a particular sheet and send it to the email address on Cell C8 as a PDF, this cell is currently populated by selecting a name in a dropdown, as we are using it to send receipts, is there a way to loop through…
Excelsson
  • 195
  • 3
  • 16
1
vote
1 answer

Structure of Variable Merge Tags in MailChimp

I'm attempting to display 12 different images depending on the number of transactions a subscriber has made. Following the documentation on Mailchimp about their IF: ELSE: tags I have created this: *|IF:TRANSACTIONS > 0|* one *|ELSEIF:TRANSACTIONS…
carestreak
  • 11
  • 3
1
vote
0 answers

Email quota restricted to 50 emails for app script [google-apps-script]

I have contacted Google Support and they have directed me here I'm using a Mail Merge AppScript which can be found here Code can be found here It says that it complies with Google's daily quotas for sending mail but I'm only able to send 50 emails…
Kai
  • 11
  • 2
1
vote
1 answer

Is there a way to change format from text to Date given in an excel file for MailMerge purposes?

Hope you are keeping safe, I'm trying to do a mailmerge that will capture the data from an excel file named 'source1' and create word templates using the template.doc file. the output is fine, but the format needs to be fixed for some columns in the…
Mohamed Elgazar
  • 68
  • 11
1
vote
1 answer

Publisher VBA MailMerge - Converting to PDF

I have Publisher document with MailMerge records. My goal is to convert each page with each record to separate PDF document. I have written this code. It generates PDF files with correct names, but for some reason PDFs contain only the second record…
Lasha Dolenjashvili
  • 166
  • 8
1
vote
2 answers

Setting Destination for Powershell MS-Word MailMerge

I have been trying to solve this 'simple' problem but can't find the solution to the problem. I am trying to generate up a powershell script to run a MS-WORD mailmerge and export the document (ideally as a pdf) to a specific file location. The…
Paul Dunthorne
  • 13
  • 4
1
vote
2 answers

How can I skip empty records in VBA Excel mail merge?

I want my VBA Excel Mail Merge with Word to skip empty records. Currently when an the data record turns up empty from my query I get a Run-Time error '5631' stating that "Word could not merge the main document with the data source because the data…
cravaus
  • 43
  • 4
1
vote
2 answers

Multiple Conditions in MailMerge Field

I would like to include up to 3 conditions in a MailMerge field. Below is my current field which returns 1 if checkbox1 is checked. if"<>"="Yes" "Checked""Unchecked" I would like to include checking of additional cb2 and cb3, to check if any…
gymcode
  • 4,431
  • 15
  • 72
  • 128
1
vote
1 answer

Dynamic display text MS Word Mail Merge

Is there a way to make the Hyperlink field have dynamic display text as well as dynamic URL? So far, I have the following merge tag, which is correctly pulling the URL from my CSV data source { HYPERLINK "{ MERGEFIELD URL}"} I hit Alt+F9 to toggle…
DACrosby
  • 11,116
  • 3
  • 39
  • 51
1 2 3
…
47 48