-1
votes
0answers
18 views

Error when changing excel data sheets in word mail merge?

As part of a program i am working on data is transferred into an excel document with usually more than one worksheet. after that happens a mail merge is manually done to create labels. the problem i ...
1
vote
0answers
34 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 ...
1
vote
0answers
45 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 ...
0
votes
1answer
87 views

Mail Merge, Split, Protect, and E-mail Word 2013 Document

I have created the perfect form for time sheets at work. My goal was to mail merge the pages with personnel data. Then protect the document with a password so people don't accidentally change the ...
0
votes
1answer
68 views

MS Word Mail Merge: Validate Data

Is it possible to implement validation rules in a Word mail merge? I want to set up the Word file so that if a given test fails, Word will take some action when attempting to complete the merge. ...
0
votes
1answer
49 views

Changing a Mail Merge Word document to point to a new datasource?

I am trying to change a MSWord 2013 mail merge document so that it points to a MS SQL DB rather then the original MS Access DB which just linked to the SQL DB tables. Basically I want to remove Access ...
0
votes
0answers
50 views

How do I Mail Merge from a SQL DB to Word 2013 with a date filter?

I have a SQL database view that returns the data I need for my mail merge. This data needs to be filtered by a Date Range. i.e. >1/1/2014 and <3/1/2014 I have attempted to put it in the filter ...
0
votes
0answers
24 views

Printing 24 labels per page from Excel

I'm trying to print 24 labels per page in Word using Excel list. First page is fine, but when it moves to next page only difference is that second record from first page becomes first record on ...
2
votes
2answers
1k views

Microsoft word - conditional formatting in mail merge?

Is it possible to use conditional formatting in Microsoft Word 2007 Mail merge? I would like it to color the font, depending on the field value, for instance: if "Priority" field equals 1, color the ...
1
vote
0answers
53 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
2answers
56 views

How do I split a directory when a field changes in Word 2010?

I'm creating a directory mail merge in Word 2010 using an xlsx file as the record source. One of my fields is "Manager". Most of the fields will be different on every line, but Manager will be ...
1
vote
1answer
2k views

Mail Merge - Multiple Rows Into One Document

I am trying to do a Mail Merge where I have 200 Franchise Owners, with approximately 1200 staff members who have taken part in an incentive program. I need to send a letter to the Franchise Owners ...
1
vote
1answer
389 views

Word mail merge: show or hide table

