| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me with this email from excel
Hi!!
I send a email from excel its working allright but i can't make it look good I use chr(9) to tab like this msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date, "dd/mm/yyyy") & Chr(13) but it don't get so good with the second CHR(9) how can i make this nice. reagrds Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help me with this email from excel
Hi Alvin,
Is this any better: msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn _ & Chr(9) & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & _ Format(Date, "dd/mm/yyyy") & Chr(9) --- Regards, Norman "Alvin Hansen" wrote in message ... Hi!! I send a email from excel its working allright but i can't make it look good I use chr(9) to tab like this msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date, "dd/mm/yyyy") & Chr(13) but it don't get so good with the second CHR(9) how can i make this nice. reagrds Alvin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help me with this email from excel
No sorry
I can see theat chr(9) works but if i have some text "aaaa" and then chr(9) and then tekst again and chr(13) new line and some text "aaaaaaaaaa" and then chr(9) then my tab its not the same place like the first tab. in the first i have 4"a" and in the second i have 10"a" so my second tab moves more to the right I don't understand why this tab dosn't work in a email regards Alvin "Norman Jones" skrev: Hi Alvin, Is this any better: msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn _ & Chr(9) & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & _ Format(Date, "dd/mm/yyyy") & Chr(9) --- Regards, Norman "Alvin Hansen" wrote in message ... Hi!! I send a email from excel its working allright but i can't make it look good I use chr(9) to tab like this msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date, "dd/mm/yyyy") & Chr(13) but it don't get so good with the second CHR(9) how can i make this nice. reagrds Alvin |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help me with this email from excel
A workaround
You can use Html to send a part of the worksheet http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Alvin Hansen" wrote in message ... No sorry I can see theat chr(9) works but if i have some text "aaaa" and then chr(9) and then tekst again and chr(13) new line and some text "aaaaaaaaaa" and then chr(9) then my tab its not the same place like the first tab. in the first i have 4"a" and in the second i have 10"a" so my second tab moves more to the right I don't understand why this tab dosn't work in a email regards Alvin "Norman Jones" skrev: Hi Alvin, Is this any better: msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn _ & Chr(9) & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & _ Format(Date, "dd/mm/yyyy") & Chr(9) --- Regards, Norman "Alvin Hansen" wrote in message ... Hi!! I send a email from excel its working allright but i can't make it look good I use chr(9) to tab like this msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date, "dd/mm/yyyy") & Chr(13) but it don't get so good with the second CHR(9) how can i make this nice. reagrds Alvin |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help me with this email from excel
Tanks i get it to work now
But again a problem, I have a tectbox in this user form with multiline, how can i do it so it takes a new line when there are a new line I use this noamlly in HTML Replace(Server.HTMLEncode("Comment"),vbCrLf,"<br" ) But in this email it dosn't work i get a error do know how to do this Alvin "Ron de Bruin" skrev: A workaround You can use Html to send a part of the worksheet http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Alvin Hansen" wrote in message ... No sorry I can see theat chr(9) works but if i have some text "aaaa" and then chr(9) and then tekst again and chr(13) new line and some text "aaaaaaaaaa" and then chr(9) then my tab its not the same place like the first tab. in the first i have 4"a" and in the second i have 10"a" so my second tab moves more to the right I don't understand why this tab dosn't work in a email regards Alvin "Norman Jones" skrev: Hi Alvin, Is this any better: msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn _ & Chr(9) & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & _ Format(Date, "dd/mm/yyyy") & Chr(9) --- Regards, Norman "Alvin Hansen" wrote in message ... Hi!! I send a email from excel its working allright but i can't make it look good I use chr(9) to tab like this msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13) msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date, "dd/mm/yyyy") & Chr(13) but it don't get so good with the second CHR(9) how can i make this nice. reagrds Alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
| Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
| Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
| working on excel document in email saved changes in email not in . | Excel Discussion (Misc queries) | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
![Alvin Hansen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
