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
558 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
590 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
37 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
1answer
61 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
1answer
112 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
2k 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 ...
1
vote
1answer
114 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
38 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
569 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
433 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
296 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
135 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
21 views

adding image from excel to word using mail merge

I'm using mail merge to generate a word document from an excel sheet and some cells contain images (office 2013). Is it possible to export them as well to word directly with mail merge without putting ...
0
votes
1answer
16 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
0
votes
1answer
45 views

Word 2010 - Mail Merge multiple conditions

I am attempting to get mail merge to process certain conditions eg: if mergefield spouse = 1 and mergefield lawyer = 2 and mergefield children = 3 and mergefield parent = 4 add certain text or if ...
0
votes
1answer
94 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
53 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
1k 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
237 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
214 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
228 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
614 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
956 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
284 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
16 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
0answers
136 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
94 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
37 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
133 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
678 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
413 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
128 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
86 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
741 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
12 views

Issues with spacing when mail merging

I have set up a mail merge document in Word 2010, I have 4 colleagues (currently on Word 2007) who use the document, for two of them, when they merge it removes any spaces between mail merge fields - ...
0
votes
0answers
11 views

Retain email subject when sending mail merge via Publisher 2010?

I am using Publisher 2010 to send a mail merge via email. I choose "Finish & Merge" and then "Send Email Messages..." and finally, after entering a Subject, hit "Send." No problem! The expected ...
0
votes
0answers
28 views

How to retain formatting from other Word 2003 documents?

I have set up a master document in Word 2003, using numerous IF Fields. It has been set so that if mergefield = xyz in my database, then it uses document 123.doc (which has been set up separately). ...
0
votes
0answers
20 views

Mailmerge and HTML

There may be a better solution than this, I'm open to suggestions. I've pulled a CSV file from a database. The database is a repository of online form submissions, and the submissions are built from ...
0
votes
0answers
63 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
33 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
117 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
254 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
150 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
66 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
623 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
445 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 ...