Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas bileog oibre a sheoladh trí Outlook ó Excel amháin?

Más mian leat bileog oibre amháin a sheoladh ar ríomhphost as leabhar oibre in Excel trí Outlook, is féidir leat an bhileog oibre a sheoladh mar cheangaltán, mar ábhar coirp nó mar chomhad PDF. Ach an bhfuil aon bhealaí níos tapa ann chun déileáil leis an bhfadhb seo in Excel?

Seol bileog oibre aonair mar chomhlacht ó Excel le Seol chuig ordú Faighteora Ríomhphoist

Seol bileog oibre aonair mar cheangaltán ó Excel le cód VBA

Seol bileog oibre aonair mar chomhad PDF ó Excel le cód VBA


mboilgeog cheart gorm saighead Seol bileog oibre aonair mar chomhlacht ó Excel le Seol chuig ordú Faighteora Ríomhphoist

Tacaíonn Excel linn an bhileog oibre ghníomhach a sheoladh ar ríomhphost mar ábhar coirp trí úsáid a bhaint as an ordú Seol chuig Faighteoir Ríomhphoist. Is féidir leat a dhéanamh mar a leanas:

Má úsáideann tú Excel 2007, 2010 nó 2013, ní mór duit é seo a chur leis Seol chuig Faighteoir Ríomhphoist ordú don Barra Uirlisí Rochtana Tapa an chéad.

1. Cliceáil ar dheilbhín an Saincheap Barra Uirlisí Rochtana Tapa, agus roghnaigh Tuilleadh Orduithe, féach ar an scáileán:

doc-r-phost-bileog1

2. Agus sa Roghanna Excel bosca dialóige, roghnaigh Orduithe nach bhfuil sa Ribbon sa Roghnaigh Orduithe ó liosta anuas, ansin roghnaigh an Seol chuig Faighteoir Ríomhphoist rogha, agus cliceáil Cuir >> leis cnaipe chun an t-ordú seo a chur leis, cliceáil ar deireadh OK chun an socrú seo a shábháil. Féach an pictiúr:

doc-r-phost-bileog2

3. An Seol chuig Faighteoir Ríomhphoist tá ordú curtha isteach sa Barra Uirlisí Rochtana Tapa, féach ar an scáileán:

doc-r-phost-bileog3

4. Ansin cliceáil seo Seol chuig Faighteoir Ríomhphoist cnaipe deilbhín, agus tagann bosca pras amach, sa Ríomhphost bosca pras, seiceáil Seol an bhileog reatha mar chomhlacht na teachtaireachta, agus cliceáil OK. Féach an pictiúr:

doc-r-phost-bileog4

5. Agus bosca eagarthóireachta ríomhphoist ar taispeáint os cionn sonraí na bileoige oibre, is féidir leat d’fhaighteoirí, ábhar agus réamhrá a iontráil sa bhosca téacs comhfhreagrach. Féach an pictiúr:

doc-r-phost-bileog5

6. Ansin cliceáil Seol an Shee seot an bhileog oibre ghníomhach seo a sheoladh mar chomhlacht teachtaireachta chuig do dhuine ar leith.


mboilgeog cheart gorm saighead Seol bileog oibre aonair mar cheangaltán ó Excel le cód VBA

Más mian leat ríomhphost a sheoladh chuig an mbileog oibre ghníomhach mar cheangaltán, is féidir leis an gcód VBA seo a leanas fabhar a dhéanamh duit.

1. Gníomhachtaigh do bhileog oibre a theastaíonn uait a sheoladh.

2. Coinnigh síos an ALT + F11 eochracha, agus osclaíonn sé an Fuinneog Microsoft Visual Basic for Applications.

3. Cliceáil Ionsáigh > Modúil, agus greamaigh an cód seo a leanas sa Fuinneog an Mhodúil.

Cód VBA: seol an bhileog oibre reatha mar cheangaltán ó Excel

