{"id":607,"date":"2021-11-14T13:25:05","date_gmt":"2021-11-14T12:25:05","guid":{"rendered":"http:\/\/declick.be\/?page_id=607"},"modified":"2022-09-22T08:02:39","modified_gmt":"2022-09-22T06:02:39","slug":"4-word-mailing-courrier-et-avis","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/4-word-mailing-courrier-et-avis\/","title":{"rendered":"Word : publipostage, mod\u00e8le et formulaire"},"content":{"rendered":"\n<p>Ce cours traite de publipostage et de cr\u00e9ation de mod\u00e8les. Les parties pourraient \u00eatre trait\u00e9es ind\u00e9pendamment l\u2019une de l\u2019autre mais vue leur compl\u00e9mentarit\u00e9, il m\u2019a sembl\u00e9 judicieux de les associer. Une 3\u00e8me partie optionnelle est ajout\u00e9e et sera envisag\u00e9e si le temps le permet : l&rsquo;\u00e9tude de la cr\u00e9ation de formulaires.<\/p>\n\n\n\n<p>Voici de fa\u00e7on succincte le programme des 3 th\u00e8mes abord\u00e9s&nbsp;:<\/p>\n\n\n\n<p><strong><em>Les mod\u00e8les&nbsp;:<\/em><\/strong> ce sont des fichiers qui contiennent toute une s\u00e9rie d\u2019\u00e9l\u00e9ments pr\u00e9d\u00e9finis afin de cr\u00e9er un document. Les mod\u00e8les sont constitu\u00e9s de 2 types d\u2019\u00e9l\u00e9ments&nbsp;: des \u00e9l\u00e9ments visibles (une adresse de soci\u00e9t\u00e9, un logo, une formule de politesse, \u2026) et des \u00e9l\u00e9ments invisibles (des styles, des raccourcis clavier, \u2026).<\/p>\n\n\n\n<p>L\u2019\u00e9tude de ce th\u00e8me se compose des chapitres suivants&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>R\u00e9vision des mises en page simples&nbsp;: pr\u00e9sentation d\u2019une lettre, insertion d\u2019un logo, alignement d\u2019\u00e9l\u00e9ments dans la verticalit\u00e9 (tableau, tabulation).<\/li><li>Les styles.<\/li><li>La cr\u00e9ation et la modification de mod\u00e8le (*.dotx).<\/li><li>L\u2019utilisation des mod\u00e8les.<\/li><\/ul>\n\n\n\n<p><strong><em>Le publipostage&nbsp;:<\/em><\/strong> association d\u2019un document (Word par exemple) \u00e0 une source de donn\u00e9es (liste Excel, base de donn\u00e9es Access, tableau Word, contacts Outlook, \u2026) afin de cr\u00e9er des lettres, \u00e9tiquettes, enveloppes reprenant les donn\u00e9es de notre source de donn\u00e9es (nom, pr\u00e9nom, adresse, \u2026).<\/p>\n\n\n\n<p>En voici les diff\u00e9rents points de l\u2019\u00e9tude&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Cr\u00e9ation de la source de donn\u00e9es&nbsp;: tableau Excel, base de donn\u00e9es Access (si demande des participants).<\/li><li>Cr\u00e9ation des diff\u00e9rents documents de publipostage&nbsp;: lettres, bons de commande, factures, \u2026<\/li><li>Association des documents pr\u00e9c\u00e9dents \u00e0 une source de donn\u00e9es.<\/li><li>Sauvegarde des documents de publipostage en tant que mod\u00e8les&nbsp;: int\u00e9r\u00eats, utilisation.<\/li><li>\u00c9tiquettes de publipostage.<\/li><li>Personnalisation et filtres des documents de publipostage.<\/li><li>Diff\u00e9rents types de fusion&nbsp;: imprimante, document, courrier \u00e9lectronique.<\/li><\/ul>\n\n\n\n<p><strong><em>La cr\u00e9ation de formulaire :<\/em><\/strong> document Word contenant des parties non modifiables.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Utilisation des contr\u00f4les de formulaires (zone de texte, liste, case \u00e0 cocher, &#8230;).<\/li><li>Protection de formulaire par sections. <\/li><\/ul>\n\n\n\n<p>Les mati\u00e8res seront \u00e9tudi\u00e9es par la <strong><em>r\u00e9alisation des exercices<\/em><\/strong> qui suivent. Les fichiers *Solution sont les r\u00e9sultats finaux \u00e0 obtenir ainsi que des consignes sur la r\u00e9alisation de l&rsquo;exercice :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/09\/Ex01_Attentes-Solution.dot\">Ex01_Attentes Solution.dot<\/a> : Fichier mettant en \u00e9vidence l&rsquo;utilisation des mod\u00e8les et des formulaires.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Lettre-Modele-Solution.dotx\">Ex02_Lettre Modele Solution.dotx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Lettre-Solution.docx\">Ex02_Lettre Solution.docx<\/a> : cr\u00e9ation d&rsquo;un mod\u00e8le et d&rsquo;un document \u00e0 partir de ce mod\u00e8le.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex03_Chuck-Berry-Consignes.doc\">Ex03_Chuck Berry Consignes.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex03_Chuck-Berry-Donnees.doc\">Ex03_Chuck Berry Donnees.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex03_Chuck-Berry-Photo.jpg\">Ex03_Chuck Berry Photo.JPG<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex03_Chuck-Berry-Solution.doc\">Ex03_Chuck Berry Solution.doc<\/a> : r\u00e9alisation d&rsquo;une pr\u00e9sentation type d&rsquo;une c\u00e9l\u00e9brit\u00e9 d&rsquo;un autre temps.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex04_LegendesRock-Solution.dot\">Ex04_LegendesRock Solution.dot<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex04_Jerry-Lee-Lewis-Solution.doc\">Ex04_Jerry Lee Lewis Solution.doc<\/a> : cr\u00e9ation d&rsquo;un mod\u00e8le \u00e0 partir de la pr\u00e9sentation type pr\u00e9c\u00e9dente et r\u00e9alisation d&rsquo;un document \u00e0 partir de ce mod\u00e8le.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex05_Publipostage_Version20xx.pdf\">Ex05_Publipostage_Version20xx.pdf<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex05_LettreTypeVierge.docx\">Ex05_LettreTypeVierge.docx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex05_LettreTypeSolution.docx\">Ex05_LettreTypeSolution.docx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex05_SourcePublipostageEmploi.xlsx\">Ex05_SourcePublipostageEmploi.xlsx<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex05_EtiquettesSolution.docx\">Ex05_EtiquettesSolution.docx<\/a> : un syllabus sur la publipostage et les fichiers annex\u00e9s \u00e0 ce syllabus.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex06_DonneesExcel.xls\">Ex06_DonneesExcel.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex06_datas.mdb\">Ex06_datas.mdb<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex06_LettreType.doc\">Ex06_LettreType.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex06_LettreType-Solution.doc\">Ex06_LettreType Solution.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex07_Etiquettes-Solution.doc\">Ex07_Etiquettes Solution.doc<\/a> : un exercice sur le publipostage et les 2 sources de donn\u00e9es utilis\u00e9es (Excel et Access).<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex08_ListeJoueurs.xls\">Ex08_ListeJoueurs.xls<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex08_ConvocationTournoi-Solution.doc\">Ex08_ConvocationTournoi Solution.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex09_EtiquettesJoueurs-Solution.doc\">Ex09_EtiquettesJoueurs Solution.doc<\/a> : autre exercice sur le publipostage et sa source de donn\u00e9es c\u00e9l\u00e8bre, l&rsquo;ATP.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex10_Facture-Modele-Solution.dotm\">Ex10_Facture Modele Solution.dotm<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex10_Facture-Solution.docx\">Ex10_Facture Solution.docx<\/a> : un mod\u00e8le associ\u00e9 \u00e0 une source de donn\u00e9es Excel avec des \u00e9l\u00e9ments de type &lsquo;formulaire&rsquo; et un document cr\u00e9\u00e9 \u00e0 partir de celui-ci.<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex11_Attentes.doc\">Ex11_Attentes.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex11_Attentes-Solution.doc\">Ex11_Attentes Solution.doc<\/a> : cr\u00e9ation du formulaire d&rsquo;introduction (Ex01).<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex12_FormulaireSection.doc\">Ex12_FormulaireSection.doc<\/a> &#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex12_FormulaireSection-Solution.doc\">Ex12_FormulaireSection Solution.doc<\/a> : exercice sur le verrouillage de sections dans un formulaire.<\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce cours traite de publipostage et de cr\u00e9ation de mod\u00e8les. Les parties pourraient \u00eatre trait\u00e9es ind\u00e9pendamment l\u2019une de l\u2019autre mais vue leur compl\u00e9mentarit\u00e9, il m\u2019a sembl\u00e9 judicieux de les associer. Une 3\u00e8me partie optionnelle&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-607","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":24,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/607\/revisions"}],"predecessor-version":[{"id":1194,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/607\/revisions\/1194"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}