| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Char(10) or Char(13) in body of email
I'm trying to use this snippet of code in the body of an email, but I get an
error message saying that the function is not defined. 'some stuff here... Please let me know if you have any questions!" _ & CHAR(13) & _ 'some stuff here... What am I doing wrong? Thanks, Ryan-- -- RyGuy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Char(10) or Char(13) in body of email
On Nov 13, 9:22*am, ryguy7272
wrote: I'm trying to use this snippet of code in the body of an email, but I get an error message saying that the function is not defined. 'some stuff here... Please let me know if you have any questions!" _ & CHAR(13) & _ 'some stuff here... What am I doing wrong? Thanks, Ryan-- -- RyGuy Replace CHAR(13) with Chr(13) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Char(10) or Char(13) in body of email
This works! Thanks so much. One more quick question. How do I get the
entire contents of a cell into the body of the email? I am using this: ..Body = "Dear " & cell.Offset(0, -1).Text It gives me just the text part of the email, but no numbers. I have text and numbers together in several cells, such as andy12 and fred22. I get andy and fred only! I tried this: ..Body = "Dear " & cell.Offset(0, -1).Value Results were the same. Please advise. Thanks so much!! Ryan--- -- RyGuy "UglyChicken" wrote: On Nov 13, 9:22 am, ryguy7272 wrote: I'm trying to use this snippet of code in the body of an email, but I get an error message saying that the function is not defined. 'some stuff here... Please let me know if you have any questions!" _ & CHAR(13) & _ 'some stuff here... What am I doing wrong? Thanks, Ryan-- -- RyGuy Replace CHAR(13) with Chr(13) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EMail Hyperlink TO limited to 10 char | Excel Discussion (Misc queries) | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| Getting rid of char(160) | Excel Programming | |||
| How to removed the first three char and last char in XLS | Excel Programming | |||
Hybrid Mode
