Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email - Outmail - From
Hi
I am using the fantastic code as supplied by Ron De Bruin an extract of what I am using is With OutMail .From = strfrm .To = strto .CC = strcc .BCC = strbcc .Subject = "subject" .Body = strbody .Attachments.Add "attached file" '.Send 'or use .Display As my colleagues and I are able to send emails from ourselves, or any department mailbox that we are permissioned to, I had thought/hoped that my addition of .From would work wonders. This is not working. Is there a way to add the senders/from email address? Thanks in advance Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email - Outmail - From
..From is not a valid argument... Outlook will attach the account email
address as from automatically. It will not show up on an email until it is actually sent, so if you use the .display or .save arguments you will not see a from on the email yet. If I am not mistake, this is a security feature, it would be a bad thing if someone could automate email to be sent on your behalf but make it look like it is coming from somone else. That is my knowledge, I have been working with Outlook and Excel for some time and the one thing I still cannot get to work properly is to get excel to open outlook if it is not currently opened. I hope that helps. Dean "Richard" wrote: Hi I am using the fantastic code as supplied by Ron De Bruin an extract of what I am using is With OutMail .From = strfrm .To = strto .CC = strcc .BCC = strbcc .Subject = "subject" .Body = strbody .Attachments.Add "attached file" '.Send 'or use .Display As my colleagues and I are able to send emails from ourselves, or any department mailbox that we are permissioned to, I had thought/hoped that my addition of .From would work wonders. This is not working. Is there a way to add the senders/from email address? Thanks in advance Richard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email - Outmail - From
Read the tip page
http://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard" wrote in message ... Hi I am using the fantastic code as supplied by Ron De Bruin an extract of what I am using is With OutMail .From = strfrm .To = strto .CC = strcc .BCC = strbcc .Subject = "subject" .Body = strbody .Attachments.Add "attached file" '.Send 'or use .Display As my colleagues and I are able to send emails from ourselves, or any department mailbox that we are permissioned to, I had thought/hoped that my addition of .From would work wonders. This is not working. Is there a way to add the senders/from email address? Thanks in advance Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |