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
2 answers

Mail merge into a Word document generates Error Code 4248

My goal is to use two dropdown menus (DM) within a workbook to open a filled-out document. The DM 1 is to select which row of data will be merged. The DM 2 is to select which template is being used. I have separate code that highlights the selected…
1
vote
2 answers

Unable to Send Word Mail Merge Email in VBA Due to Word File not Opening

I have a table in access and a Word mail merge setup and linked to the table. I would like my customers to receive an email on a specific date stated in the table. I have created a template in word and started the mail merge process using the…
Adam Khattab
  • 111
  • 7
1
vote
2 answers

Trimming white space in MS Word + Access mail merge

I am trying to do a mail merge with an Access database, but the output looks like this: Dear JOHN SMITH, Is there a way to trim the white space? I have several thousand of these and I dread having to manually delete the white space on every…
jerry
  • 2,743
  • 9
  • 41
  • 61
1
vote
0 answers

How to insert value with leading and trailing whitespaces into a Word merge field in Python docx-mailmerge

I'm trying to insert a string value that contains leading and trailing whitespaces into a Word document's merge fields using Python docx-mailmerge. However everytime I do this, the value in the Word file seems to delete that whitespaces. str_value =…
AB3
  • 67
  • 6
1
vote
1 answer

Mail Merge vb.net

I'm using mail merge function to merge data from excel sheets to word letter. and I use the following connection and command. Sub WriteInWord() Dim WdApp As Object Dim WdDoc As Object result = Path.GetFileName(TextBox1.Text) Dim…
Wind
  • 27
  • 4
1
vote
0 answers

MS Word INCLUDEPICTURE + MERGEFIELD Quick Parts don't update picture

I'm experiencing an issue with MS Word Quick Parts INCLUDEPICTURE and MERGEFIELD. I have a Word document which is linked to Excel worksheet "Data" though Mail Merge. This is the structure of the Excel workbook: [worksheet Data] | Entry | Nation |…
1
vote
1 answer

Mailmerge in MSOffice 2010 vs Trial version, with Delphi

I'm attempting to make my Delphi membership application automate with word2010, by creating an oleobject instead of a form component: wrdApp := createoleobject('word.application'); opens a mail merge template: wrdDoc := wrdApp.Documents.Open('user…
notidaho
  • 588
  • 8
  • 28
1
vote
0 answers

Mail Merge With Python

I have been trying to write a python script to mail merge labels. It would need to allow me to look into a folder, open an excel document, merge the document, and print it as a pdf. All the rows in each excel file are part of the same document and…
1
vote
1 answer

MS Word - Mail merge show multiple records per page if key field is the same

I am trying to set a mail merge document with the data below. I am trying to populate multiple records in the same page if the customer no is equal. Example: Customer…
Alan Bartoli
  • 21
  • 1
  • 5
1
vote
3 answers

Simplify Conditional VBA Code Microsoft Access

I a newbie to MS Access and VBA Code, but I have been handling well my needs. The code posted bellow is the only way I got my Click Event working. In order to printout current record from multiple tables (mail merge) it's required that some fields…
1
vote
2 answers

Unprotect/Protect Word document through Excel VBA

I want to execute a mail merge from Excel through VBA. I'm having some difficulties unprotecting and protecting the Word document. How do I unprotect the Word document, execute the mail merge and then protect the document once again? Sub…
Owen4512
  • 13
  • 4
1
vote
1 answer

nested mail merge options

I need to perform an automated mail merge using .net driven from an asp.net front end. The mail merge needs to support nested fields, I have come across a product form Aspose but it's highly unlikely that my company would purchase it given its…
Daniel Powell
  • 8,143
  • 11
  • 61
  • 108
1
vote
0 answers

How to ensure "simple mail merge" doesn't duplicate emails

I am trying to combine the principles on the following two tutorials: https://developers.google.com/apps-script/articles/mail_merge https://developers.google.com/apps-script/articles/sending_emails As I want the email to only be sent to each…
1
vote
1 answer

I want to add 2 mint delay in google sheet script forEach loop for sending emails but setTimeout and sleep is not working

i want 2 mint delay after one alteration of the loop. Means I want to add some delay in sending emails. the complete code link is(https://github.com/googleworkspace/solutions/blob/master/mail-merge/src/Code.js) obj.forEach(function(row, rowIdx){ …
1
vote
2 answers

Delphi MailMerge Word2010 new page command

I am trying to update my membership software written in Delphi, to mailmerge in to Word2010. I'm using wrdApp := CreateOleObject('Word.Application'); wrdDoc := wrdApp.Documents.add(); then for each merge field name in a template I'm replacing it…
notidaho
  • 588
  • 8
  • 28