Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mail-merge]

Use this tag for questions relating to the automatic addition of data from a database or spreadsheet to documents/letters in Microsoft Word. Mail merging is often used in order to facilitate sending similar mail to many addresses.

0
votes
0answers
14 views

Word Labels Mailmerge

I am trying to create a mailmerge for labels that just have First Name and Last Name. When I print the labels, there are multiple copies of the names throughout the labels. I have tried the test that ...
0
votes
1answer
18 views

Insert Mergefield conditionally based on other Mergefield - MS Word

In MS Word '16, I'm trying to insert a Mergefield based on a Mergefield, but I can't seem to get the syntax correct. { IF { MERGEFIELD A * MERGEFORMAT } = "RP2" "{ MERGEFIELD B * MERGEFORMAT }" "{ ...
0
votes
1answer
11 views

Word mail merge: Show only the Nth row of a table

How do I show only the Nth row of a table in a Word mail-merge? My template is of this format: { MERGEFIELD TableStart:widgetList } Foo: { MERGEFIELD foo } Bar: { MERGEFIELD bar } { MERGEFIELD ...
0
votes
0answers
12 views

MS Word Mail Merge gets some data from the wrong record

I have a template to print envelopes that has been working well for years. It is Envelope.doc. I use it to do mail merge from Outlook contacts within a given category. After editing several contact ...
0
votes
0answers
20 views

MS Word fields for Date vs. CreateDate

I'm doing mail merge in MS Word 2016 using fields, to create letters that I mail out. The letters have a date on them representing the date I mail the letter. Rather than update that date every time,...
0
votes
0answers
12 views

Dates merged into Word from Excel don't function as needed; dd/mm/yy treated as mm/dd/yy

To preface, This issue is taking place within a business. The only changes I can make thanks to the set-up for the documents are ones within the Word document. Despite working within the UK, the IP ...
0
votes
0answers
35 views

vb6 mail Merge code not executing select statment in the source dcument

I am using a vb application that gets the data from the database and performs mail merge on one of the template document and send the prints to printer. Now that we have upgrade to word 2010 , the VB6 ...
0
votes
1answer
29 views

Word 2010 mail merge: state a repeated field only once when populating results

I have this Excel file: exel file As you can see it's simple, only three columns: city, customer and paid. I need to create a Word file from this Excel using mail merge in the format I show in the ...
0
votes
0answers
8 views

Office 2013 Mail Merge sending no emails

I used to have no problems sending a Mail merge on Windows 7, however, trying to do one today on Windows 10, and it's simply not working. I've done everything the same, using an excel document as the ...
0
votes
0answers
11 views

mail merge pulling incorrect row

When I try to use mail merge with an excel spreadsheet it is pulling the incorrect row-for example is I want to use the data from row 2 it is pulling the details of row 3 instead-the column headers ...
0
votes
0answers
24 views

Mailmerge with specific cells for a contract

In the course of my summer internship, I have to design a convenient way to generate contracts with the help of an Excel spreadsheet, representing a single person, containing data like name and ...
2
votes
1answer
146 views

Hide a minus symbol from a word mailmerge field

I have a word document that is using mergefields supplied by an external system so have linked a datasource to provide the mergefields. One of the mergefields required shows a balance but it pulls ...
2
votes
1answer
38 views

How can I combine \b txt and and \# formatting in Word's mailmerge?

I would like to both format a field and add text before it. This works: {MERGEFIELD m_002 \b "Dollars need for purchase:"} Producing: Dollars needed for purchase: 1250 But when I add a format ...
1
vote
1answer
124 views

Word displays mail merge data from Excel with the wrong number of digits

I'm using mail merge in Word, with the data coming from Excel. The formula for the data in Excel is number/6 and I limit it to display just one decimal number, e.g. 91.7. But in Word, it displays as ...
0
votes
1answer
2k views

Add CC recipient to mail merge Outlook 2013

I work on an IT service desk and need to send out a regular email to a number of staff however I also want to CC the support email account so the emails end up in our ticketing software. Can this be ...
0
votes
1answer
70 views

Mail merge with Word and not-an-Excel document

I know it's possible to do a mail merge with Word + Excel spreadsheet. But how is it possible to do a Word mail merge with addresses in a TXT or CSV file? Example of Word document: From : ABC ...
0
votes
0answers
109 views

How to Suppress Syntax Errors in MS Word, Mail Merge

I'm using mail merge technology to add 2 different fields. However, when no data is available for these periods, I'm getting Syntax Error!. Is there a way to suppress a Syntax Error when this occurs? ...
0
votes
1answer
2k views

Word mail merge with two records per page

I'm trying to build a mail merge that has columns from two different records on the same page, a set of cue cards for an MC of a cabaret or variety show. It could be a list of future performances for ...
0
votes
1answer
57 views

asking 2 questions for one response mail merge

So far my If statement looks like {IF {MERGEFIELD style } = "luxury" {IF MERGEFIELD type} = "house" "this is a expensive choice" {IF {MERGEFIELD type} = "flat" "This is a cheap flat" "this is cheap ...
0
votes
0answers
58 views

Word and Outlook: automatically sent email messages using Word merged documents formatted as HTML email

We’re trying to do a mail merge in Word and have these merged Word documents sent out as e-mail messages. We have the mail merge working and formatted as HTML and can send them out as email. Now, we ...
1
vote
0answers
60 views

Converting WordPerfect files with mail-merge logic to .docx

I am working with a large number of .frm and .wpd WordPerfect files and I am trying to convert them to .docx while retaining all of the mail-merge logic. Saving the files as .docx within WordPerfect ...
0
votes
1answer
161 views

Word Mail Merge Template Set-Up

I know how to perform a mail merge from within word, but my question is, how can I create a mail merge template that I can open from an external source such as Excel and automatically map the headers ...
0
votes
0answers
273 views

Convert Word Mail Merge document to PDF fillable form

I have a number of documents that are currently being filled in through word's mail merge functionality. I've been tasked with converting them to PDFs and filling them in with a 3rd party tool we've ...
0
votes
1answer
58 views

MS Word mail merge function result, not function formula

I am doing mail merge in MS Word 2010 to automatically fill some forms using a MS Excel 2010 spreadsheet. Values result from an Excel function. Mail merging works, but instead of printing the function ...
0
votes
0answers
53 views

How do I create mail merge fields in Excel that link to data in another excel worksheet

I need some help! I have 2 worksheets in excel: - The first worksheet is a checklist template with a field for a client name at the top (this is the only variable cell) - The second worksheet is a ...
0
votes
1answer
60 views

Using mailmerge to send one email to multiple recepients

I have a database with over 10,000 people in it and I want to send them a conference invitation to their emails. The problem is that the mail merge will send one email to each individual which will ...
0
votes
1answer
68 views

How to add individual/unique attachment to mail merge in word

I am trying to create individual letters (letter + invoice) for customers - customer details are in excel spread sheet.For this I am using mail merge in word with excel spread sheet as a data source. ...
0
votes
1answer
114 views

Can I build a Word mergefield using other fields to complete the name?

I have a list of images (one per state) that I need to pull into my template and normally use a regular mergefield e.g., {MERGEFIELD "Image_FL_09252017"}. The image name is a combination of the state ...
0
votes
1answer
440 views

Auto create file from template and use external file with user data

I would like to ask if somebody knows a way to auto-create files (save as .txt) from a template that substitutes data (maybe placeholders?) from external file. I will try to explain an example. I ...
0
votes
1answer
581 views

Batch inserting multiple mail merge fields

I have a mail merge document connected to a excel file with around 200 columns and a few hundred rows. I need to setup my mail merge document to look as follows: [code] [type] [amount] [...
0
votes
1answer
859 views

Mail Merge Field in Rotated Text in a Label

I'm trying to create a mail merge document to print labels. My problem is that some of the text needs to be rotated 90 degrees, and that rotated text needs to include a mail merge field. From ...
0
votes
0answers
35 views

During a mail merge, how to send a single email to a user instead of multiple ones?

I have a table that looks somewhat like this: User Email | Invoice Number | Company A@as.com 12 xyz A@as.com | 13 | yyy B@as.com | ...
0
votes
1answer
920 views

Changing Language of Date Field in Mail Merge

I'm running a mail merge on my laptop, set to English locale with Thai language as optional proofing language. I've managed inserting the current date in Thai format (with months written in full Thai ...
0
votes
3answers
4k views

Double Sided Flash Cards from Excel Document

I have ~3,000 word list that includes multiple definitions and multiple example sentences for each word. It's in an Excel document arranged like this: Word Translation 1 Translation 2 ...
1
vote
1answer
451 views

Concatenate to a field without using a separate field?

I want to concatenate a space to a Word mail merge field without using a separate field, to make it evident to future editors of the document that the space belongs with the field and is only visible ...
0
votes
0answers
61 views

How to print (pdf) separate files using direct mail on microsoft word?

I'm trying to print / export using direct mail on microsoft word 2016, however I just can not export each pages to a pdf file separated. Is there any way to print / export files using direct mail on ...
3
votes
1answer
803 views

Mail merge from Excel to Word: field is formula referring to text >255 characters

I am trying to perform a mail merge from an Excel document to a Word document. The fields in the source document retrieve text from elsewhere in the Excel document. Thus, the actual fields are in fact ...
0
votes
1answer
330 views

Make a date field static after mail merge using Word

I often have to deal with mail merging (at least once a month). I use a dynamic field for inserting the Date, the problem is the dynamic field remains such even after mail merging when you save the ...
1
vote
1answer
211 views

Word 2016: How can I rename a data source file, without having to recreate the data connection?

I have a Word document, that is configured for mail merge. The data source for the mail merge, is a complicated Excel workbook, containing numerous queries and database connections. I need to rename ...
1
vote
0answers
64 views

MSword Mail Merge With a TOC

I'm attempting to make a MSWord mail merge template where there is a section that doesn't repeat with every mail merge record. I'd like the document to have a title page, and a TOC, and then merge ...
1
vote
1answer
238 views

Mail merge equivalent for Excel

Is there an equivalent of Word mail merge in Excel? I would like to generate PDF documents from an Excel template where each document has different input in two cells.
1
vote
1answer
404 views

Can you ask two nested IF questions for one mail merge response?

I am comfortable with the IF question but the response has a he/she which I want to be gender specific. Can you have an AND command between two IFs? { IF {MERGEFIELD "Field" } = "value" AND { IF {...
-1
votes
1answer
2k views

Looking for an alternative for MS WORD Mail Merge [closed]

I am currently working on a problem which requires me to generate a set of MS-Word files which will have almost 90% of their content same only varying in certain fields. Since these documents are ...
1
vote
1answer
481 views

How to set auto-numbering for mail-merged letters?

I've set up a mail merge to print a standard letter out of a large customer data spreadsheet. I would like to auto-number each letter thus produced so they each have a unique reference ID. Initially ...
0
votes
1answer
7k views

How to Split and Rename files by Mail Merge Field

I just finished a letter MAIL Merge on Word and would like to 1. Split the documents into separate WORD documents and 2. Save or Rename the files by 3 different mail merge fields. I am not familiar ...
0
votes
1answer
61 views

How can I place images from Excel into Microsoft Word?

I have 10 links to images in an Excel file, and I have 10 pages in a Microsoft Word document. I'd like the Microsoft Word document to import each image from the .xls file and place it in a designated ...
0
votes
1answer
2k views

How do I supress blank fields when doing a mail merge in word 2016?

I am creating a mail merge in word 2016 with data from an Excel 2016 file. I would like to do 2 things. 1) set it up so that records with only 1 address line does not print a blank, while records ...
0
votes
1answer
411 views

Word insert Quick Part in IF THEN (serial letter)

I am creating a Word serial letter from an Excel sheet. Now I want to check if a field in Excel is empty. If so, output text. If it is not empty, output a quick part. I already tried it several ...
0
votes
0answers
614 views

Can I mailmerge from a .csv or .txt file straight into Adobe Acrobat DC .PDF?

I have a form that we send out weekly to new customers. I would like to populate the various fields with name, address, email etc. I am familiar with doing this in Word but can find no way of doing ...
0
votes
1answer
64 views

Mailmerge 2 spreadsheets

Can I mailmerge in Word 2010 using 2 Excel spreadsheets? Have found article that says Get Data and then click Data Source but cannot find this in Mailmerge Wizard as an option.