{"id":180,"date":"2016-02-22T22:00:49","date_gmt":"2016-02-22T21:00:49","guid":{"rendered":"http:\/\/sciencebear.info\/public\/?p=180"},"modified":"2019-08-28T14:50:36","modified_gmt":"2019-08-28T13:50:36","slug":"ms-word-serienbrieffelder","status":"publish","type":"post","link":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/","title":{"rendered":"Microsoft Word &#8211; Serienbrieffelder"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Allgemeines<\/h2>\n\n\n\n<p>Strg+F9 f\u00fcgt ein neues Paar Formelklammern <code>{}<\/code> in Word-Dokumente ein.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bedingte Ausgaben<\/h2>\n\n\n\n<p>Durch&nbsp;manuelle&nbsp;Bearbeitung&nbsp;von Feldfunktionen k\u00f6nnen Funktionen bzw. Formelklammern zur bedingten Ausgabe von Serienbriefdaten ver\u00adschachtelt&nbsp;werden. Im Gegensatz zu LibreOffice fehlt ein Dialogsystem, mit dem&nbsp;verschachtelte Formeln \u00fcber einen Assistenten eingegeben werden k\u00f6nnen.<\/p>\n\n\n\n<p>Bsp. 1:&nbsp;geschlechtsspezifische Anrede \u00fcber Serienbrieffeld (Spaltenname sex):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sehr geehrte<code>{ IF &nbsp;{ MERGEFIELD \"sex\"&nbsp;} = \"male\" \"r Herr\" \"Frau\" }<\/code>,<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Barcodes (ab Word 2013)<\/h2>\n\n\n\n<p>Bsp. 1:&nbsp;Barcode mit festem Text (hier eine ISBN als&nbsp;EAN13):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{ DISPLAYBARCODE \"9783885796404\" EAN13 }<\/code><\/pre>\n\n\n\n<p>Bsp. 2:&nbsp;QR-Code aus Serienbrieffeld (etwa eine URL):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{ DISPLAYBARCODE { MERGEFIELD \"url\" } QR }<\/code><\/pre>\n\n\n\n<p>M\u00f6gliche Argumente f\u00fcr Barcodetypen:&nbsp;UPCA , UPCE, JAN13, JAN8, EAN13, EAN8, CASE, ITF14, NW7, CODE39, CODE128, JPPOST, QR<\/p>\n\n\n\n<p>Die Funktion Displaybarcode taucht nicht im Dialog der Feldbefehle auf und muss manuell durch&nbsp;Einblenden der Feldfunktionen als Text eingegeben werden.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Formatierte&nbsp;Datenausgabe<\/h2>\n\n\n\n<p>Mit Feldparameter <strong>\\@<\/strong> k\u00f6nnen Datumsfelder umformatiert werden:<\/p>\n\n\n\n<p>Bsp 1.: langes englisches Datum (February 10. 2016):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{ MERGEFIELD \"geburstag\" \\@ \"MMM dd. yyyy\" }<\/code><\/pre>\n\n\n\n<p>F\u00fcr Zahlen analog&nbsp;durch Verwendung von Parameter \\# und einer Formatzeichenkette. Diese Format\u00adzeichenketten sind identisch mit denen, die in Excel bei der Zellformatierung verwendet werden.<\/p>\n\n\n\n<p>Bsp 2.: Serienfeld mit Inhalt 120500 mit Tausendertrennzeichen und zwei Nachkommastellen (120.500,00):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{ MERGEFIELD \"balance\" \\# \"#.##0,00\" }<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Dieser Beitrag enth\u00e4lt einige Beispiele und Tipps zur Verwendung von Serienbrieffeldern in Microsoft Word.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[8],"class_list":["post-180","post","type-post","status-publish","format-standard","hentry","category-tutorial","tag-microsoft-office"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Word - Serienbrieffelder &#8226; ScienceBear<\/title>\n<meta name=\"description\" content=\"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Word - Serienbrieffelder &#8226; ScienceBear\" \/>\n<meta property=\"og:description\" content=\"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\" \/>\n<meta property=\"og:site_name\" content=\"ScienceBear\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-22T21:00:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-28T13:50:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2015\/04\/rock-1839298_1920-e1566998263420.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andr\u00e9\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@andrek81\" \/>\n<meta name=\"twitter:site\" content=\"@andrek81\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andr\u00e9\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\"},\"author\":{\"name\":\"Andr\u00e9\",\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640\"},\"headline\":\"Microsoft Word &#8211; Serienbrieffelder\",\"datePublished\":\"2016-02-22T21:00:49+00:00\",\"dateModified\":\"2019-08-28T13:50:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\"},\"wordCount\":183,\"publisher\":{\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640\"},\"keywords\":[\"Microsoft Office\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\",\"url\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\",\"name\":\"Microsoft Word - Serienbrieffelder &#8226; ScienceBear\",\"isPartOf\":{\"@id\":\"https:\/\/sciencebear.info\/public\/#website\"},\"datePublished\":\"2016-02-22T21:00:49+00:00\",\"dateModified\":\"2019-08-28T13:50:36+00:00\",\"description\":\"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.\",\"breadcrumb\":{\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/sciencebear.info\/public\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Word &#8211; Serienbrieffelder\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sciencebear.info\/public\/#website\",\"url\":\"https:\/\/sciencebear.info\/public\/\",\"name\":\"ScienceBear\",\"description\":\"Wer nur tut, was er kann, wird nie mehr, als er ist. (Ford)\",\"publisher\":{\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sciencebear.info\/public\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640\",\"name\":\"Andr\u00e9\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2019\/07\/2019-07-09-Andr\u00e9.png\",\"contentUrl\":\"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2019\/07\/2019-07-09-Andr\u00e9.png\",\"width\":715,\"height\":971,\"caption\":\"Andr\u00e9\"},\"logo\":{\"@id\":\"https:\/\/sciencebear.info\/public\/#\/schema\/person\/image\/\"},\"description\":\"Developer\",\"sameAs\":[\"http:\/\/sciencebear.info\",\"https:\/\/www.instagram.com\/euro_bear\/\",\"https:\/\/www.linkedin.com\/in\/andre-sciencebear\/\",\"https:\/\/x.com\/andrek81\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Word - Serienbrieffelder &#8226; ScienceBear","description":"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/","og_locale":"de_DE","og_type":"article","og_title":"Microsoft Word - Serienbrieffelder &#8226; ScienceBear","og_description":"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.","og_url":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/","og_site_name":"ScienceBear","article_published_time":"2016-02-22T21:00:49+00:00","article_modified_time":"2019-08-28T13:50:36+00:00","og_image":[{"width":1920,"height":480,"url":"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2015\/04\/rock-1839298_1920-e1566998263420.jpg","type":"image\/jpeg"}],"author":"Andr\u00e9","twitter_card":"summary_large_image","twitter_creator":"@andrek81","twitter_site":"@andrek81","twitter_misc":{"Verfasst von":"Andr\u00e9","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#article","isPartOf":{"@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/"},"author":{"name":"Andr\u00e9","@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640"},"headline":"Microsoft Word &#8211; Serienbrieffelder","datePublished":"2016-02-22T21:00:49+00:00","dateModified":"2019-08-28T13:50:36+00:00","mainEntityOfPage":{"@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/"},"wordCount":183,"publisher":{"@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640"},"keywords":["Microsoft Office"],"articleSection":["Tutorial"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/","url":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/","name":"Microsoft Word - Serienbrieffelder &#8226; ScienceBear","isPartOf":{"@id":"https:\/\/sciencebear.info\/public\/#website"},"datePublished":"2016-02-22T21:00:49+00:00","dateModified":"2019-08-28T13:50:36+00:00","description":"Kurze \u00dcbersicht \u00fcber Funktionen und Parameter von Microsoft Word Serienbrief-Feldern. U.a. f\u00fcr Fallunterscheidungen (z.B. Anrede), oder Werte-Formatierung.","breadcrumb":{"@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sciencebear.info\/public\/2016\/ms-word-serienbrieffelder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/sciencebear.info\/public\/"},{"@type":"ListItem","position":2,"name":"Microsoft Word &#8211; Serienbrieffelder"}]},{"@type":"WebSite","@id":"https:\/\/sciencebear.info\/public\/#website","url":"https:\/\/sciencebear.info\/public\/","name":"ScienceBear","description":"Wer nur tut, was er kann, wird nie mehr, als er ist. (Ford)","publisher":{"@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sciencebear.info\/public\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/19e093ed91934636837b99b00f5d7640","name":"Andr\u00e9","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/image\/","url":"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2019\/07\/2019-07-09-Andr\u00e9.png","contentUrl":"https:\/\/sciencebear.info\/public\/wp-content\/uploads\/2019\/07\/2019-07-09-Andr\u00e9.png","width":715,"height":971,"caption":"Andr\u00e9"},"logo":{"@id":"https:\/\/sciencebear.info\/public\/#\/schema\/person\/image\/"},"description":"Developer","sameAs":["http:\/\/sciencebear.info","https:\/\/www.instagram.com\/euro_bear\/","https:\/\/www.linkedin.com\/in\/andre-sciencebear\/","https:\/\/x.com\/andrek81"]}]}},"_links":{"self":[{"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/posts\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/comments?post=180"}],"version-history":[{"count":8,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"predecessor-version":[{"id":684,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/posts\/180\/revisions\/684"}],"wp:attachment":[{"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sciencebear.info\/public\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}