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
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 \
|-------------------------...
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 ...
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 ...
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.
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....
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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):...
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 ...
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 ...
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 ...
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>...
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 ...
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,...
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 ...