Morepork07
New Member
- Joined
- May 26, 2019
- Messages
- 1
Hi as a newbie here, i'm fathoming my way around VBA and can generate an email from an Excel worksheet. The trouble is I need to be able to add certain cells that are in that worksheet into the body of the email itself. Any ideas anyone?
For example, if cell A1 says " Let's go to he movies". How do I include that cell reference into th VBA script to allow hat phrase t be generated. If I have multiple cells with text inside, can you advise on how this can be done as well please. Example, A1 says" Lets go to the movies to see" and the contents o cell B1 that are generated from a data validation say " The Green Mile", so that the sentence in the email says "Lets go to the movies to see The Green Mile An y ideas please.
For example, if cell A1 says " Let's go to he movies". How do I include that cell reference into th VBA script to allow hat phrase t be generated. If I have multiple cells with text inside, can you advise on how this can be done as well please. Example, A1 says" Lets go to the movies to see" and the contents o cell B1 that are generated from a data validation say " The Green Mile", so that the sentence in the email says "Lets go to the movies to see The Green Mile An y ideas please.