Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Email - Subject line change values
Wow - I asked for suggestions - and I get that. Yeh, that was it my computer blew up - REALLY????? [jester2] I'm thinking this forum is for geniune questions. For folks that need assistance - not for, well posts like that. But since I need the help, I'll appease your obnoxious post and say I...- JD5307
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Email - Subject line change values
This isn't working now... Any suggestions?- JD5307
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Email - Subject line change values
Thank you! Andrzejek (Programmer) It Worked!- JD5307
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Email - Subject line change values
Sub EmailNotificationSent() Dim OutLookApp As Object Dim OutLookMailItem As Object Dim iCounter As Integer Dim MailDest As String Set OutLookApp = CreateObject("OutLook.application") Set OutLookMailItem = OutLookApp.createitem(0) With OutLookMailItem MailDest = "" For iCounter = 1 To...- JD5307
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Email - Subject line change values
I have a spreadsheet with Project IDs in Column A. Im looking to send individual emails once a value has been added to the corresponding cell in Column C. I want the cell specific information from Column A to be in the Subject line. I can do everything but change the Subject Line value to...- JD5307
- Thread
- Replies: 13
- Forum: VBA Visual Basic for Applications (Microsoft)
