How to code to send Email with attachment in Zoho Sheet using VBA code: To send Email with attachment
Dear Team,
I am writing a VBA code through which my code will send the active sheet of Zoho sheet as an attachment
on the specified email address of our workplace's email id domain address.
Is there any different code other than you specified if my email server is other than zoho like in this case it is our domain name at zoho workplace.
My code is as below
Public Sub Worksheet_Change()
Application.EnableEvents = false
On Error Goto ENEV
ThisWorkbook.HasRoutingSlip = True
With ThisWorkbook.RoutingSlip
'.from = "suvarna.mohite@glogic.co.in"
.Recipients = "suvarna.mohite@glogic.co.in" 'Can send mail to multiple recepients
.Subject = "Trial mail from zoho VBA"
.Message = "Hello! Have a Good Day!! Mail content. " & "Sending trial link here:" & ActiveSheet.Name
.AttachWorkbook = True
'.AttachmentFormat = "pdf"
.SheetName = ActiveSheet.Name ' this will send the active sheet.
End With
ThisWorkbook.Route
ENEV:
Application.EnableEvents = true
End Sub
With this code we get the email but no attachment with it.
Kindly give me your feedback.
Thanks for your Support
Suvarna (msuvarna2112@gmail.com)
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Suvarna
Rohith V K
noahsandoval24
Suvarna
Gautham Balaji G
Sticky Posts
Open PGP integration with Zoho Mail is now here!
Hello Community, We're in much delight to announce that the long awaited integration of Open PGP with Zoho Mail is now released to users in US, EU, AU and IN DCs. With this integration. you can now send out encrypted and digitally signed emails whichFree Webinar Alert! Transform your digital work experience with Zoho Workplace and Zoho Sign
Hello Community!!! We're excited to announce the free webinar on Transforming your digital work experience with Zoho Workplace apps and Zoho Sign integration! Join us for the webinar! Click here, to register!Announcing ZUG Australia & New Zealand Meet-ups - Meet, Talk, and Learn from Workplace Experts!
Hello Everyone! Our Workplace experts are visiting the top cities in Australia & New Zealand to meet you all in person and help you boost the productivity of your organisation. Come and meet us at one of the cities listed below - whichever is nearer toAnnouncing ZUG New Zealand Meet-ups in Auckland, Wellington & Brisbane - Meet, Talk, and Learn from Workplace Experts!
Hello Everyone! Our Workplace experts are visiting the top cities in New Zealand to meet you all in person and help you boost the productivity of your organisation. Come and meet us at Auckland, Wellington or Christchurch - whichever is nearer to you.Announcing ZUG Australia Meet-ups in Melbourne, Sydney & Brisbane - Meet, Talk, and Learn from Workplace Experts!
Hello Everyone! Our Workplace experts are visiting the top cities in Australia to meet you all in person and help you boost the productivity of your organisation. Come and meet us at Melbourne, Sydney or Brisbane - whichever is nearer to you. Find our
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー