• Hot Topics

Excel Excel Macro (VBA) sending active worksheet in PDF by Outlook

Dear all, Can anyone help me with this problem. I find out a code to create a PDF (with opening the Save As dialog box) from an active worksheet, but I can't find out how to send this PDF by e-mail (Outlook). The code is working till the words 'Set OutApp'. Please can anyone help me? Just what I want is to send the active worksheet as PDF (as attachment) by email (Outlook). Here the present code. Code: Sub ' ' Se ' Set Set

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of March 17, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel