The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
12 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
0answers
11 views

MS Publisher 2013 mail merge - date field in excel file format issue

The date field in the source Excel file is formated in long format, 23 April, 2014. But in the mail merge results from Publisher 2013 it goes to 2014-04-27 00:00:00. The format control in the ...
0
votes
1answer
8 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
21 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 ...
1
vote
0answers
8 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, ...
0
votes
0answers
7 views

Publisher catalog merge: How can I make the catalog area follow the inner/outer margins

I am using MS Publisher 2013 to create a brochure. It has two-pages layout with a greater margin on the inside so there is extra space for the binding. I am using catalog merge to populate a lot of ...
0
votes
0answers
17 views

Word 2010 Mail Merge

I have an Excel file with 4 Columns: Client_ID, Name, Date, Item bought. I have to use this data base to create a mail merge that has a table. This table has date, items that are available in the ...
0
votes
0answers
19 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
273 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
43 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 ...
0
votes
0answers
23 views

Custom sender and reply-to in MS Office email mail merge using gmail as the email client

Can you do the same using Gmail instead of Outlook (see below)? Here's a workaround for Outlook. It's still a little manual, but for small merges like mine it's fairly effective. The key is to get ...
1
vote
2answers
39 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
60 views

How to use data contained in several related database tables for a form letter?

I want to create a form letter with LibreOffice Writer. The data is contained in a LibreOffice Base database, in several tables. I followed the guide Creating a Form Letter. It seems that I can only ...
0
votes
0answers
26 views

Mail-merge in Word 2010 won't print static image

I'm trying to create a mail-merge letter that has an image of a signature at the bottom. However, when I do the finish and merge and print one of the records, the image isn't printed. I have tried ...
0
votes
0answers
23 views

Mail Merge | Excel transpose or any other solution

i have an excel with 3 columns: domains, clients, email clients each client can have more than one domain. I want to mail merge all my clients to make a change in the dns. but i don't want to send 5 ...
0
votes
1answer
49 views

Suggestions to make Outlook mail merge quicker

I am using Microsoft Publisher 2007 to create Newsletters and 'Mail Merge' them to Outlook 2007. The newsletters consist mainly of images of size between 200-500KB. My contact list is around 5000, ...
1
vote
1answer
776 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 ...
0
votes
1answer
322 views

Hide mail merge fields in Microsoft Word 2010

I have a document full of merge fields that are used to display information from a spreadsheet. Sometimes we want this data to be filled manually, so we have to print the document without these ...
1
vote
1answer
266 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
122 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 ...
0
votes
0answers
107 views

Workaround for absent Carbon Copy Mail Merge feature in Outlook 2010

I'm working on setting up a co-worker with mail merge to send out mass email confirmations to clients for our group events. When we confirm the attendance of a client firm we send the message to an ...
1
vote
1answer
2k 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
225 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
56 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
0answers
58 views

Excel/Word 2007 inserting different images in mail merge

How do I setup excel 2007 so I can do a mail merge in Word 2007? I am fine with all of the merge, but how do I do it to include a different image on each page. Basically I am doing a front cover with ...
0
votes
1answer
115 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
103 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
0answers
69 views

Prevent empty labels in MS Word 2010 Mail Merge

I have a mail merge with labels. There are 4 rows and 5 columns of labels. When a source contains only 2 elements, the Word still creates 4 x 5 labels to fill the page. This way, 18 labels are empty. ...
0
votes
1answer
213 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 ...
0
votes
0answers
152 views

Mail merge: How to create without a header?

In Microsoft Office 2010 I am trying a Mail Merge using Excel and Word. In Excel, I have: 4 lines of data No header row Data contains names/addresses/etc In Word (after opening the Word file) I ...
0
votes
0answers
136 views

How do I get image and text to resize in email depending on where it is viewed?

I am sending a mail merge invitation out that has a header and a footer image and then a body of text. How can I make it so that the text does not extend past the width of the images AND so that the ...
1
vote
1answer
432 views

Inserting rows from an Excel spreadsheet as paragraphs in a Word document

I am trying to put the results of a questionnaire in a Word document. The questionnaire is completed using a web application, and the results are stored in a database. The letter needs to only ...
0
votes
1answer
218 views

Mail merge - show line at empty cells

I'm setting up an account list for a symposium. I'm using a simple excel document that merges to a word dokument. The word dokument is then to be printed so every user can sign his account. All the ...
1
vote
1answer
32 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 ...
0
votes
2answers
985 views

How can I print out or copy merge fields?

I have very complicated mergefields in Word 2010, thus I would like to print out what I coded already to analyze it. However, I cannot copy and paste the pure code, because it always converts to ...
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.
0
votes
2answers
294 views

Word 2011 Envelope Mail Merge button is greyed out. Why

Steps to reproduce: Launch Word Create a New Document Display the "Mail Merge Manager" from the Tools menu Under "Select Document Type", click "Create New", select "Envelopes..." Stare in disbelief ...
1
vote
0answers
420 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
856 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 ...
0
votes
1answer
1k views

Custom Sender and Reply-to in MS Office email mail merge

I'm trying to set up a mail merge that will be sent on behalf of another account. With a reply-to address set to be a completely different account in an exchange environment. Everything I've read ...
2
votes
2answers
5k 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
266 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
125 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
369 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
139 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
318 views

Word 2010: Mail merge to a table in a schema other than dbo

I'm trying to perform a mail merge to a SQL Server 2005 view. I created the same view twice, once without specifying the schema (ie. DBO), and once with specifying the schema. In SQL Server ...
0
votes
2answers
116 views

Best tool to use to measure non-standard label sizes for printing with MS Word 2007?

Is there a specific brand of ruler or system (such as Metric or American) that should be used when measuring the size of non-standard (read "cheap") labels when you want print a bunch of addresses on ...
0
votes
1answer
5k 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
247 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
0answers
163 views

OSX MAIL APP: how can i merge several 'archived' MAIL folders into one single new (filesystem) folder

over the last 5 years i have accumlated several partial MAIL folders scaterred across several different volumes (representing 10GB++ of mail that i really dont want to have to download all over ...