Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel output to outlook?
I'm trying to email just the values of a range from my
worksheet. I don't want the cells to show up, only the text. using the partial code i have below, what would be the proper way to handle this? Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem Dim ToContact As Outlook.Recipient Set OLF = GetObject("", _ "Outlook.Application").GetNamespace ("MAPI").GetDefaultFolder(olFolderInbox) Set olMailItem = OLF.Items.Add ' creates a new e-mail message With olMailItem ..Subject = "Banklist Status sheet for " & Date ' message subject Set ToContact = .Recipients.Add ") ' add a recipient .Body = "Thank you for submitting, here are your results." &(chr13) & right here is where i want the values to be inserted... Thanks in advance guys, Josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel output to outlook?
Josh,
You can just tag a range value on the end like so .Body = "Thank you for submitting, here are your results." & Chr(13) & Range("C11").Value -- HTH Bob Phillips "josh ashcraft" wrote in message ... I'm trying to email just the values of a range from my worksheet. I don't want the cells to show up, only the text. using the partial code i have below, what would be the proper way to handle this? Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem Dim ToContact As Outlook.Recipient Set OLF = GetObject("", _ "Outlook.Application").GetNamespace ("MAPI").GetDefaultFolder(olFolderInbox) Set olMailItem = OLF.Items.Add ' creates a new e-mail message With olMailItem .Subject = "Banklist Status sheet for " & Date ' message subject Set ToContact = .Recipients.Add ") ' add a recipient .Body = "Thank you for submitting, here are your results." &(chr13) & right here is where i want the values to be inserted... Thanks in advance guys, Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I simply output Deciles in Excel? | Excel Discussion (Misc queries) | |||
Combo box output excel 2007 | Excel Discussion (Misc queries) | |||
ADD (A3+A1) IN MS EXCEL & I WANT OUTPUT IN CELL A3 HOW ? | Excel Discussion (Misc queries) | |||
Using Excel in Formatted Output | Excel Worksheet Functions | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) |