I'm creating a mail merge document where I need to hide swathes of the document based on a field I have. OK. That's simple enough. {IF {MERGEFIELD My_Field} = "True" "a bunch of text ""}. But one ...
0
votes
2answers
193 views

How to properly use nested conditional Mergefield in Word 2010

I want to refer two names in my condition, for example there is at least one Referral_Name and if there's a second one put the the second one, Referral_Name_2. So far I have the following nested if ...
1
vote
2answers
4k views

Remove mail merge data source from MS Word Document

I am using MS Word 2013. I have a document that, when opened, prompts me with: Opening this document will run the following SQL command: SELECT * FROM C:\somepath\somefile.mrg Data from your ...
1
vote
1answer
292 views

How do I create a nicely formatted directory with mail merge in Microsoft Word 2007?

I am trying to create a directory with mail merge in Microsoft Word 2007 and I hit a few issues. «Forename» «Surname» «Address_Line_1» «Address_Line_2» «Address_Line_3» «Address_Line_4» «Postcode» ...
0
votes
1answer
179 views

Using Mailmerge to sort a list by Category

I followed this support article from microsoft: http://support.microsoft.com/kb/294686/en-us#2 I seem to be missing something as the output does not list properly per city. I get a single line per ...
0
votes
1answer
130 views

Where is the 'Query Options' command in Word 2010?

I want to attempt a mail merge by category. Was it removed from the app?
0
votes
1answer
276 views

Word Print/Mail Merge: is it possible to use as datasource a master-detail structure?

i've the following excel table: User Period Value Mike Jan-March 120 Mike Apr-Jun 80 Mike Jul-Sept 100 John Jan-March 80 John ...
1
vote
1answer
33 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
2answers
1k views

How to set mergefield to show long date format?

How can I make Word 2012 display German date format in mail merge? { DATE \a "dd.MM.yy" \ * MERGEFIELD } returns 15.02.2012 for today, 15. Februar 2013 however is what I want.
1
vote
0answers
478 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 ...
1
vote
2answers
1k views

Microsoft mail merge incorrectly formatting numbers

I am doing a mail merge in Microsoft Word and pulling the data from an Excel spreadsheet. The text is being inserted perfectly, but when I go to insert a number value, the number goes out to fifteen ...
2
votes
2answers
6k views

How to combine several records in a single letter using Word mail merge

I have a long Excel list with data in the following format: A, B, C x, y, z1 x, y, z2 x, y, z3 I want to create a mail merge in Word 11 for Mac in the following style for each x, y , which is ...
0
votes
1answer
295 views

Is it possible to Link to Excel File Based on Dynamic Mail Merge Field?

If I were to create an excel sheet with merge fields for a Mail Merge, and one of those fields were to be a file location, for example, can I then create a link in my Word document to a second Excel ...
1
vote
1answer
143 views

Is there any way I can fix a word header to a specific height?

I'm making a template for a letterhead, and I've put in mail merge fields for name/address. Some of my address records don't have some fields like name or address line 2. When these records are used, ...
1
vote
1answer
395 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 ...
0
votes
1answer
154 views

Adjusting the column height of a Word 2007 Mail Merge on every page?

I've been doing mail merges lately and we use labels that aren't listed in the default MS Word settings: I tried measuring them out and here is what I got: Despite measuring them they don't seem ...
0
votes
1answer
6k views

Labels mail merge repeats on subsequent pages?

I'm trying to do a mail merge to print to labels. The first field in the document does not contain a { NEXT } field code, and because of this the records repeat between label pages for example: ...
1
vote
1answer
282 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 ...
2
votes
1answer
1k views

Word 2010 - Mail Merge with Superscript Formatting

I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted ...
1
vote
0answers
111 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 ...
2
votes
2answers
3k views

retain formatting from source document in mail-merge

I have set up a mail-marge in Word 2003. The source is a document where each field is a formatted text as the following one: I have different pieces of text to insert. However, when I insert such a ...
1
vote
0answers
78 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
1answer
244 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. ...
0
votes
1answer
124 views

Word 2002 mail merge “command strings”

We have an MS Word 2002 document used for mail merge operations. Apart from the usual mail merge fields that one sees when pressing Alt+F9 (show field codes), it also contains strings that look like ...
0
votes
1answer
272 views

Printing labels in word, starting in a specific (offset) cell

This is probably super simple and I'm just overlooking something... I hope. I'm creating labels in Word 2010 and pulling the data from Excel 2010. I've got them laid out perfectly, but I need to ...
1
vote
2answers
547 views

Conditional Images in mail merge

A previous answer suggested here leads me to the conclusion I can merge images, but without control of the datasource how can I make the image different based upon a field condition? For instance if ...
0
votes
1answer
394 views

Word mail merge - Know thy source?

I have a very large number of documents that I need to change where they source the merge data from. I would prefer to change them as and when required. The issue is knowing which I have changed and ...
1
vote
1answer
2k views

How to mail merge a hyperlink in Microsoft Word or Publisher 2010

I am trying to do an e-mail merge in Microsoft Publisher 2010 (which appears to do mail merging like Microsoft Word) and I'm wanting a merged email address to automatically be hyperlinked in the ...
1
vote
1answer
1k views

Dynamic row height on Word tables, based on mail-merged contents

I'm having to work with some Word templates which contain nested tables of mail-merged fields. I need the row height of one of the child tables to have a minimum height but be able to expand (height ...
2
votes
2answers
187 views

Mail-Merge on Steroids: Can Word 2003 do this?

I have a huge report to put together, made up of over 1,000 smaller, nearly-identical reports. Each report includes: General 1:1 information (basic mail-merge stuff) Lots of text, some of which may ...
1
vote
1answer
665 views

Easiest way to print hundreds of same letter with different addresses

There is a long list of names and addresses in CSV format (could be converted to a different). I need to print a hundred of letters with some formatting like: %address% Dear %name%, Blah-blah-blah ...
2
votes
1answer
404 views

Mail Merge in Microsoft Word with images from Sharepoint

Is there any way of doing a Mail Merge in Microsoft Word 2007 taking data, including images from a Sharepoint site? It's a bit crude, but I've managed to merge text by taking the data off the ...
1
vote
3answers
6k views

MS Word 2007 Mail Merge fails on ZIP codes with leading Zeros (eg. 01234)

I have an Excel Spreadsheet with a ZIP code column. For some dumb reason the original spreadsheet I got had all the zip codes stored as numbers, so a ZIP code like 01234 was stored as 1234. Easy to ...
0
votes
1answer
812 views

Word mergefield wildcard not correctly matching

Below is my mergefield code: { IF { MERGEFIELD Subs_State } = "GA" "blah blah" "{ IF { MERGEFIELD CEOrgStates } = "GA" "blah blah" ""} "} I'm pulling records from a MS Access db. My goal is to check ...
4
votes
2answers
10k views

Changing Word mail merge data source locations in bulk?

I've just moved a number of Word mail merge files, and a number of Excel spreadsheets that are the data sources for the mail merges, from a Windows XP computer to a Windows 7 computer, and now all the ...
1
vote
1answer
796 views

MS Word mailmerge using Thunderbird

Can this be done?
4
votes
2answers
2k views

mail merge e-mail in Word 2007 with attachment

Is there a simple way to mail merge with Word 2007 and add an attachment? I've searched google, and all results point to pasting in VB code. I want to a small team of novice users to be able to mail ...
0
votes
1answer
3k views

Is it possible to have Word 2007 access a MySQL database?

What I essentially want is some way to expand my mail merge system. If an account number gets sent to a word document via mail merge, I would like some way for Word to connect to a MySQL database and ...