Email a single Excell Worksheet as PDF

[semry]

I need to Email a single Excel worksheet (Status) from a multi sheet workbook (Assignment) as a PDF attachment to multi recipients. Any ideas?

 

[boblarson]

You would have to have code to copy that sheet into a new workbook and send that. So, what exactly does the process look like? What is it that you intend to do (the steps involved)? Do you mean to open the workbook and select a sheet and then do it? Or how exactly and from where (Access, Excel, etc.)?

 

[semry]

I want to do it from the Excel Workbook (Assignments) it is stored in using a command button. I already have a button that sends a separet workbook via outlook with the code below. but I can't get it to send one sheet from the active workbook.

Sub SendWorkbook()

Range("B12").Select

Stg = ActiveCell.Value
FileStg = Stg & ".xlsx"
SbjctLn = "Error Log " & ActiveCell.Value
Windows(FileStg).Activate

RecTo = "Misty Edwards"
ActiveWorkbook.SendMail _
Recipients:=RecTo, _
Subject:=SbjctLn

Windows("Assigments.xlsm").Activate
Sheets("Main").Select

End Sub

 

[semry]

I found my answer from a 2010 post from Rural Guy who posted the following link

http://www.granite.ab.ca/access/email.htm

Thanks
RG