Sub SendWorkSheet()
'Update 20131209
Dim xFile As String
Dim xFormat As Long
Dim Wb As Workbook
Dim Wb2 As Workbook
Dim FilePath As String
Dim FileName As String
Dim OutlookApp As Object
Dim OutlookMail As Object
On Error Resume Next
Application.ScreenUpdating = False
Set Wb = Application.ActiveWorkbook
ActiveSheet.Copy
Set Wb2 = Application.ActiveWorkbook
Select Case Wb.FileFormat
Case xlOpenXMLWorkbook:
    xFile = ".xlsx"
    xFormat = xlOpenXMLWorkbook
Case xlOpenXMLWorkbookMacroEnabled:
    If Wb2.HasVBProject Then
        xFile = ".xlsm"
        xFormat = xlOpenXMLWorkbookMacroEnabled
    Else
        xFile = ".xlsx"
        xFormat = xlOpenXMLWorkbook
    End If
Case Excel8:
    xFile = ".xls"
    xFormat = Excel8
Case xlExcel12:
    xFile = ".xlsb"
    xFormat = xlExcel12
End Select
FilePath = Environ$("temp") & "\"
FileName = Wb.Name & Format(Now, "dd-mmm-yy h-mm-ss")
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
Wb2.SaveAs FilePath & FileName & xFile, FileFormat:=xFormat
With OutlookMail
    .To = "skyyang@extendoffice.com"
    .CC = ""
    .BCC = ""
    .Subject = "kte features"
    .Body = "Please check and read this document."
    .Attachments.Add Wb2.FullName
    .Send
End With
Wb2.Close
Kill FilePath & FileName & xFile
Set OutlookMail = Nothing
Set OutlookApp = Nothing
Application.ScreenUpdating = True
End Sub

nótaí: Sa chód thuas, is féidir leat an fhaisnéis seo a leanas a athrú go do riachtanas féin.

  • .To = "skyyang @extendoffice.com "
  • .CC = ""
  • .BCC = ""
  • .Subject = "gnéithe kte"
  • .Body = "Seiceáil agus léigh an doiciméad seo le do thoil."

4. Ansin cliceáil F5 eochair chun an cód seo a rith, agus tiocfaidh bosca pras amach, cliceáil Ceadaigh nuair a bheidh an barra dul chun cinn críochnaithe, agus ansin an bhileog oibre reatha seolta chuig d’fhaighteoir mar cheangaltán.

doc-r-phost-bileog6


mboilgeog cheart gorm saighead Seol bileog oibre aonair mar chomhad PDF ó Excel le cód VBA

Uaireanta, ní mór duit tuairisc do bhileog oibre a sheoladh chuig daoine eile ach níl tú ag iarraidh ar dhaoine eile í a mhodhnú. Sa chás seo, is féidir leat an bhileog oibre a sheoladh mar chomhad PDF ó Excel.

1. Gníomhachtaigh do bhileog oibre a theastaíonn uait a sheoladh.

2. Coinnigh síos an ALT + F11 eochracha, agus osclaíonn sé an Fuinneog Microsoft Visual Basic for Applications.

3. Cliceáil Ionsáigh > Modúil, agus greamaigh an cód seo a leanas sa Fuinneog an Mhodúil.

Cód VBA: seol an bhileog oibre reatha mar chomhad PDF ó Excel

Sub SendWorkSheetToPDF()
'Update 20131209
Dim Wb As Workbook
Dim FileName As String
Dim OutlookApp As Object
Dim OutlookMail As Object
On Error Resume Next
Set Wb = Application.ActiveWorkbook
FileName = Wb.FullName
xIndex = VBA.InStrRev(FileName, ".")
If xIndex > 1 Then FileName = VBA.Left(FileName, xIndex - 1)
FileName = FileName & "_" + ActiveSheet.Name & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
    .To = "skyyang@extendoffice.com"
    .CC = ""
    .BCC = ""
    .Subject = "kte features"
    .Body = "Please check and read this document."
    .Attachments.Add FileName
    .Send
End With
Kill FileName
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub

Nóta: Sa chód thuas, is féidir leat an fhaisnéis seo a leanas a athrú go do riachtanas.

  • .To = "skyyang @extendoffice.com "
  • .CC = ""
  • .BCC = ""
  • .Subject = "gnéithe kte"
  • .Body = "Seiceáil agus léigh an doiciméad seo le do thoil."

