The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
30 views

Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...
1
vote
1answer
25 views

word - merge mailing with specific fields if another specific field has a certain value

I want to do a merge mailing and I got the following issue My word document is on the screenshot capture below I want to put specific merge fields like adr_A1 in Adresse1when my specific ...
0
votes
0answers
19 views

Automatically scale font size to fit text box

I am currently setting up a mail merge but I need the size of text in a text box to scale. I want the font size to be the biggest I can whilst fitting in the text box. I've searched around, but I ...
0
votes
0answers
26 views

Mail Merge Multiple IF Conditions for cell

I have a conditional statement for two cases (and default) which works fine. This is simply to enter a cell value based on another cell value in an earlier column simplified and shorm of extraneous ...
1
vote
0answers
16 views

Mail merge record not stay next to others, split by Section breaks [closed]

I have a picture with an text field inside it. I want to use mail merge to auto fill this textfield with 20 different numbers. When I use mail merge, each record stay in a page, and split with the ...
0
votes
0answers
13 views

Microsoft Word for Mac adding shadows to merge fields

I recently installed Microsoft Word for Mac (2016), which seems to be a vast improvement over previous Mac editions. However, after creating a graphically complex (lots of shapes and text boxes) ...
1
vote
1answer
15 views

How to pull addresses from word to use in Mail Merge?

I am trying to figure out how to pull addresses from a Rich Text Doc. in Microsoft word to use the mail merge in Microsoft Access. This is being used for work and I need something as quick as ...
0
votes
1answer
51 views

How to concat mail merge IF fields in Word 2013

I have Word 2013 and I have a need to display a piece of text only if a mail merge field equals 1. Simple: { IF {MERGEFIELD Discount} = 1 "You get a discount" "You don't get a discount" } However, ...
1
vote
1answer
19 views

Microsoft Word 2010 mail merge - statement overdue calculations

My company hosts various events for clients (conference meetings, receptions, holiday parties, etc.). After an event is completed, we send out invoices. Monthly we also send out statements for all ...
0
votes
0answers
7 views

How do I set conditions in a mail merge in Publisher 07?

I want to do a mail merge where if a field is blank or empty, something else should be printed. How do I do that? Also, I used a mask for inputting phone numbers, but they are coming out 1234567890, ...
0
votes
0answers
32 views

MailMerge change Picture Size [Word2013]

I have a word document witch I'm using as a Template for my MailMerge. My problem is, that when I insert the Pictures into the document the pictures are too big. I want them to have a 50 px width ...
0
votes
2answers
124 views

Word 2010 Mail Merge Suppress Blank Conditional Mergefields

I cannot get a conditional Mail Merge to suppress blank lines in a relatively clean and efficient way. The only solution I have found is one I am not willing to use yet as I feel there may be a better ...
0
votes
0answers
23 views

How to mail merge in a protected document or simular

I'm trying to do a mail merge with protected templates which Microsoft will not allow for some reason does anybody no of a work around or an alternate solution. The reason it is a protected document ...
0
votes
1answer
183 views

Mail merge alternative

I have a template Word document which I use when writing supporting technical documents to send with CAD drawings. Due to the nature of the product we create, this accompanying technical note is ...
0
votes
0answers
33 views

MS Word 2013 Mail Merge: I can't seem to make it retain formatting

I am doing a merge in MS Word 2013, I have a part of the document that says: Dr. «Contacts_Last_Name» When I Toggle Field Codes, it says: Dr. {MERGEFIELD Contacts_Last_Name} I have tried to format ...
0
votes
0answers
27 views

Is there an equivalent to CTRL+F9 in Microsoft Publisher 2007?

I'd like to be able to edit the fields in my Microsoft Publisher based mail merge. In MS-Word there is a feature where you can press CTRL+F9 and add things like if statements and images instead of ...
2
votes
1answer
1k views

How do I attach a PDF document to an email merge using Outlook and Word

How do I attach a PDF document to an email merge using Outlook and Word. The merge is ready to go but I don't see a place to attach a file.
0
votes
0answers
27 views

3-level Mail Merger

I need to do a 3-level mail merge in Word 2010. I have done to 2-levels(with the help of these documents https://support.microsoft.com/en-us/kb/211303, Mail Merge - Multiple Rows Into One Document but ...
0
votes
1answer
19 views

Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards. Can this be done and how do I go about doing it? I really don't want to create ...
1
vote
1answer
110 views

Multi-line merge fields and line spacing

A database field contains several lines. When the field is merged in the Word document, each line becomes a paragraph, therefore each of them get the paragraph spacing. Example: «my_merge_field» ...
2
votes
0answers
91 views

Suppressing Blank Mergefields in Word 2010 Mail Merge

I'm working on combining two mail merge letters into a Master template that will know which merge letter to populate based on information in a specific column. I have successfully combined the two ...
0
votes
0answers
18 views

Setting hard text container size for Mail Merge?

I'm having issues with ensuring the layout of my Mail Merge document because some fields being inputted are either too long or too short. Is there a way to make a field (like a table cell) just cut ...
1
vote
1answer
47 views

Libreoffice: Import columns of spreadsheet as fields

I have a LibreOffice Calc spreadsheet with Columns A, B, C. I would like to create a document in LibreOffice Writer with format: A1 B1 C1 A2 B2 C2...
0
votes
1answer
158 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
0answers
27 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
1answer
90 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
49 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 ...
1
vote
0answers
37 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
1answer
95 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 \ ...
0
votes
1answer
169 views

Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...
0
votes
1answer
180 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
0answers
45 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
2answers
143 views

Identifying and Replacing French Characters in Excel for Email Value

How do I identify the character é in a value and replace it with e? I am using Excel to hold data for a MailMerge. Each column represents a piece of data that is either used in the MailMerge or ...
0
votes
1answer
541 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
134 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

mail merge to separate documents with filename based on Merge field

I'm doing a mail merge from a Access database and I'd like to make many documents from the mail merge, instead of just one. I found a macro that lets me split the merged document after it's made, that ...
0
votes
0answers
159 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
2answers
1k 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. ...
1
vote
1answer
105 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
8k 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
199 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
276 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
2k 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
2answers
954 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
261 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
113 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
2k 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
431 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
460 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 ...
1
vote
3answers
5k 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 ...