Home Mathematics Chapter 22: Printing and Sending Email from Excel
Chapter
Licensed
Unlicensed Requires Authentication

Chapter 22: Printing and Sending Email from Excel

  • Julitta Korol
View more publications by Mercury Learning and Information
Search
Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP
This chapter is in the book Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP
© 2014 Walter de Gruyter GmbH, Berlin/Boston

© 2014 Walter de Gruyter GmbH, Berlin/Boston

Chapters in this book

  1. Frontmatter i
  2. Contents vii
  3. Acknowledgments xxv
  4. Introduction xxvii
  5. Part I—Introduction to Excel 2013 VBA Programming
  6. Chapter 1: Automating Worksheet Tasks with Macros 1
  7. Chapter 2: Exploring the Visual Basic Editor (VBE) 47
  8. Chapter 3: Excel VBA Fundamentals 65
  9. Chapter 4: Using Variables, Data Types, and Constants 119
  10. Chapter 5: VBA Procedures: Subroutines and Functions 153
  11. Part II—Controlling Program Execution
  12. Chapter 6: Decision Making with VBA 195
  13. Chapter 7: Repeating Actions in VBA 221
  14. Part III—Keeping Track of Multiple Values
  15. Chapter 8: Working with Arrays 239
  16. Chapter 9: Working with Collections and Class Modules 277
  17. Part IV—Error Handling and Debugging
  18. Chapter 10: VBE Tools for Testing and Debugging 311
  19. Chapter 11: Conditional Compilation and Error Trapping 337
  20. Part V—Manipulating Files and Folders with VBA
  21. Chapter 12: File and Folder Manipulation with VBA 351
  22. Chapter 13: File and Folder Manipulation with Windows Script Host (WSH) 371
  23. Chapter 14: Using Low-Level File Access 397
  24. Part VI—Controlling Other Applications with VBA
  25. Chapter 15: Using Excel VBA to Interact with Other Applications 421
  26. Chapter 16: Using Excel with Microsoft Access 453
  27. Part VII—Enhancing the User Experience
  28. Chapter 17: Event-Driven Programming 507
  29. Chapter 18: Using Dialog Boxes 555
  30. Chapter 19: Creating Custom Forms 569
  31. Chapter 20: Formatting Worksheets with VBA 617
  32. Chapter 21: Context Menu Programming and Ribbon Customizations 671
  33. Part VIII—Programming Excel Special Features
  34. Chapter 22: Printing and Sending Email from Excel 737
  35. Chapter 23: Programming PivotTables and PivotCharts 771
  36. Chapter 24: Using and Programming Excel Tables 827
  37. Chapter 25: Programming Special Features 849
  38. Chapter 26: Programming the Visual Basic Editor (VBE) 865
  39. Part IX—Excel and Web Technologies
  40. Chapter 27: HTML Programming and Web Queries 911
  41. Chapter 28: Excel and Active Server Pages 939
  42. Chapter 29: Using XML in Excel 2013 977
  43. Part X Going Beyond the Limits of VBA
  44. Chapter 30: Calling Windows API Functions from VBA 1053
  45. Index 1081
https://doi.org/10.1515/9781938549441-024

Chapters in this book

  1. Frontmatter i
  2. Contents vii
  3. Acknowledgments xxv
  4. Introduction xxvii
  5. Part I—Introduction to Excel 2013 VBA Programming
  6. Chapter 1: Automating Worksheet Tasks with Macros 1
  7. Chapter 2: Exploring the Visual Basic Editor (VBE) 47
  8. Chapter 3: Excel VBA Fundamentals 65
  9. Chapter 4: Using Variables, Data Types, and Constants 119
  10. Chapter 5: VBA Procedures: Subroutines and Functions 153
  11. Part II—Controlling Program Execution
  12. Chapter 6: Decision Making with VBA 195
  13. Chapter 7: Repeating Actions in VBA 221
  14. Part III—Keeping Track of Multiple Values
  15. Chapter 8: Working with Arrays 239
  16. Chapter 9: Working with Collections and Class Modules 277
  17. Part IV—Error Handling and Debugging
  18. Chapter 10: VBE Tools for Testing and Debugging 311
  19. Chapter 11: Conditional Compilation and Error Trapping 337
  20. Part V—Manipulating Files and Folders with VBA
  21. Chapter 12: File and Folder Manipulation with VBA 351
  22. Chapter 13: File and Folder Manipulation with Windows Script Host (WSH) 371
  23. Chapter 14: Using Low-Level File Access 397
  24. Part VI—Controlling Other Applications with VBA
  25. Chapter 15: Using Excel VBA to Interact with Other Applications 421
  26. Chapter 16: Using Excel with Microsoft Access 453
  27. Part VII—Enhancing the User Experience
  28. Chapter 17: Event-Driven Programming 507
  29. Chapter 18: Using Dialog Boxes 555
  30. Chapter 19: Creating Custom Forms 569
  31. Chapter 20: Formatting Worksheets with VBA 617
  32. Chapter 21: Context Menu Programming and Ribbon Customizations 671
  33. Part VIII—Programming Excel Special Features
  34. Chapter 22: Printing and Sending Email from Excel 737
  35. Chapter 23: Programming PivotTables and PivotCharts 771
  36. Chapter 24: Using and Programming Excel Tables 827
  37. Chapter 25: Programming Special Features 849
  38. Chapter 26: Programming the Visual Basic Editor (VBE) 865
  39. Part IX—Excel and Web Technologies
  40. Chapter 27: HTML Programming and Web Queries 911
  41. Chapter 28: Excel and Active Server Pages 939
  42. Chapter 29: Using XML in Excel 2013 977
  43. Part X Going Beyond the Limits of VBA
  44. Chapter 30: Calling Windows API Functions from VBA 1053
  45. Index 1081
Sign up now to receive a 20% welcome discount
Institutional Access
How does access work?
Have an idea on how to improve our website?
Please write us.
© 2025 De Gruyter Brill
Downloaded on 24.9.2025 from https://www.degruyterbrill.com/document/doi/10.1515/9781938549441-024/html
Scroll to top button