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 ...
jcaron's user avatar
  • 1,788
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. ...
Andy K's user avatar
  • 392
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 ...
DavidPostill's user avatar
  • 157k
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-...
teylyn's user avatar
  • 22.7k
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 ...
Yahoo Serious's user avatar
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.
Stuart P.'s user avatar
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 ...
SandroKSG's 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
Tanya's user avatar
  • 1,713
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 " " }{ ...
Borislav Ivanov's 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 ...
shibormot's user avatar
  • 251
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 ...
robinCTS's user avatar
  • 4,367
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 ...
Yuki Sun's user avatar
  • 1,613
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 ...
Charles Kenyon's user avatar
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))...
Rajesh Sinha's user avatar
  • 9,218
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 ...
HackSlash's user avatar
  • 4,693
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 \# &...
harrymc's user avatar
  • 479k
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 {...
Sandeep's user avatar
  • 1,160
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 ...
Charles Kenyon's user avatar
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 ...
Don Kirkby's user avatar
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+ ...
Viki Ji's user avatar
  • 482
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 ...
Saaru Lindestøkke's user avatar
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 ...
Robert Wm Ruedisueli's user avatar
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 ...
MarianD's user avatar
  • 2,706
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.
Yorik's user avatar
  • 4,561
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 ...
Simon Elms's user avatar
  • 1,005
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 ...
neydroydrec's 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 ...
teylyn's user avatar
  • 22.7k
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 ...
Tanya's user avatar
  • 1,713
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 ...
cnread's user avatar
  • 2,494
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 -- ...
teylyn's user avatar
  • 22.7k

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