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.
205
questions
0
votes
1
answer
25
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
28
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 ...
- 156
0
votes
0
answers
29
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
0
answers
27
views
Can you set a rule for Mail Merge responses?
If I create a Mail Merge in Word or Outlook, is there a way to set a rule so all responses from that MM get sent to one folder and not my inbox? Besides setting a rule for the subjects I chose.
0
votes
1
answer
59
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
111
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):...
- 717
0
votes
0
answers
32
views
Mail-merge for labels
I am using word for a label mail merge, importing addresses from an excel sheet. I get all the way done and go to print. The second page of labels has the same names and addresses but starts with the ...
- 1
4
votes
3
answers
9k
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]
...
- 141
0
votes
1
answer
85
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
0
votes
0
answers
106
views
Endless Save loop for .DOCM file with macros
I have a .docm Word file that connects to a .csv to get mail merge data. I believe the mail merge part is not part of this problem.
The problem arises from 2 macros that I wrote.
1st macro inside ...
- 267
0
votes
0
answers
86
views
Using mail merge to group several lines into one email
I have a spreadsheet for students that has columns for name, homework average, sports team, email address 1, email address 2. Some students have nothing in email address 2 as that is for an ...
- 1
1
vote
0
answers
115
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
38
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 ...
- 977
0
votes
0
answers
22
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
2k
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, ...
- 205
0
votes
2
answers
467
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
346
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
136
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
460
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
852
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
1k
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,...
- 361
0
votes
1
answer
72
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
596
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
1k
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 ...
- 346
0
votes
1
answer
953
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 ...
- 105
1
vote
0
answers
36
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
250
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
1k
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 ...
- 181
0
votes
1
answer
839
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
2k
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
239
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
62
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.6k
0
votes
2
answers
3k
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
238
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
389
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
26
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
42
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
465
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
3k
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
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 ...
- 101
0
votes
0
answers
102
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
618
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
157
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
161
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
29
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
239
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
549
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
246
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