4. Ansin brúigh F5 eochair, agus popfaidh bosca pras amach, cliceáil Ceadaigh tar éis críochnú an bharra dul chun cinn, ansin cuireadh an bhileog oibre ghníomhach chuig an duine ar leith mar chomhad PDF.

doc-r-phost-bileog6

Nótaí:

1. Níl na modhanna seo ar fáil ach nuair a úsáideann tú Outlook mar do chlár ríomhphoist.

2. Tar éis duit an bhileog oibre reatha a sheoladh, féadfaidh tú dul chuig do Outlook chun a chinntiú go bhfuil an ríomhphost seolta go rathúil.


Cruthaigh Liosta Ríomhphoist Ansin Seol Ríomhphoist

An Kutools le haghaidh Excel's Cruthaigh Liosta Ríomhphoist agus Seol Emails is féidir le fóntais liosta seoltaí a chruthú go tapa i mbileog oibre, ansin an t-ábhar céanna, an t-ábhar céanna agus na ceangaltáin chéanna a sheoladh chuig seoltaí ríomhphoist iolracha.
liosta seoltaí doc 1
saighead doc síos
liosta seoltaí doc 2

Earraí gaolmhara:

Conas leabhar oibre reatha a sheoladh trí Outlook ó Excel?

Conas raon cealla a sheoladh / ríomhphost trí ionchas ó Excel?


Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Bhattacharjee · 2 years ago
    This is to inform you that i have an VBA code for send email from outlook with the help of excel vba,now i want to put "MDD Code" & " MDD Name" as well as Cells(i, 1) & Cells(i, 2) in a table like that.

    MDD Code MDD Name
    M123 Joydip

    I am sending you the VBA Code,Request you for help.
    VBA Code
    ----------------------------------------------------------------------------------------------------------------------------------------------
    Sub sendmail()

    Dim olapp As Outlook.Application

    Dim olmail As Outlook.MailItem

    For i = 2 To 35

    Application.ScreenUpdating = False

    Set olapp = New Outlook.Application

    Set olmail = olapp.CreateItem(olMailItem)

    With olmail

    olmail.To = Cells(i, 4).Value

    olmail.CC = Cells(i, 6).Value

    olmail.Subject = Cells(i, 7).Value

    olmail.HTMLBody = "Dear Partner ," & _

    "
    Please find the attchment." & _

    "

    MDD Code : " & Cells(i, 1) & _

    "
    MDD Name : " & Cells(i, 2) & _

    "






    Joydip Bhattacharjee" & _

    "
    Company" & _

    "
    MIS" & _

    "
    Country" & _

    "
    Contact No : 7602066491"







    olmail.Attachments.Add Cells(i, 8).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 9).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 10).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 11).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 12).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 13).Value

    'On Error Resume Next

    'olmail.Attachments.Add Cells(i, 14).Value

    'On Error Resume Next

    olmail.Send

    End With

    Set olmail = Nothing

    Next

    End Sub
  • To post as a guest, your comment is unpublished.
    mehmet · 3 years ago
    merhaba ben bunu belirli periyotta otomatik mail atmasını nasıl ayarlayabilirim
  • To post as a guest, your comment is unpublished.
    Oscar Eseisa · 3 years ago
    Excelent code. Thanks!
  • To post as a guest, your comment is unpublished.
    Dave · 3 years ago
    Anyway I can easily send an excel worksheet through my outlook without all this ?? I can send the worksheet context, but no the workbook as an attachment. On my work computer I can send from word and excel, but am having trouble at home.
  • To post as a guest, your comment is unpublished.
    Richard · 3 years ago
    Hi! Is it possible to use this code, but instead of sending straight away it opens up the mail?
    • To post as a guest, your comment is unpublished.
      Sunny · 3 years ago
      You can try this code:
      Sub SendWorkSheet()
      'Update 20180109
      Dim xFile As String
      Dim xFormat As Long
      Dim Wb As Workbook
      Dim Wb2 As Workbook
      Dim FilePath As String
      Dim FileName As String
      Dim OutlookApp As Object
      Dim OutlookMail As Object
      On Error Resume Next
      Application.ScreenUpdating = False
      Set Wb = Application.ActiveWorkbook
      ActiveSheet.Copy
      Set Wb2 = Application.ActiveWorkbook
      Select Case Wb.FileFormat
      Case xlOpenXMLWorkbook:
      xFile = ".xlsx"
      xFormat = xlOpenXMLWorkbook
      Case xlOpenXMLWorkbookMacroEnabled:
      If Wb2.HasVBProject Then
      xFile = ".xlsm"
      xFormat = xlOpenXMLWorkbookMacroEnabled
      Else
      xFile = ".xlsx"
      xFormat = xlOpenXMLWorkbook
      End If
      Case Excel8:
      xFile = ".xls"
      xFormat = Excel8
      Case xlExcel12:
      xFile = ".xlsb"
      xFormat = xlExcel12
      End Select
      FilePath = Environ$("temp") & "\"
      FileName = Wb.Name & Format(Now, "dd-mmm-yy h-mm-ss")
      Set OutlookApp = CreateObject("Outlook.Application")
      Set OutlookMail = OutlookApp.CreateItem(0)
      Wb2.SaveAs FilePath & FileName & xFile, FileFormat:=xFormat
      With OutlookMail
      .To = "skyyang@extendoffice.com"
      .CC = ""
      .BCC = ""
      .Subject = "kte features"
      .Body = "Please check and read this document."
      .Attachments.Add Wb2.FullName
      .Display
      ' .Send
      End With
      Wb2.Close
      Kill FilePath & FileName & xFile
      Set OutlookMail = Nothing
      Set OutlookApp = Nothing
      Application.ScreenUpdating = True
      End Sub

      Please let me know if it works for you, thank you.
  • To post as a guest, your comment is unpublished.
    Sherry · 4 years ago
    This code works good, however, does anyone know a way to automate a field as an alert for the email to go automatically based on a date column?
  • To post as a guest, your comment is unpublished.
    Adanma · 5 years ago
    Kindly help me out urgently. This the first time I am using the send current worksheet as PDF but the below code did not work at all and the dialogue to allow did not show up when I presses ctrl+G.

    I also want to know what to change to reference a cell that contained the email address instead of "to a specific email address.

    Sub SendWorkSheetToPDF()
    'Update 20131209
    Dim Wb As Workbook
    Dim FileName As String
    Dim OutlookApp As Object
    Dim OutlookMail As Object
    On Error Resume Next
    Set Wb = Application.ActiveWorkbook
    FileName = Wb.FullName
    xIndex = VBA.InStrRev(FileName, ".")
    If xIndex > 1 Then FileName = VBA.Left(FileName, xIndex - 1)
    FileName = FileName & "_" + ActiveSheet.Name & ".pdf"
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName
    Set OutlookApp = CreateObject("Outlook.Application")
    Set OutlookMail = OutlookApp.CreateItem(0)
    With OutlookMail
    .To = "skyyang@extendoffice.com"
    .CC = ""
    .BCC = ""
    .Subject = "kte features"
    .Body = "Please check and read this document."
    .Attachments.Add FileName
    .Send
    End With
    Kill FileName
    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
    End Sub
  • To post as a guest, your comment is unpublished.
    Ramakumar · 5 years ago
    Sir

    I am able to send selected worksheet as attachment by including subject & Text.
    But the file name is showing as book1-02-apr-2016....

    Instead i want to give the file name in the code itself ( same name to continue every time i send)

    Kindly helpme
  • To post as a guest, your comment is unpublished.
    Archana · 5 years ago
    Can we allow the user to add the email ID with above mentioned code... Its works really good if we mention the To email id...
  • To post as a guest, your comment is unpublished.
    CHARLES · 6 years ago
    hi,
    im french , sorry for my english.
    How is it possible to put the value's cell of my sheet in .too/ .CC ...

    i think is it like :

    Sub SendWorkSheet()
    'Update 20131209
    Dim xFile As String
    Dim xFormat As Long
    Dim Wb As Workbook
    Dim Wb2 As Workbook
    Dim FilePath As String
    Dim FileName As String
    Dim OutlookApp As Object
    Dim OutlookMail As Object
    On Error Resume Next
    Application.ScreenUpdating = False
    Set Wb = Application.ActiveWorkbook
    ActiveSheet.Copy
    Set Wb2 = Application.ActiveWorkbook
    Select Case Wb.FileFormat
    Case xlOpenXMLWorkbook:
    xFile = ".xlsx"
    xFormat = xlOpenXMLWorkbook
    Case xlOpenXMLWorkbookMacroEnabled:
    If Wb2.HasVBProject Then
    xFile = ".xlsm"
    xFormat = xlOpenXMLWorkbookMacroEnabled
    Else
    xFile = ".xlsx"
    xFormat = xlOpenXMLWorkbook
    End If
    Case Excel8:
    xFile = ".xls"
    xFormat = Excel8
    Case xlExcel12:
    xFile = ".xlsb"
    xFormat = xlExcel12
    End Select
    FilePath = Environ$("temp") & "\"
    FileName = Wb.Name & Format(Now, "dd-mmm-yy h-mm-ss")
    Set OutlookApp = CreateObject("Outlook.Application")
    Set OutlookMail = OutlookApp.CreateItem(0)
    Wb2.SaveAs FilePath & FileName & xFile, FileFormat:=xFormat
    With OutlookMail
    .To = "skyyang@extendoffice.com" & RANGE("AVIVA!b12")
    .CC = "" & RANGE("AVIVA!c12")
    .BCC = ""
    .Subject = "NOUVEAU DOSSIER"
    .body = "Please check and read this document."
    .Attachments.Add Wb2.FullName
    .DISPLAY
    .Send
    End With
    Wb2.Close
    Kill FilePath & FileName & xFile
    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
    Application.ScreenUpdating = True
    End Sub

    thank's for you help
  • To post as a guest, your comment is unpublished.
    Karan · 6 years ago
    Hi The macro works for me perfectly fine. I have never used macros before so, can anyone please put me in the right direction - I am trying to send this to more than one person but not sure how put extra email addresses in the "to" section of the macro.

    Thanks in advance
  • To post as a guest, your comment is unpublished.
    Jash · 6 years ago
    Hey I am using a automation process in my company I need to upgrade all my pc with the excel and outlook 2010 i have a code in windows xp with which i am mailing a sheet using outlook express the code is working fine in xp but now i need to upgrade it with windows 7 . I tried alot but i cant send the sheet so plz help
  • To post as a guest, your comment is unpublished.
    Jerry · 6 years ago
    Send single worksheet as an attachment from Excel with VBA code: Excellent VBA Code. Works GREAT !!! Thank you!!! :-)
    Instead of entering the To: & CC: e-mails manually, I want to pull the e-mail addresses from a separate worksheet called "E-Mail List". The (a1) has the "To" e-mail address and (b1) has the "CC" e-mail address. I know this is relatively simple to solve but I cannot figure out what I am doing wrong.

    Thank you everyone in advance.

    Wb2.SaveAs FilePath & FileName & xFile, FileFormat:=xFormat
    With OutlookMail
    .To = "skyyang@extendoffice.com"
    .CC = ""
    .BCC = ""
    .Subject = "kte features"
    .Body = "Please check and read this document."
    .Attachments.Add Wb2.FullName
    .Send
    End With
    Wb2.Close
    Kill FilePath & FileName & xFile
    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
    Application.ScreenUpdating = True
    End Sub
  • To post as a guest, your comment is unpublished.
    Shel · 7 years ago
    I'm trying to use this code to send a single spreadsheet using a personally created template *.ost file that resides on the c:\ drive. Can't seem to figure out how to adapt the code above for that. Any pointers?
  • To post as a guest, your comment is unpublished.
    Janet · 7 years ago
    Hi, I am using Office 2010 and Windows 7.
    Thanks!
    • To post as a guest, your comment is unpublished.
      admin_jay · 7 years ago
      [quote name="Janet"]Hi, I am using Office 2010 and Windows 7.
      Thanks![/quote]
      Hello, this VBA is OK with Office 2010 in Window 7. Please make sure you have open your Outlook before running this VBA.
  • To post as a guest, your comment is unpublished.
    Janet · 7 years ago
    I am using the code above to send a single sheet as an excel attachment, the problem I am having, is that it is sending the whole workbook, not just a single worksheet.
    I only changed the "To", "Subject" and "Body" for the email.
    I am not sure what went wrong.
    Help Please! :sad:
    • To post as a guest, your comment is unpublished.
      admin_jay · 7 years ago
      [quote name="Janet"]I am using the code above to send a single sheet as an excel attachment, the problem I am having, is that it is sending the whole workbook, not just a single worksheet.
      I only changed the "To", "Subject" and "Body" for the email.
      I am not sure what went wrong.
      Help Please! :sad:[/quote]
      Hello, please tell me the version information of your Office and computer system.
  • To post as a guest, your comment is unpublished.
    Janet · 7 years ago
    I am using the second example above to send a single sheet out of the workbook, but it is sending the whole workbook. I copied the above example and the only part I changed was the email address.
    I am not sure what is wrong.
  • To post as a guest, your comment is unpublished.
    SomeOneVBA · 7 years ago
    Hi,

    I'm using this code but I have any issue when sending.
    It's not a big problem but I don't like it :-)

    I first auto save the file to a certain location via VBA before sending the file by mail. The file already has name ending on .xlsx

    When emailing the file, the attachement reads .xlsx.xlsx so it adds .xslx to the file.

    Does anybody know if I can it to ignore saving before sending it as attachment ? I already have it saved before sending...

    Thanks,
  • To post as a guest, your comment is unpublished.
    Jim Bristow · 7 years ago
    I am attempting to Send Multiple Name Ranges within given workbooks as PDF's via Outlook. Automating open and closing numerous workbooks. I am not certain how to modify stated code below which works great sending a worksheet with All new versions on Laptop. I sent multiple reports each night off my desk top Windows 7 Excel and Outlook 10 Adobe Acrobat Pro 10 and attempting to reconfigure to do same on laptop with upgraded versions of windows 8.1 Office 15 and adobe acrobat Xl.

    Your Recommended Codes for Sending Worksheets

    Sub SendWorkSheetToPDF()
    'Update 20131209
    Dim Wb As Workbook
    Dim FileName As String
    Dim OutlookApp As Object
    Dim OutlookMail As Object
    On Error Resume Next
    Set Wb = Application.ActiveWorkbook
    FileName = Wb.FullName
    xIndex = VBA.InStrRev(FileName, ".")
    If xIndex > 1 Then FileName = VBA.Left(FileName, xIndex - 1)
    FileName = FileName & "_" + ActiveSheet.Name & ".pdf"
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName
    Set OutlookApp = CreateObject("Outlook.Application")
    Set OutlookMail = OutlookApp.CreateItem(0)
    With OutlookMail
    .To = "jbristow1@gmail.com"
    .CC = ""
    .BCC = ""
    .Subject = "Outlook Code"
    .Body = "Please check and read this document."
    .Attachments.Add FileName
    .Send
    End With
    Kill FileName
    Set OutlookMail = Nothing
    Set OutlookApp = Nothing
    End Sub
    • To post as a guest, your comment is unpublished.
      SomeOneVBA · 7 years ago
      Jim,

      You need to add ; behind the email address and add an other, see example below :

      .To = "jbristow1@gmail.com; someone@gmail.com; onemoreperson@gmail.com"
  • To post as a guest, your comment is unpublished.
    ogunyemi · 7 years ago
    I have attached send to mail recipient, but is not activated when i click to send the excel. What am i doning wrong?
  • To post as a guest, your comment is unpublished.
    Niti Trivedi · 7 years ago
    Hi I want to send only selected cells through a command button in excel to receipts through outlook.
  • To post as a guest, your comment is unpublished.
    Chanda · 7 years ago
    When I use the VBA code to send as a pdf, the email sends fine, however there is no attachment. What am I doing wrong?

    Thanks,
    Chanda
    • To post as a guest, your comment is unpublished.
      HosWorker · 6 years ago
      Did you get an anser for this? Im also having the same difficulty.
  • To post as a guest, your comment is unpublished.
    Russ Streff · 7 years ago
    How do you add multiple recipients in the second example using VBA code?
    • To post as a guest, your comment is unpublished.
      Mela · 1 months ago
      this works, but how can we add in automatically in the cc the sender?