4 votes
Accepted

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

I found my answer When you do an alt+F9, don't manually insert the {}. Instead do an ctrl+F9 then insert your mergefield MERGEFIELD adr_A1 between the newly created {}. It did the trick with me. ...
user avatar
  • 392
3 votes
Accepted

Mail merge equivalent for Excel

Build the table in Word, then use Excel as the data source and print the merged documents to PDF. That's the way mail merge works best. Excel does not have a mail merge functionality. You'd have to re-...
user avatar
  • 22.2k
3 votes

How to concat mail merge IF fields in Word 2013

Actually, I just found the answer to both my questions: It turns out that you cannot simply type a curly bracket { to use in mail merge. it has to be some kind of special curly bracket, which I found ...
user avatar
3 votes

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

There are a couple way to handle this. Use Dynamic Data Exchange Adjust the merge field properties in Word Format the numbers as text in Excel Since you have already made the merge connection, it ...
user avatar
  • 22.4k
2 votes

Remove mail merge data source from MS Word Document

This took me eternity so I thought I'd post an answer as well. In my case I had to remove the old template document, which triggered the query. This is possible in the developer tools menu, on the ...
user avatar
2 votes
Accepted

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

In notepad++ regular expression "[^\r]\n" will match LF, but not CRLF. Now replace this with whatever you want. This answer has useful information.
user avatar
  • 138
2 votes

MS Publisher 2013 mail merge - date field in excel file format issue

When viewing the field - NOT in Data Preview mode - you can select the field and change the format in the mailing tab.
user avatar
2 votes
Accepted

Libreoffice: Import columns of spreadsheet as fields

Yes, you can: Save your LibreOffice Calc spreadsheet (preferably with proper header-names and sheet-names) Make a new LibreOffice Base database with type Spreadsheet. (I find 'publishing' it, easier ...
user avatar
2 votes

How to Split and Rename files by Mail Merge Field

Try this link for an add-in for Word: http://www.gmayor.com/individual_merge_letters.htm
user avatar
  • 1,635
2 votes
Accepted

Word displays mail merge data from Excel with the wrong number of digits

When you mail merge, the actual stored value is used, not the displayed value. You need to set the stored value to the number of digits required. For example if the source value is in A1 you need to ...
user avatar
  • 4,287
2 votes
Accepted

Add CC recipient to mail merge Outlook 2013

There is no direct option to CC in mail merge but you can take advantage of the rule in Outlook as a workaround: When you are done with mail merge, go to Outlook and create a new rule to CC the ...
user avatar
  • 1,096
2 votes
Accepted

Concatenate to a field without using a separate field?

You are looking for '\f' switch: \f Specifies the text to be inserted following the MergeField field if the field is not blank. and the example: { MERGEFIELD CoutesyTitle \f " " }{ ...
user avatar
2 votes
Accepted

Word 2016: How can I rename a data source file, without having to recreate the data connection?

If it is docx format, then it can be done with following way: Extract xml(s) From it search for all occurrences file name in its contents and replace for new file name Then pack again. You can ...
user avatar
  • 231
2 votes

Excel Tables by Value

This Array Formula will solve the issue: How it works: Formula in Cell G88 to get Table by T- Shirt: {=IFERROR(INDEX($A$88:$A$92,SMALL(IF($B$88:$B$92=$F88,ROW($A$88:$A$92)-MIN(ROW($A$88:$A$92))...
user avatar
  • 8,761
1 vote

Hide a minus symbol from a word mailmerge field

You can do this by using numeric picture formats defined for merge fields. Follow these steps: Select merge field on document Press Shift + F9 to switch to field coding. You would see something like {...
user avatar
  • 1,132
1 vote

Word mail merge with two records per page

Set up the merge document as a label sheet where each label is one-half the page (2-up, 1 column). Then print it on plain paper.
user avatar
  • 4,004
1 vote
Accepted

Mail Merge Field in Rotated Text in a Label

I found a work-around that might be useful for others in a similar situation (these instructions apply to Office 365, as at November 2019): For a Label Mail Merge template document, Word seems to ...
user avatar
1 vote

Double Sided Flash Cards from Excel Document

Use Word Mail merge. Connect to the Excel workbook as the data source, then build the merge document. Put the Word field on the first page, format as desired, then insert a page break, so everything ...
user avatar
  • 22.2k
1 vote

Can you ask two nested IF questions for one mail merge response?

You can achieve your outcome by nesting IF fields. This IF test effectively says if Field = value (TRUE) then do something, otherwise (FALSE) do something else. If Field = value is true, then the ...
user avatar
  • 1,635
1 vote
Accepted

Looking for an alternative for MS WORD Mail Merge

You can use ASK and REF fields. At the beginning of the document, insert a series of ASK field, one for every bit of information that you need to reuse – for example: { ASK Addressee "Enter the ...
user avatar
  • 2,301
1 vote

Mailmerge 2 spreadsheets

Word does not support multiple data sources for a mail merge. You will need to use techniques in Excel to merge the data sources. Options include copy and paste, Microsoft Query, or -- the winner -- ...
user avatar
  • 22.2k
1 vote

Word 2010 Mail Merge Suppress Blank Conditional Mergefields

To suppress blank lines when mail merge fields in a mail merge main document are empty create the following code in a VBA Module. Sub SuppressBlankLines() ActiveDocument.MailMerge....
user avatar
1 vote

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

From Microsoft's Frequently asked questions about the mail merge feature in Word 2003, Word 2007, and Word 2010: Q15: Can I add an attachment when performing a merge to an e-mail message? A15: ...
user avatar
1 vote

Libreoffice: Import columns of spreadsheet as fields

You can do this using LibreOffice Base (the db component). Just create a new database with type Spreadsheet. It will handle the sheet's rows as datasets and the first row as field names. Now, you can ...
user avatar
  • 9,855
1 vote

Mail Merge comparison between fields

You need to use IF fields to insert conditional pieces of text. You can read more about IF fields in this great FAQ: http://word.mvps.org/faqs/mailmerge/mmergeiffields.htm
user avatar
  • 7,166
1 vote

mail merge to separate documents with filename based on Merge field

You can use a VBA script to separate the document into individual files. There are also various PDF print drivers such as PDF Creator that can either print individual PDF files automatically, or ...
user avatar
  • 6,052
1 vote

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

Try inserting another column to the worksheet, and using the formula =FORMAT(A2,"$0.00"), A2 of course would need to be changed to the column you are using. Then use the auto-fill to copy the formula ...
user avatar
  • 31
1 vote
Accepted

Changing a Mail Merge Word document to point to a new datasource?

Open: Merge Letter --> Mailings --> Start mail merge Step by step mail merge wizard --> select a different list Select 'Table' or 'Query' --> OK button to confirm Click on 'preview results' --> Save ...
user avatar
1 vote

How can I print out or copy merge fields?

For Word 2010 Go to FILE > Options > Advanced scroll down to the header title "Print" Click or check the box that reads "Print fields codes instead of their values" Hope this helps.
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible