Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sending mails from excel...but mail body disappearing
Hi All,
My macro will send mail from Excel with an excel attachment. The body of the message in from the attached spread sheet. The reciepient will get my mail perfectly.My problem is that when the reciepient tries to forward or reply my mail all the mail body disappears..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sending mails from excel...but mail body disappearing
On Jan 10, 6:56*am, Jithu wrote:
Hi All, My macro will send mail from Excel with an excel attachment. The body of the message in from the attached spread sheet. The reciepient will get my mail perfectly.My problem is that when the reciepient tries to forward or reply my mail all the mail body disappears..... Y not just send it as an attatchment instead of as the body of your email? ActiveWorkbook.Save ActiveWorkbook.SendMail _ Recipients:="This woudl be your mail list if you wanted to send to more then one person", _ Subject:="This can be what ever you want. You coudl even add a message box to change it everytime if you wanted " & Format(Date, "mmm/dd/yy") Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
Sending automatic e-mails by date from Exel | Excel Worksheet Functions | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
When sending file via email, cannot paste Excel data into body of letter. | Excel Discussion (Misc queries) |