Mail merge Word with a PDF attachment

Hello,

There is a workaround that can be applied if the number of emails is not too large. This solution is a manual process that requires a bit of time.

The first step is to set Outlook to "offline" mode.
Then, you create your mailing from Word using the mail merge feature (the usual process for emailing from Word).
All the personalized emails will be stuck in the outbox.
You just need to open them one by one, attach the files you want, and confirm the email by clicking "send".
Once all your emails are modified with the attachments and waiting to be sent, you reconnect Outlook, and the emails will be sent.

Hello

I've been facing the same issue for several months now.

For now, I've resolved it by using the mailing assistant in Writer from Open Office, which offers the option to send the merged document as an attachment in Open Office, Word, HTML, or PDF format.

I am also looking for the same solution directly in Word because mail merging with Open Office is still more complicated than with Word.

Thank you

You want the mail merge letters in Word to be PDFs so you can send them by email. Is that correct?
--
Remember to mark your messages as resolved when they are.
For those that are anonymous, please notify the mods with the yellow triangle that your subject is resolved.
Thank you.

Super, thanks!!

I also made a few small changes to the VB macro (my Outlook wouldn't accept it):

Public publipostagePJ As Variant
Sub setPublipostage()
On Error Resume Next
If publipostagePJ(0) = "" Then publipostagePJ = Array("fin", "fin", "fin", "fin", "fin", "fin", "fin", "fin", "fin", "fin")
While publipostagePJ(i) <> "fin"
contenu = contenu & vbCr & publipostagePJ(i)
i = i + 1
Wend
If contenu = "" Then contenu = "vide"
modifier = MsgBox(contenu & vbCr & "Would you like to choose a file to attach?", vbYesNo, "Configured files")
If modifier = vbYes Then
For i = 0 To 9
If i > 0 Then encore = MsgBox("another one?", vbYesNo)
quest:
If encore <> vbNo Then
PJ = InputBox("Location of the file to attach to the MAIL MERGE?", "MAIL MERGE Configuration for the session", publipostagePJ(i))
MsgBox "Your mail merge must include the term:" & vbCr & "MAIL MERGE" & vbCr & "in the subject." & vbCr & "This will be removed upon sending."
If "" = Dir(PJ, vbNormal) Then GoTo quest
publipostagePJ(i) = PJ
Else: Exit For
End If
Next i
End If
End Sub

Hello everyone,
Thank you for your posts, they really helped me today!! Long live the participants of CCM!!! Have a great day!

Hello everyone,

Thank you very much for your suggestions!!

I am having a little problem at the last step..

I have entered the precise path; the window warning that "the word MAILING must appear in the subject" is showing fine.

However, when I click OK, it takes me back to the previous window, that is, entering the file path, and it keeps looping like this.....

Could someone provide an explanation for this??

Thank you in advance and have a great day!!

Great tutorial.
Thank you.

Everything worked, but the next day, error message:
"Macros for this project are disabled."

How to enable the macro? (which is indeed present in the list of macros

Thank you.

Hello,

There is no native Word solution to perform a mail merge with an attachment. The only existing solution is to send the email text as an attachment.

That said, with an Outlook macro, it can be done. The macro was written by Oliv' for the Outlook FAQ, and I have explained how it works here:
http://faqword.fr/...

Follow the procedure carefully and you shouldn't encounter any issues.

m@rina
--
Please do not ask me questions in private messages...
I definitely do not respond to them... The forum is made for that.

Hello,

Just a small clarification regarding the VB macro in Outlook; it works well in Office 2010. You just need to correct the following two lines:

PJ = InputBox("Location of the attachment for the MAIL MERGE?", "MAIL MERGE setup for the session", publipostagePJ(i))

MsgBox "Your mail merge must contain the term:" & vbCr & "MAIL MERGE" & vbCr & "in the subject." & vbCr & "This will be removed upon sending"

which should be on the same line; with just a space separating them.

Happy mailing.

Olivier