<div>
That isn't the problem. We are use Groupwise 7 for the email client. There is no pop-up about sending an attachment.<br />
<br />
It a matter that the attachment goes out as a blank document instead of having data in it.
</div>


<div>
&gt;&gt; Not really pretending to know how to fix your problem,................<br />
<br />
I'll check into it on our end users tomorrow.<br />
<br />
But anyone else keep the ideas coming.
</div>


<div>
JOrzech,<br />
<br />
That's a negative, Ghost Rider.<br />
<br />
It didn't work.<br />

<pre><code class="code-1 nolinks" id="code-125009"><span>Public Function Send_Test()</span>
<span>'Below leaves you with a blank document</span>
<span>DoCmd.SendObject acSendTable, &quot;LSWNBU&quot;, acFormatXLS, &quot;user@MyDomain.com&quot;, , , _</span>
<span>    &quot;Test No Edit&quot;, &quot;This is a test send&quot;, False</span>
<span>'This works fine</span>
<span>DoCmd.SendObject acSendTable, &quot;LSWNBU&quot;, acFormatXLS, &quot;user@MyDomain.com&quot;, , , _</span>
<span>    &quot;Test Edited&quot;, &quot;This is a test send&quot;, True</span>
<span>End Function</span>
</code></pre>
</div>


<div>
Well good luck <br />
Ghost Rider ... sorry I couldn't be of more assistance.<br />

</div>


<div>
&gt;&gt; I'm guessing you have seen this:<br />
<br />
I hadn't seen that one. &nbsp;I came up with this routine: <a href="http:/Q_23257730.html" rel="ugc">http:/Q_23257730.html</a>&nbsp;and it works. Just the legacy apps we have we would have to go back and re-program.<br />
<br />
Not an acceptable answer.
</div>


<div>
Thank you for the grade - glad that the team effort was able to help and you go your solution!!!<br />
<br />
Kevin
</div>


<div>
<div class="content wysiwyg-content">
Just recently, we began experiencing problems when sending e-mails from our Access databases using DoCmd.SendObject and editmessage = false. These e-mails, if they have attachments are being sent to the recipient with the attachment being blank. After doing some testing, it was found if we switch editmessage = true and the message pops up and the user clicks Send, the attachment displays fine.<br />
&nbsp;<br />
That was an acceptable workaround for the moment for our Access programs. However, now we have an Excel spreadsheet that within the macro uses ActiveWorkbook.SendMail. The only options for this function is Recipients, Subject and Return Receipt. There is no way to allow the user to have the e-mail appear to send it manually. This applications sends out 100+ e-mails and attaches various spreadsheets to the e-mails depending on the receiving department. <br />
&nbsp;<br />
The question is what has caused this issue? We believe it may have had something to do with a recent windows update.<br />
&nbsp;<br />
Thanks.
</div>
</div>


Just recently, we began experiencing problems when sending e-mails from our Access databases using DoCmd.SendObject and editmessage = false. These e-mails, if they have attachments are being sent to the recipient with the attachment being blank. After doing some testing, it was found if we switch editmessage = true and the message pops up and the user clicks Send, the attachment displays fine.
 
That was an acceptable workaround for the moment for our Access programs. However, now we have an Excel spreadsheet that within the macro uses ActiveWorkbook.SendMail. The only options for this function is Recipients, Subject and Return Receipt. There is no way to allow the user to have the e-mail appear to send it manually. This applications sends out 100+ e-mails and attaches various spreadsheets to the e-mails depending on the receiving department. 
 
The question is what has caused this issue? We believe it may have had something to do with a recent windows update.
 
Thanks.

Blank Attachments in e-mail from MS Office Apps

Groupware, also known as collaborative software, is a type of application software designed to help people involved in a common task to achieve their goals. Software products such as email, calendaring, text chat, wiki, and bookmarking belong to this category whenever used for group work, usually in a workplace environment (as opposed to a social networking environment). Most popular groupware applications include Contact Management,MS Server Apps, Cloud Computing, Version Control, Chat/IM, Email Software, Conferencing Software, Outlook, Office Suites, Project Management Software, Content Management, Virtualization, and Cloud Services.

Groupware

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.