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.

90 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
3k views

Excel/Word on MAC - includepicture containing url

I have the following: A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code. A word doc where these names and ...
jens's user avatar
  • 141
2 votes
1 answer
164 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....
Appleoddity's user avatar
  • 11.7k
2 votes
1 answer
523 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 ...
John's user avatar
  • 121
2 votes
0 answers
468 views

Suppressing Blank Mergefields in Word 2010 Mail Merge

I'm working on combining two mail merge letters into a Master template that will know which merge letter to populate based on information in a specific column. I have successfully combined the two ...
Anna's user avatar
  • 21
2 votes
0 answers
3k views

Is there an easier way to add multiple Mail Merge fields into separate table cells?

I have to create a relatively large Microsoft Word template file that will contains a couple of hundred Mail Merge fields. Some of these are duplicate fields but that isn't too much of an issue. I ...
musefan's user avatar
  • 175
2 votes
0 answers
322 views

Outlook 2010 mail merge group

I'm trying to send a personalized email message to a contact group, but I get this error message: "contact groups cannot be selected. you must select a contact group." If I select individual ...
Artur Carvalho's user avatar
1 vote
0 answers
156 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 ...
Elizabeth Milliken's user avatar
1 vote
0 answers
55 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 ...
APH's user avatar
  • 111
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 ...
Omar's user avatar
  • 243
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 ...
Craig's user avatar
  • 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 ...
Dugan 's user avatar
  • 143
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 ...
UglySwede's user avatar
  • 111
1 vote
0 answers
179 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 ...
Eric Scheidt's user avatar
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 ...
James Luxton's user avatar
1 vote
1 answer
492 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,...
Greg Lovern's user avatar
1 vote
0 answers
91 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 ...
Mike's user avatar
  • 186
1 vote
0 answers
171 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 ...
Baronz's user avatar
  • 111
1 vote
1 answer
2k 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 ...
neydroydrec's user avatar
1 vote
0 answers
1k views

Mail Merge Multiple IF Conditions for cell

I have a conditional statement for two cases (and default) which works fine. This is simply to enter a cell value based on another cell value in an earlier column simplified and shorm of extraneous ...
SteveU's user avatar
  • 11
1 vote
1 answer
58 views

How to pull addresses from word to use in Mail Merge?

I am trying to figure out how to pull addresses from a Rich Text Doc. in Microsoft word to use the mail merge in Microsoft Access. This is being used for work and I need something as quick as possible,...
Christina's user avatar
1 vote
0 answers
124 views

Need to Selectively Merge Records to Different Places in a Word Directory-type Document

My company regularly creates "rosters" (or directory documents) that list contact info for people with roles for a trust fund. The rosters have a certain format -- people with an "Administrator" role ...
Alice Greene's user avatar
1 vote
1 answer
826 views

Incorporate Excel formula Names in Word Mail Merge document

I have an Excel document with numerous constants defined in Names. For example: ------------------------------------------- / Edit Name ? X \ |-------------------------...
dlh's user avatar
  • 121
1 vote
1 answer
210 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
user375354's user avatar
1 vote
1 answer
374 views

How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label. The first image is a background ...
yoshiserry's user avatar
1 vote
2 answers
6k views

Removing carriage returns from a mail merge field in Word

I have a mail merge field called, «ADDRESSLINE2» My data is bad how do remove the carriage return from this merge field.
PriceCheaperton's user avatar
1 vote
0 answers
175 views

Word 2007 Merge Document - creating only one letter to recipient for multiple records

Record 1: Mary Smith, Barney Record 2: Mary Smith, Pebbles Record 3: Mary Smith , BamBam Record 4: Bill Shoe, Rocky For example, Mary Smith is listed in my database 3 times with 3 different dogs....
Gail's user avatar
  • 11
1 vote
0 answers
90 views

Merge Mail Directory

I am using Word 2010 and trying to implement into a cover letter a listing with all the recipients of the letter. I am using the Mail Merge (Mailings > Start Mail merge > Directories). The problem is, ...
user312196's user avatar
1 vote
0 answers
515 views

Word mail merge using excel column to select layout from other documents

