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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
3 views

How do you create name badges in Google Docs with a background, preferably using Avery? [migrated]

I am trying to use Google Docs to create name badges that have a background image behind the text. Our company used to have Microsoft Suite and historically, we used the Mail Merge option within the ...
user avatar
  • 1
0 votes
0 answers
13 views

Individual Excel cells exporting into successive PowerPoint slides

I have an Excel sheet with names in one column. I'm hoping to link that column to a Title block in PowerPoint so that each successive slide has a different name... Slide 1 title is Aaron Aaronson ...
user avatar
0 votes
1 answer
113 views

How can I update the data in an excel sheet so that it goes through to a word document mail merge

I am trying to use 'mailings' in word to merge data from an excel sheet to make up number of documents and print them as PDFs, one document for each row of the excel sheet. So far it is working ok, ...
user avatar
  • 195
0 votes
2 answers
70 views

Two switches do not work together in the mergefield field (\b and \@) for a date

When I separately use the b switch or the @format switch on the mergefield field they work perfectly, but when I try to use them together the b modifier doesn't work. In the images above the code is ...
user avatar
0 votes
0 answers
14 views

Publisher 2 Sided Mail Merge to PDF

So I want to do a simple mail merge as follows: Here is my data: Here is my publication. It has 2 pages (3x3 inches) which should be back to back (a number on one side, and it's corresponding word on ...
user avatar
  • 1,175
0 votes
1 answer
52 views

Microsoft Mail Merge Address Block line breaks error

I'm currently using mail merge to automate a process for sending letters to brokerage custodians and am merging the address block from an excel sheet. Within the sheet the addresses are pulled from a ...
user avatar
  • 1
0 votes
1 answer
51 views

Why does Mail Merge not available on Outlook 2010?

As you can see from the attached picture "Mail Merge" feature is not available on my Outlook 2010? Could you please explain how can I use it? Also I added it from File>Options>...
user avatar
  • 13
0 votes
0 answers
114 views

Microsoft Word Conditional Mail Merge - Bullets in Linked Document

I am creating a conditional mail merge in Microsoft Mail Merge that uses if...then..else. Currently, it is set so that if a letter type is one of several letter types it will go to a specific file and ...
user avatar
  • 1
1 vote
1 answer
183 views

Address labels with LibreOffice

A few times a year, I have to print mailing labels from an Excel spreadsheet. I use Ubuntu, so I have LibreOffice instead of Microsoft Office. Unfortunately, it's a little tricky to get mailing labels ...
user avatar
0 votes
1 answer
402 views

MS Word mail merge: "word could not re-establish a DDE connection to microsoft access"

I have several mail merge documents that I created in MS Word 2007. These have worked very well with MS Access 2007 for years. The only problem that I had to solve during creation of the documents was,...
user avatar
0 votes
0 answers
73 views

How to Control Word Mail Merge From Excel using Excel Data

I need to do a mail merge to Avery 5160 labels from Excel. There are certain variables I have defined in Excel that I need in the mail merge. This is an example of the data I need copied into the Word ...
user avatar
0 votes
1 answer
44 views

Word "mail merge" DOCTYPE

I'm trying to automatically generate Word documents. The necessary data is entering Word through custom document properties, coming from a third party program. Now I'd need to use conditionals on that ...
user avatar
  • 1
0 votes
1 answer
100 views

Can you use more than two conditions for conditional formatting in MS Word?

I've got a particular group of mergefields that I'm trying to colour using conditional formatting. Basically, this column with the table is a percentage and I need it coloured red if it's below zero ...
user avatar
  • 3
0 votes
1 answer
529 views

How to mail merge using a table in the merged document

I was watching a presentation on document automation where I saw a guy run an operation that I am really struggling to replicate. The document was set up in two parts: at the top was a table, and ...
user avatar
  • 274
0 votes
1 answer
331 views

Create multiple tables using mail merge

I have fields as below for report cards of students. <<firstname>> <<lastname>> <<grade>> <<totalmarks>> So above fields will be one record in a mail ...
user avatar
1 vote
0 answers
19 views

Issue with mail merge rejecting high-content rows

I have a mail merge creating word documents from a (macro-enabled) workbook of 77 columns (two sheets - one for dropping raw data into and another that does some cleanup before the mail merge). I ...
user avatar
  • 111
0 votes
1 answer
47 views

Mail merge from excel to word - source data is coloured, not printing coloured in word doc

I have an Excel file where several cells contain coloured, bold font. I need the output into the Word doc to be coloured, bold font. The first time I experimented I got coloured output in the Word doc,...
user avatar
1 vote
1 answer
405 views

Word Mail Merge: DISABLE alert message "Opening this will run the following SQL command" only for trusted files

I am using word for mail merge, but using this feature makes word prompt an alert message every time I open the document. I understand that this alert is for security purposes, so I would like to ...
user avatar
  • 161
0 votes
1 answer
376 views

How to mail-merge multiple documents with the same mail-merge fields from Excel workbook into Word?

On multiple documents I use to put create a PDF for, the same merge fields are seen on each document. I have mail merge fields reading from an Excel workbook to the word documents with the following ...
user avatar
  • 31
0 votes
1 answer
1k views

Word Mergebarcode error : "Barcode merge field was not found in header record of data source."

I'm trying to include some qr codes on some labels but mergebarcode field gives me a headache. The Mergefield displays the URL correctly, but Mergebarcode wont show the barcode giving "Barcode ...
user avatar
0 votes
1 answer
38 views

How would I use IF statements to select which image to pull through using Mergefields?

I'm trying to export images from a database record to a Word document. The record includes a primary photo, which appears on the front page, and then the additional photos are attached to the end of ...
user avatar
  • 11
2 votes
1 answer
24 views

How can I convert an existing word document in to a template with fields that I can update with new information as needed?

I have some legal documents that already have specific data in them. I want to re-use these documents routinely. Therefore, I want to remove the specific information and replace it with dynamic fields....
user avatar
  • 11.2k
0 votes
2 answers
1k views

How to use two access data sources in word mailmerge

I want to design a mailmerge in such a way that the first data source(access query) provides the customer name and number while the second data source (another access query) provides the customers ...
user avatar
0 votes
1 answer
89 views

Text based auto generation mail merge

I have a text file. I would like a simple portable app if possible which can automatically generate 176 different versions where the only difference (e.g. {%FIELD1%} is pulled from a separate file ...
user avatar
  • 338
0 votes
1 answer
245 views

Word mailmerge using multiple values to insert a block of text

I am trying to check if a field has one of multiple values then output a block of text. example: IF a field has the values of MB-75 or MB-100 or MB-200 then output a block of text I thought I had it ...
user avatar
1 vote
0 answers
25 views

Bulk Mail Merge

I have multiple spread-sheets, each with the same columns. I also have a Word template prepped for Mail Merge. I'd like to automatically have the merge go through each spreadsheet in a directory ...
user avatar
  • 111
1 vote
0 answers
34 views

Highlight cells in excel based on whether text exceeds the cell boundary?

I am taking text from excel and pasting it into a fillable PDF using AutoMailMerge. In some cases I have more text than will fit into the PDF field. I've adjusted my excel cell sizes, font, and text ...
user avatar
  • 143
0 votes
2 answers
321 views

I'm having an issue with auto-populating gendered pronouns in a form letter

I am writing a form letter in MS Word in which I am trying to have the document auto-populate all pronouns according to the gender of the subject. I have entered this code: {IF{MERGEFIELD Gender}=...
user avatar
1 vote
1 answer
2k views

Can't display a QR code when using Mail Merge in Microsoft Word (DISPLAYBARCODE/MERGEBARCODE)

I want to use the Mail Merge function in Word to generate name badges to a conference. (Office 365, Word as a local desktop app under Windows.) The data is supplied in an Excel file. One of the fields ...
user avatar
  • 111
0 votes
2 answers
1k views

Microsoft Excel mail merge Word - Birthday date wrong

I have been searching for hours in that issue. In my Excel Spreadsheet there is a date (birthday) in Date Format. Of course in a mail merge that would definatly be translated into text format. Meaning ...
user avatar
  • 101
0 votes
1 answer
1k views

Dynamic Hyperlinked Images with Mail Merge for Email in Word 2016

I want to create a hyperlinked image in a mail merge for email in Outlook. The image will be the same every time, but the link will be dynamic. I can't figure out how. My existing methods involve ...
user avatar
0 votes
0 answers
61 views

Comparing Merge Fields

I am trying to do this: {IF mergefield1 Is greater than 5 and less than 2 "1" "2"} Comparing the fields to get the answer is just not working for me. Any assistance is greatly appreciated.
user avatar
0 votes
2 answers
497 views

How can I create a Mail Merge that sends pdfs

I'm looking to do a mail merge type application that can attach a specific pdf for each data field, i.e. so that each person gets their own pdf document, which are already created. I have used a ...
user avatar
  • 1
1 vote
1 answer
147 views

Excel Tables by Value

I have a spreadsheet that includes student name, parent name, class and t-shirt size, with one row for each student. I would like to draw from this to create a new table, where each class is a row, ...
user avatar
1 vote
0 answers
101 views

Microsoft Publisher Mail Merge - Formatting currency fields

After adding merge record field, I'm not getting an option to Format for certain fields. I have about 10 fields to publisher document and two of these fields cannot be formatted (Format icon is grayed ...
user avatar
0 votes
1 answer
25 views

Mail Merge with formatting alters data

When I perform a mail merge with no formatting (the Merge Field being "MERGEFIELD Cycle1Subject1StudentPercentage"), the answer that appears is correct "52.33" However, if I do it using a formatting ...
user avatar
1 vote
0 answers
212 views

Microsoft Word - Mail Merge modify a single field containing XML with XSL

I am attempting to insert a table based on XML from a datasource. I want this XML to enter as a single merge field that will be provided alongside other merge fields. I am working with the restriction ...
user avatar
0 votes
1 answer
481 views

Mail Merge - Adding space for response

I am working on a word document into which we are merging excel data. We need to have either a line or some space when a field is blank. The merged form will be distributed for members to review the ...
user avatar
2 votes
1 answer
3k 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 }" "{ ...
user avatar
0 votes
1 answer
126 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 ...
user avatar
0 votes
1 answer
353 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,...
user avatar
0 votes
1 answer
57 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 ...
user avatar
2 votes
1 answer
2k 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 ...
user avatar
  • 21
2 votes
1 answer
259 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 ...
user avatar
  • 21
1 vote
1 answer
246 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 ...
user avatar
  • 57
2 votes
1 answer
37k 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 ...
user avatar
  • 334
0 votes
1 answer
265 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 ...
user avatar
  • 1,636
0 votes
1 answer
5k 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 ...
user avatar
  • 101
0 votes
1 answer
80 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 ...
user avatar
  • 3
1 vote
0 answers
83 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 ...
user avatar
  • 186