View original (French)

Mailing: Email + Attachment

Thetoinou45 Posted messages 3 Status Member -  
Thetoinou45 Posted messages 3 Status Member -
Hello,

I run an association and I have created a mail merge for the registration forms. Indeed, I have an Excel document with all the information, and it is collected by the Word mail merge. Then I want to send the completed documents to each member as attachments via email. But there’s a problem: I would like to add text in the body of the message (the same for everyone). Word does not allow having an attachment AND text in the email.
How can I do this?
Thank you

2 answers

  1.
    m@rina Posted messages 27623 Registration date   Status Moderator Last intervention   11 563
     
    Hello,

    "Word doesn't want there to be an attachment AND text in the email."

    Yes, Word doesn't want that! If you are using Outlook, here is a solution that involves an Outlook macro. Follow the instructions carefully:
    https://faqword.com/index.php/word/tutos/toutes-versions/670-publipostage-et-pj

    m@rina

    --
    I am Charlie
    0
    1. Thetoinou45 Posted messages 3 Status Member
       
      The problem is that the attachment "is the mail merge"; basically, Outlook sends the email with the Word document containing each person's information. So each attachment is different, only the message text is unique.
      0
    2. m@rina Posted messages 27623 Registration date   Status Moderator Last intervention   11 563
       
      So we would need to complicate the macro.
      Personally, I don't program Outlook, but I think it should be possible by giving each attachment the name of the recipient. And we would add a loop to specify if the recipient = toto, attach toto...
      Not necessarily simple though.
      If I see Oliv, I'll ask him the question.

      m@rina
      0