Mailing: Email + Attachment

Thetoinou45 Posted messages 3 Status Membre -  
Thetoinou45 Posted messages 3 Status Membre -
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 réponses

m@rina Posted messages 27234 Registration date   Status Modérateur Last intervention   11 543
 
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
Thetoinou45 Posted messages 3 Status Membre
 
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
m@rina Posted messages 27234 Registration date   Status Modérateur Last intervention   11 543
 
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