• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Auto Email Through Excel|VBA & Macros|Excel Forum|My Online Training Hub

You are here: Home / Auto Email Through Excel|VBA & Macros|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumVBA & MacrosAuto Email Through Excel
sp_PrintTopic sp_TopicIcon
Auto Email Through Excel
Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
1
June 26, 2020 - 8:23 pm
sp_Permalink sp_Print

Hello All,

Request your support on below 2 topics.

1. The requirement is to send auto email through excel. The email addresses, cc address, subject and body of the email is keyed in particular cells in the same excel. Individual emails has to be sent with the subject and body of email from the same row. I have programmed it already in which all the above particulars for individual email (please refer to the attached excel) But i could not make it further to add further. Once all the entries are made in the excel, all the individual emails should be sent by EmailSend command.

2. In cell "H3" the subject is auto generated by the name of the person and the entry time. But the value of time is generated in decimal value and not in time format. Request your suggestion for correction.

 

Thanks in advance for the solution.

Mohith

sp_AnswersTopicSeeAnswer See Answer
Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
June 26, 2020 - 9:32 pm
sp_Permalink sp_Print

Hi Mohith,

The attached file will do what you want.  

I've modified the message body as it didn't need the time in the string, I'm picking that up from the cell on the worksheet.

This blog post may help you out with any further emailing you need to do

https://www.myonlinetraininghu.....th-outlook

regards

Phil

Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
3
June 29, 2020 - 1:39 pm
sp_Permalink sp_Print

Hello Philip,

Greetings! Hope you're doing fine!!

Its working. Thank you for your support.

Can the email be sent automatically? I mean when there is an input for a particular row and the subject is generated (column H from the excel), can the email be triggered automatically without giving the manual command "send email"?

It would really helpful if we can have this solution.

Thanks & Best Regards,

Mohith

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
4
June 30, 2020 - 11:23 am
sp_Permalink sp_Print

Hi Mohith,

Yes this can be done, though I'd caution against triggering an email when the Body of the message in Col H is entered.  What if you make a mistake in typing and need to edit?  Too late, the email has already been sent.

You can use another column as a trigger?  When you enter some text into Col I the email for that row is sent?

Regards

Phil

Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
5
June 30, 2020 - 1:28 pm
sp_Permalink sp_Print sp_EditHistory

Hello Philip,

Am trying to avoid manual intervention in sending the email. I agree to the risk of mistakes but will ensure the mistakes are avoided.

Please suggest how this can be done when the body of the message is entered in col H.

Thanks in advance for your support.

Best Regards,

Mohith

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
6
July 2, 2020 - 10:59 pm
sp_Permalink sp_Print

Hi Mohith,

Please see attached file.  When the message body is changed on a particular row, and email is sent to the email address on that row.

Of course, when you delete that message body an email is sent.  Hence why I cautioned against doing it this way.

Regards

Phil

Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
7
July 3, 2020 - 2:00 pm
sp_Permalink sp_Print

Hello Philip,

Thanks for the updated file.

When the name or the time is modified in the file, the email is not getting triggered (the subject is col H will be auto updated as it is linked). What was observed is when the cell in col H is edited manually, the email is getting triggered.

In your previous post you suggested for using another column to trigger email. Can this column be the input column, col B? This input is linked with be linked to all other columns gets filled so email can be triggered once this column has an input.

Thanks in advance for your solution.

Best Regards,

Mohith

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
8
July 5, 2020 - 7:19 pm
sp_Permalink sp_Print sp_EditHistory

Hi Mohith,

You asked for the email to be sent when the body of the message is entered in Col H and that is what the code does.  But it''s easy to modify - see attached.

When you now make a change to Col B and email will be sent.

Regards

Phil

Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
9
July 6, 2020 - 2:49 pm
sp_Permalink sp_Print

Hello Philip,

I am getting run time error in the new file.

Could you please check?

Thanks & Best Regards,

MohithError-2.JPGImage Enlarger

Error-1.JPGImage Enlarger

sp_PlupAttachments Attachments
  • sp_PlupImage Error-2.JPG (65 KB)
  • sp_PlupImage Error-1.JPG (30 KB)
Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
10
July 6, 2020 - 3:22 pm
sp_Permalink sp_Print sp_EditHistory

Hi Mohith,

Try this.  You can add whatever fields you want to the Body cell, but you can leave out the time as the code adds this.

Regards

Phil

sp_AnswersTopicAnswer
Answers Post
Avatar
Mohith M Y
Member
Members
Level 0
Forum Posts: 17
Member Since:
January 10, 2020
sp_UserOfflineSmall Offline
11
July 9, 2020 - 1:54 pm
sp_Permalink sp_Print

Hello Philip,

The program is working. Thanks for your support.

 

Best Regards,

Mohith

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1518
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
12
July 9, 2020 - 2:35 pm
sp_Permalink sp_Print

You're welcome.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Jeanine Hagge
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27293

 

Member Stats:
Guest Posters: 49
Members: 31916
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.