| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variable in subject when send mail
Hi
I have this With Destwb .SaveAs TempFilePath & TempFileName & FileExtStr, _ FileFormat:=FileFormatNum 'On Error Resume Next .SendMail ", _ "hej" On Error GoTo 0 .Close SaveChanges:=False End With But if i use this: ..SendMail ", _ "hej" & variable I get an error ? Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using variable in subject when send mail
Dear Alvin
Use .SendMail Subject:= .........like below Dim strSubject As String strSubject = "Test Email" ActiveWorkbook.SendMail ", _ Subject:=strSubject If this post helps click Yes --------------- Jacob Skaria "alvin Kuiper" wrote: Hi I have this With Destwb .SaveAs TempFilePath & TempFileName & FileExtStr, _ FileFormat:=FileFormatNum 'On Error Resume Next .SendMail ", _ "hej" On Error GoTo 0 .Close SaveChanges:=False End With But if i use this: .SendMail ", _ "hej" & variable I get an error ? Alvin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using variable in subject when send mail
Yes yes yes
Thanks alvin "Jacob Skaria" skrev: Dear Alvin Use .SendMail Subject:= .........like below Dim strSubject As String strSubject = "Test Email" ActiveWorkbook.SendMail ", _ Subject:=strSubject If this post helps click Yes --------------- Jacob Skaria "alvin Kuiper" wrote: Hi I have this With Destwb .SaveAs TempFilePath & TempFileName & FileExtStr, _ FileFormat:=FileFormatNum 'On Error Resume Next .SendMail ", _ "hej" On Error GoTo 0 .Close SaveChanges:=False End With But if i use this: .SendMail ", _ "hej" & variable I get an error ? Alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
| Problem with .send from microsoft example for vba send mail from excel code | Excel Programming | |||
| e mail same body different subject | Excel Discussion (Misc queries) | |||
| How I auto send e-mail from excel with predefined subject and tex | Excel Programming | |||
| Subject line in E-mail | Excel Programming | |||
Hybrid Mode
