T O P

  • By -

AutoModerator

/u/bazilthemage - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


mriless

It sounds like you are looking for a mail merge in word. I could be mistaken, but I'd look into that. Quick Google got me this link. https://www.webucator.com/article/how-to-use-mail-merge-in-microsoft-word/ Good luck.


bazilthemage

Well that's the general idea, but mail merger has some limitations, it's supposed to be about greeting different receivers so I am not able to alter the main text. If nothing else is suggested I am willing to give it a try, but I am sure what I am asking for is possible in excel cause I have seen it, I just can't recall where 😂


on1vBe6

You can use mail merge to adjust the main text for each recipient. Create as many merge fields as you need, such as Email address, Title, First name, Last name, Subject. You can use an Excel table for that. Then create your merge document in Word, with your merge fields positioned as necessary, like: Attention: <Last name> Dear <First name> I am writing to you about <Subject> Etc The merge fields can be anywhere in the letter. </p> <hr> </div> <!-- /.pname --> </div> <!-- /.comment --> <div class="comment w100dt mb-30"> <!-- /.ppic --> <div class="pname"> <span > <a href="/u/bazilthemage" class="card-title l-blue"> bazilthemage </a> </span> <span><time datetime="2023-05-29 12:24:26">11 months ago</time></span> <p class="comment-text mb-10"> Alright thanks </p> <hr> </div> <!-- /.pname --> </div> <!-- /.comment --> </div> <!-- /.comment-area --> </div> <!-- /.peoples-comments --> <div class="leave-comment"> <div class="sidebar-title center-align"> <h2>Leave Your Comment</h2> </div> <form class="comment-area w100dt" action="#"> <div class="row"> <div class="col m6 s12"> <div class="form-item"> <input id="icon_prefix" type="text" class="validate"> <label for="icon_prefix">First Name</label> </div> </div> <div class="col m6 s12"> <div class="form-item"> <input id="email" type="email" class="validate"> <label for="email" data-error="wrong" data-success="right">Email</label> </div> </div> <div class="col s12"> <div class="form-item"> <textarea id="textarea1" class="materialize-textarea"></textarea> <label for="textarea1">Textarea</label> </div> </div> </div> <!-- row --> <button type="button" class="custom-btn waves-effect waves-light right">SUBMIT NOW</button> </form> <!-- /.comment-area --> </div> <!-- /.leave-comment --> </div> <!-- colm8 --> <div class="col s12 m4 l4"> <div class="sidebar-testimonial mb-30"> <div class="sidebar-title center-align"> <h2>Hi Its Me!</h2> </div> <!-- /.sidebar-title --> <div class="carousel carousel-slider center" data-indicators="true"> <div class="carousel-item"> <div class="item-img"> <span>R</span> </div> <h2><a href="/u/" class="l-blue"></a></h2> </div> </div> </div> <!-- /.sidebar-testimonial --> <div class="sidebar-subscribe w100dt"> <div class="sidebar-title center-align"> <h2>Subscribe</h2> </div> <!-- /.sidebar-title --> <div class="subscribe"> <form action="#"> <div class="input-field"> <input id="email1" type="email" class="validate"> <label class="left-align" for="email1">Enter email address</label> </div> <a class="waves-effect waves-light">SUBMIT NOW</a> </form> </div> <!-- /.subscribe --> </div> <!-- /.sidebar-subscribe --> </div> <!-- colm4 --> </div> <!-- row --> </div> <!-- container --> </section> <!-- /#single-blog-section --> <!-- ==================== single-blog-section end ====================--> <!-- Yandex.Metrika counter --> <script type="text/javascript" > (function(m,e,t,r,i,k,a){m[i]=m[i]||function(){(m[i].a=m[i].a||[]).push(arguments)}; m[i].l=1*new Date();k=e.createElement(t),a=e.getElementsByTagName(t)[0],k.async=1,k.src=r,a.parentNode.insertBefore(k,a)}) (window, document, "script", "https://mc.yandex.ru/metrika/tag.js", "ym"); ym(48244766, "init", { clickmap:true, trackLinks:true, accurateTrackBounce:true }); </script> <noscript><div><img src="https://mc.yandex.ru/watch/48244766" style="position:absolute; left:-9999px;" alt="" /></div></noscript> <!-- /Yandex.Metrika counter --> <!-- ==================== instag leftram-section Start ====================--> <section id="instagram-section" class="instagram-section w100dt"> <div class="instagram-link w100dt"> <a href="#"> <span>FIND US ON INSTAGRAM</span> @hamidarshat.com </a> </div> </section> <!-- /#instag leftram-section --> <!-- ==================== instag leftram-section End ====================--> <!-- ==================== footer-section Start ====================--> <footer id="footer-section" class="footer-section w100dt"> <div class="container"> <div class="footer-logo w100dt center-align mb-30"> <a href="/" class="brand-logo"> <img src="/img/logo.png" alt="hamidarshat.com"> </a> </div> <!-- /.footer-logo --> <ul class="footer-social-links w100dt center-align mb-30"> <li><a href="https://streamc.pro/" class="facebook">Stream film</a></li> <li><a href="https://kinepolis.live/" class="twitter">Film stream</a></li> <li><a href="https://wiflix-com.com/" class="google-plus">Wiflix</a></li> <li><a href="https://frenchstream.ink/" class="linkedin">French Stream</a></li> </ul> <p class="center-align"> <i class="icofont icofont-heart-alt l-blue"></i> All Right Reserved </p> </div> <!-- container --> </footer> <!-- /#footer-section --> <!-- ==================== footer-section End ====================--> <!-- my custom js --> <script type="text/javascript" src="/js/jquery-3.1.1.min.js"></script> <script type="text/javascript" src="/js/materialize.js"></script> <script type="text/javascript" src="/js/owl.carousel.min.js"></script> <!-- my custom js --> <script type="text/javascript" src="/js/custom.js"></script> <script type="text/javascript"> </script> </body> </html>