The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
9 views

Serial printing on LibreOffice Writer is not working

I have written this document and linked the corresponding fields from a LibreOffice Calc database (spreadsheet) correctly, and when I try to print it I am being prompted about "Serial printing" the ...
1
vote
0answers
22 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 ...
0
votes
3answers
61 views

How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...
1
vote
1answer
40 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 ...
0
votes
1answer
51 views

Mail Merge using the Data Bar Conditional Formatting

I am creating a mail merge which produces customized reports for each student. The content of the word document contains a bar which is marked off in units from the lowest possible to highest ...
0
votes
1answer
153 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.
0
votes
0answers
52 views

Word 2010 Mail Merge multiple IF statements

I'm at a lost. I haven't used the IF statement in a Mail Merge since 2003 and I'm must be missing something. I have a field called Type if Type="Tax" then it should insert a sentence about taxes if ...
0
votes
1answer
55 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
1
vote
0answers
92 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
67 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
2answers
408 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
116 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
205 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
314 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
95 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
32 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
71 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
31 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
38 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
3k 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
75 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
100 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
121 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
256 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
43 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
46 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
81 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
3k 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
593 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 ...
2
votes
1answer
634 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
328 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
3answers
9k 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
449 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» ...
1
vote
1answer
87 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
1answer
267 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
178 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
345 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
870 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
266 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
35 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
1k 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
2k 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
430 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
569 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
2k 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 ...
1
vote
1answer
2k 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
7k 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
348 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
184 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
475 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 ...