The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
3answers
34 views

Printing multiple sheets with Mail Merge (Excel/Word)

I need to create letters with MS Word. On each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to find a way to ...
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 ...
0
votes
0answers
32 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
26 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 ...
1
vote
2answers
3k 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
0answers
27 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
57 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, ...
0
votes
2answers
146 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 ...
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
33 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
1answer
190 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
2answers
964 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
0answers
25 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 ...
3
votes
3answers
37k 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 ...
0
votes
0answers
34 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
3answers
3k 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 ...
0
votes
0answers
28 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 ...
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 ...
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
28 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
118 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 ...
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
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
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 ...
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 ...
0
votes
1answer
160 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
190 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 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 ...
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
174 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 ...
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
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
145 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
552 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
163 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. ...
2
votes
1answer
1k views

Dynamic row height on Word tables, based on mail-merged contents

I'm working with Word templates which contain nested tables of mail-merged fields. I need the row height of one of the child tables to have a minimum height but be able to expand (height only not ...
1
vote
1answer
202 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
4k 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 ...