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.
202
questions
0
votes
0
answers
84
views
How to use Conditional "Else IF" Statement in Microsoft Word Mail Merge
I encountered the following code on a word document, see below image, the "IF statement" in the image sets the criteria if the field {MergeField M_CX...} = "JGray" then it ...
0
votes
1
answer
147
views
How to remove space between \b switch and mergefield value in Word
I have a mergefield in Word which displays a number. I am trying to make the number display as a negative so I added a \b switch with "-".
However it now displays with a space in between ...
- 1
0
votes
0
answers
286
views
Mail merge in Word to tables, grouping by a field?
Is it possible to have source data similar to this
ID
DATA1
GROUP
1
D11
TEST
2
D12
TEST
3
D13
BLA
4
D14
BLA
5
D15
BLA
and use Word to merge the data, grouping by a column, so that the grouping ...
- 242
0
votes
0
answers
159
views
Insert multiple data in the same page using `Insert Merge Field` from Excel to Microsoft Word
I have a Excel like this and I want to import the dynamic data into Word using Merge Field
click this to see the excel.
I have a A4 size with Landscape oriented Word. Then I need to separate the A4 ...
0
votes
1
answer
92
views
IF Fields: how to exclude an entire block of content?
I'd like to use an IF field to toggle if a section is shown or not. I know how it works if you want to show different text depending on a value:
{ IF { MERGEFIELD doShowThis \* MERGEFORMAT } = "1&...
- 13
0
votes
0
answers
193
views
How to force Word to find every column int the Excel datasource using mail merge
I have the following Excel table as data source containg around 20 rows:
When I open the Word file that uses that Excel, it asks if I want to use the query again (it is set to query it via Excel DDE):...
- 767
5
votes
3
answers
22k
views
Multiple mail server provider for one domain is possible?
I have searched in google before asking here. I got a mixed answer in google.
Can i have a multiple MX record from different mail providers?
Example,
Zoho Mail
[email protected]
[email protected]
...
- 159
0
votes
1
answer
1k
views
Formulae in Word Mail Merge
I have a condo owners database to use as a data source in MS Word Merge to Email. I can separate the unit number to identify what tower, floor, and stack the unit is in. For example, 3802 is in the ...
- 3
1
vote
0
answers
159
views
Mail merge using Access query containing long text fields - long text fields are empty in word document
I am trying to do a mail merge in an MS Word document based upon an MS Access query that contains long text fields. For some reason, the entries in the long text fields do not show up in the Word ...
0
votes
0
answers
39
views
Word: Mail Merge guidance needed
I have an Excel workbook with the following generic data:
Using MailMerge in Word, I would like to accomplish the following layout. Note the the number of row will not be fixed at two - or any ...
- 1,007
0
votes
0
answers
29
views
Trying to number community event tickets
I am trying to add sequential ticket numbers to Avery tickets with stubs. I have a background ticket image I use as a watermark and am looking to create the following using ms word. I am trying to use ...
- 101
1
vote
1
answer
4k
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, ...
- 207
0
votes
2
answers
656
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 ...
0
votes
1
answer
510
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 ...
- 1
0
votes
1
answer
194
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>...
- 23
0
votes
0
answers
605
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 ...
- 1
1
vote
1
answer
1k
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 ...
- 933
0
votes
1
answer
2k
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,...
- 371
0
votes
1
answer
80
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 ...
- 101
0
votes
1
answer
895
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 ...
- 3
0
votes
1
answer
2k
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 ...
- 366
0
votes
1
answer
1k
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 ...
- 115
1
vote
0
answers
58
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 ...
- 111
0
votes
1
answer
385
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,...
- 1
1
vote
1
answer
2k
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 ...
- 253
0
votes
1
answer
1k
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 ...
- 31
0
votes
1
answer
3k
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 ...
- 1
0
votes
1
answer
470
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 ...
- 11
2
votes
1
answer
169
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....
- 11.8k
0
votes
2
answers
4k
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 ...
- 3
0
votes
1
answer
343
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 ...
- 358
0
votes
1
answer
479
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 ...
1
vote
0
answers
29
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 ...
- 111
1
vote
0
answers
43
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 ...
- 143
0
votes
2
answers
547
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}=...
1
vote
1
answer
4k
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 ...
- 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 ...
- 101
0
votes
1
answer
2k
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 ...
- 101
0
votes
0
answers
135
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.
0
votes
2
answers
734
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 ...
- 1
1
vote
1
answer
165
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, ...
1
vote
0
answers
180
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 ...
- 11
0
votes
1
answer
30
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 ...
1
vote
0
answers
265
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 ...
- 121
0
votes
1
answer
605
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 ...
2
votes
1
answer
5k
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 }" "{ ...
- 21
0
votes
1
answer
314
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 ...
- 101
1
vote
1
answer
496
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,...
- 178
0
votes
1
answer
63
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 ...
2
votes
1
answer
3k
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 ...
- 21