• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code for converting an excel form to pdf and sending it as an email attachment

Xcelnewbie

New Member
Hi all - i would like to ask for your help in developing a function that will do the following:

- convert an excel form into pdf
- automatically opens up an email in lotus notes with the pdf as an attachment

I've tried to record a macro that will perform these tasks and below is the "code" that was generated:

Sub Macro1()
'
' Macro1 Macro
'

'
ExecuteExcel4Macro "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("Main").Select

End Sub

I'm hoping you could help me enhance the code. Thank you.
 
Back
Top