I have about 30 word documents. There is 1 document that is the main one setup to use for mail merge. There is a column in the recipiant list that is meant to select the document that will be used ...
Sackling's user avatar
  • 169
1 vote
1 answer
72 views

Display text only in a merge master document (not in the resulting merged document)

I'd like to put some instructional text in a Word 2007 merge master document, but upon merging, not have the text present (or at least, not visible). The text won't print, because it is hidden, but ...
ErikE's user avatar
  • 264
1 vote
1 answer
2k views

What's the difference between mergefields, field codes, placeholders and content controls in Word DOCX files?

I'm struggling to work out the differences between mergefields, field codes, placeholders and content controls in Word DOCX files. As part of a server-based system to generate 'mail merge' documents ...
Jeremy Page's user avatar
1 vote
1 answer
1k views

Put variables into Microsoft Word

Example I have a letter. I have to address it to 10 people. Each of the 10 people will have a unique info which I'll need to input in. So it's like Dear X, Check out Y! I'll like to pull the info ...
user avatar
1 vote
0 answers
782 views

InDesign: Using DataMerge (aka Mail Merge) to insert text based on boolean in Datasource (.csv)

I am preparing some wedding invites, using Adobe InDesign (CS 5.5). I have a .csv with all the a names. This is used with Data Merge to insert all the names. Very simple. Now more complex For most ...
Frames Catherine White's user avatar
1 vote
0 answers
197 views

Mail merge Vista Word 2007 with Windows Live Mail

When I do a mail merge to send email from Word 2007 with Windows Live Mail installed, it doesn't seem to send the messages. Are there known problems with Windows Live Mail for mail merge? Is there a ...
user823527's user avatar
1 vote
0 answers
109 views

Word 2003 is ignoring mail merge delimiters

I have a flat file using the semi-colon as a delimiter. This is merged with a historic Word template that has been in use for years at our office. However, recently the template has started ignoring ...
derek_b's user avatar
  • 11
1 vote
1 answer
2k views

How to leave a blank space on IF_THEN_ELSE condition in MS Word Merge

I am running an mail merge program, where I need to merge certain fields. I have done these in the past. Just to add on these, I have to print certain text based on the value of the field in MS Excel. ...
howtechstuffworks's user avatar
1 vote
0 answers
2k views

Office 2010: Mail merge doesn't send e-mail (Worked with Office 2007)

I have a system that currently uses a Microsoft Word template, using an Excel file as a datasource, to run a mail merge that sends an e-mail through Outlook. Using 2007, this worked without issue. ...
SeanKilleen's user avatar
  • 2,402
1 vote
0 answers
58 views

How can I find my mail merged InDesign document?

I created a mail merge using InDesign, and it looked like it went through all of the records but (1) I can't find the option to export to pdf and (2) I can't find the merged file anywhere on my system ...
user avatar
1 vote
1 answer
152 views

Switch Text Paragraphs in OpenOfficeOrg Writer mailmerge

I am using mailmerge to write the same letter with minor differenes to many peolpe. I experienced that switching text paragraphs depending on database values was not easy for me. I ended up putting ...
user avatar
1 vote
1 answer
293 views

Mail merge multiple rows

My table in excel : Joe Smith, 11-1-12, 9-10am Joe Smith, 11-1-12, 11-12pm Joe Smith, 11-2-12, 7-8am Sara Roy, 11-1-12, 9-10am Sara Roy, 11-1-12, 11-12pm Needed result which should go in mail to ...
S kumar's user avatar
  • 11
0 votes
0 answers
66 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 ...
Azib Haque's user avatar
0 votes
0 answers
269 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 ...
MyICQ's user avatar
  • 242
0 votes
0 answers
155 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 ...
user212324's user avatar
0 votes
0 answers
185 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):...
Nestor's user avatar
  • 767
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 ...
Brian's user avatar
  • 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 ...
BedfordNYGuy's user avatar
0 votes
1 answer
503 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 ...
Stocks's user avatar
  • 1
0 votes
1 answer
189 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>...
mkde's user avatar
  • 23
0 votes
0 answers
594 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 ...
Liz's user avatar
  • 1
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,...
Tobias Knauss's user avatar
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 ...
bdb484's user avatar
  • 366