5
votes
Multiple mail server provider for one domain is possible?
You can't split different e-mail addresses in the name domain to different e-mail providers just by the use of multiple MX records.
You can have multiple MX records, but they will apply for the whole ...
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.
...
3
votes
Multiple mail server provider for one domain is possible?
Can I have a multiple MX records for different mail providers?
No.
How many MX Records can I set up?
Each domain can only have 1 MX record at a time, allowing mail to only be delivered to that one ...
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-...
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 ...
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.
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 ...
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
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 " " }{ ...
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 ...
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 ...
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 ...
2
votes
Accepted
How can I update the data in an excel sheet so that it goes through to a word document mail merge
Update the data in Excel, with the Word document closed.
Open the primary merge document.
Connect it to the Excel data as the source.
Perform the merge.
If a merge is to a new document, that is no ...
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))...
2
votes
Insert Mergefield conditionally based on other Mergefield - MS Word
The curly brackets represent field braces, which you must insert by pressing Ctrl+F9 (you can't type them).
Press CTRL+F9
Type IF
Press CTRL+F9
Type "MERGEFIELD" and the name of the field
Go outside ...
2
votes
How to remove space between \b switch and mergefield value in Word
If you want to include negative formatting, add a semi-colon after the
first part.
The section after the semi colon dictates what to do with negative amounts.
Examples:
{MERGEFIELD AmountOwing \# &...
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 {...
1
vote
Accepted
Two switches do not work together in the mergefield field (\b and \@) for a date
You are correct, they will not work together.
You will need two separate fields.
The first field, with the two switches does not work, you are correct.
Below that are two fields in sequence with no ...
1
vote
Address labels with LibreOffice
I finally found some workable instructions that load the addresses directly from the spreadsheet.
Save the spreadsheet in ODS format. Make sure there are text labels at the top of each column.
Choose ...
1
vote
Word "mail merge" DOCTYPE
After inserting《Myname》Merge Field, select it and press Alt+F9, and then press Ctrl+F9 to add {} for {MERGEFIELD Myname}, as shown below.
Please note that the {} symbol must be added by pressing Ctrl+ ...
1
vote
Accepted
Text based auto generation mail merge
This script below:
Loads a text file
Loads a separate file that contains a list
Replaces the term {%FIELD1%} in the text file by the values in the list
For every replacement writes out a separate ...
1
vote
I'm having an issue with auto-populating gendered pronouns in a form letter
The simplest solution is to simply add a set of pronoun sets in the database.
If the pronoun sets are not filled on completing the form, they should default based on the filling of the gender ...
1
vote
Microsoft Excel mail merge Word - Birthday date wrong
The result is good, only the format of the cell is inappropriate.
Change the format of this cell to a date format.
The explanation:
Excel saves dates as number of days from December 31, 1899 (so ...
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.
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 ...
1
vote
Changing Language of Date Field in Mail Merge
I found the answer by luck (story below).
The format would be:
{MERGEFIELD meeting_date \@ "d ดดดด bbbb"}
Which returns:
8 กันยายน 2560
I found out this solution by using the insert date ...
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 ...
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 ...
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 ...
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 -- ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
mail-merge × 202microsoft-word × 147
microsoft-excel × 49
microsoft-word-2010 × 20
email × 16
microsoft-word-2007 × 10
microsoft-office × 9
csv × 8
microsoft-word-2013 × 8
microsoft-excel-2010 × 6
microsoft-outlook × 5
vba × 5
microsoft-word-2016 × 5
field-codes × 5
microsoft-publisher × 5
pdf × 4
microsoft-outlook-2010 × 4
microsoft-access × 4
microsoft-word-2003 × 4
worksheet-function × 3
printing × 3
thunderbird × 3
microsoft-excel-2013 × 3
date × 3
text-formatting × 3