The tag has no wiki summary.

learn more… | top users | synonyms

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
161 views

Mail Merge Multiple Rows into one document

I have an excel file with different fields in each column: Field 1__ | Field 2__ | etc. F1 Item 1 | F2 Item 1 | etc. F1 Item 2 | F2 Item 2 | etc each field has a different number of items in it. ...
0
votes
2answers
492 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
1answer
72 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
1answer
95 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 ...
1
vote
1answer
37 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
1answer
514 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
1answer
370 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
1answer
280 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
1answer
132 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 ...
0
votes
1answer
20 views

Mail Merge using mutiple fields/next record

I am trying to merge the following: {MERGEFIELD Signer} Date Page 2 {MERGEFIELD Payername} {MERGEFIELD Number} {MERGEFIELD Description} {MERGEFIELD Year} PB If the client has multiple Payer ...
0
votes
1answer
24 views

Macro to merge data on to template

I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template. So far I have written code to open the ...
0
votes
1answer
509 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
1answer
85 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 ...
0
votes
1answer
140 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
710 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
1answer
198 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
1k views

When doing an e-mail merge in Office 2010, Outlook forces me to approve EVERY email sent

When doing an email merge from Excel data, via a Word template, into Outlook (all Office 2010), I get the dialog displayed above. For every single email, I have to wait 5 seconds, then click the ...
0
votes
1answer
522 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 ...
0
votes
1answer
180 views

Recommendations of mail merge freeware?

At work (Exchange server) our team often needs to send emails to 500+ partners. It's currently a very dull job, so I've tried the merge features in Office 2007. However, it can't: Include a merge ...
0
votes
1answer
894 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 ...
2
votes
0answers
278 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
0answers
30 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
0answers
105 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
78 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 ...
1
vote
0answers
34 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
0answers
97 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
0answers
601 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
0answers
380 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
0answers
114 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
0answers
85 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
0answers
705 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
0answers
41 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 ...
0
votes
0answers
35 views

How do I turn html tags in word to formatted text

I'm trying to make multiple documents using mail merge and an access database, but there is one field where in Access I have it saved as rich text. I need it as rich text because it's a single field ...
0
votes
0answers
15 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 ...
0
votes
0answers
83 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
0answers
222 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
0answers
110 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
86 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
32 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
50 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 ...
0
votes
0answers
109 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 ...
0
votes
0answers
55 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
52 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
0answers
552 views

How can I send a mail merge from Thunderbird using my whole address book?

My bad old German email address has been hacked and is sending spam to everyone I know. I want to send a change of address to everyone in my Thunderbird address book in such a way that they don't all ...
0
votes
0answers
437 views

Microsoft Word 2010 mail merge doesn't work properly with custom macro

I use mail merge to generate letters. These are then merged into one large document which I used to use a splitter for when using Word 2003. Now I am using Word 2010 and when I run the macro it edits ...