<div>
You'd be better off just doing something like a powershell script to generate the email.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42696398-1"><span>$ol = New-Object -comObject Outlook.Application </span>
<span>$message = $ol.CreateItem(0)</span>
<span>$message.Recipients.Add(&quot;Useremail&quot;)  </span>
<span>$message.Subject = &quot;Website deployment&quot;  </span>
<span>$message.Body = &quot;See attached file for the updates made to the website`r`n`r`nWarm Regards`r`nLuke&quot;</span>
<span>$file = &quot;K:\Deploy-log.csv&quot;</span>
<span>$attachment = new-object System.Net.Mail.Attachment $file</span>
<span>$message.Attachments.Add($attachment)</span>
</code></pre>
</div>


Database Developer

LillyC

<div>
<div class="content wysiwyg-content">
Is it possible to setup an email that automatically attaches several pdf's (once initially setup) to one recipient?<br />
So that I can quickly and easily send a new employee their handbook and policies without having to attach each one individually?
</div>
</div>


Is it possible to setup an email that automatically attaches several pdf's (once initially setup) to one recipient?
So that I can quickly and easily send a new employee their handbook and policies without having to attach each one individually?

Attaching several PDFs to an email in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.