Print Page | Close Window

Email Body - Excel Spreadsheet

Printed From:
Category: PDF reDirect
Forum Name: Programming
Forum Discription: VBA and Batch Tools to control PDF reDirect Pro
Printed Date: 16 Jun 24 at 1:59AM

Topic: Email Body - Excel Spreadsheet
Posted By: JackR
Subject: Email Body - Excel Spreadsheet
Date Posted: 06 Jan 08 at 2:02PM
I downloaded your VB Examples and am trying to understand how they work. I have not done any VB programming but plan to spend more time working with it in the near future.

I would like to set up a cell on the spreadsheet where I could input the email text so that when I click on the button "Click here to make PDF" the pdf will be created and an email would be generated with the text that was input on the spreadsheet.. I am able to get the email portion working but can not get the email text to work. I named a spreadsheet cell Email_body and declared it(Email_body) as a variable (Public emailbody As String).

Is there any way of pulling in the text for the email from the spreadsheet. Also, other than the help sections, is there any book that you would recommend for learning Visual Basic

Thank you


Posted By: JackR
Date Posted: 06 Jan 08 at 10:33PM

I figured it out. I was missing the reference to the control in the work sheet.

Posted By: Michel_K17
Date Posted: 07 Jan 08 at 11:13PM
Glad to hear it. Well done! Smile

Learning VB is not too bad once you get over the concept of ParentObject.Object.Method and ParentObject.Object.Property.

For example:
  • Car.Engine.Start would be a method (an action on something) and
  • Car.ExternalColor = Blue (you can usually read and assign a value to a property).

    In terms of a book, I used the book that came with Visual Basic 4 way-back-when (it's dated 1995), and VB6 did not come with a book as by then, Microsoft started to rely on the online documentation. Same goes for VBA (that's the version of VB that comes with Microsoft Office programs). Their online documentation is not bad: it just takes a lot of time to go through the entire user documentation.

    Good luck! It sounds like you are well on your way though.

Michel Korwin-Szymanowski
EXP Systems LLC

Print Page | Close Window