Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi I tried with your suggestion but it resulted in a loss of the message instead. Here's my part of my code after your suggestion (probably I have missed some "simple/obvious" part that I fully don't understand yet.. FrmMeddelande.Show '(Meddelande=Message) Message = FrmMeddelande.TextBox1.Value Dim stHTML As String stHTML = "<html<body<font FACE=" & Chr(34) & "ARIAL" & Chr(34) & "" stHTML = Message stHTML = Replace(stHTML, Chr(10), "<br") The procedure ends with the following code where stHTML is combined with another object (never mind the swedish words...) With olMail .To = SändLista .Subject = "Matchkallelse" .HTMLBody = stHTML & vbCrLf & vbCrLf & vbCrLf & SheetToHTML(ActiveSheet) 'ThisWorkbook.Sheets("2002")) .Attachments.Add "C:\Bilaga.xls", olByValue, _ 1, "Bilaga" .Display End With Set olMail = Nothing Set olApp = Nothing Sheets("Tempmail").Delete Kill "c:\bilaga.xls" End If *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating numbered coupons using word and excel mail merge | Excel Worksheet Functions | |||
Creating a mail link | Links and Linking in Excel | |||
creating labels with excel and mail merge | Excel Discussion (Misc queries) | |||
How can I stop Excel from creating an e-mail link for addresses? | Excel Discussion (Misc queries) | |||
Creating "Plain Text" mail message in Outlook from Excel VBA | Excel Programming |