Hi Code Champs,
Below is the code to send emails through a selection in Excel as per http://www.rondebruin.nl/win/s1/outlook/bmail3.htm.
The likes of To, CC, subject line are hardcoded in the code.
However, I do not want this hardcoded. Instead, if I update column A1,B1 and C1 with the details of TO, CC and Subject, this would solve my purpose.
Can you please assist.
Please Login or Register to view this content.
Can you just do this?Please Login or Register to view this content.
Thanks...
Help Required on 1) I want to preview the email before clicking send. I tried changing the code to .Display at the end, but somehow that is not working.
2) My email signature is not getting populated which is default in Outlook. Is this possible through some code?
Appreciate your help.
Hi, aaron.mendes,
like you noted the proper command is
as opposed toPlease Login or Register to view this content.
Insert Outlook Signature in mail.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Guru,
Thanks for the link. But since i'm new to VBA, I somehow cannot merge the codes for the outlook signature and also my above code together.
Also, the .Display code is not working.
Can you please see this. It would help resolve my query. I have attached my excel for your convenience.
Hi, aaron.mendes,
if you copy code from any page please make sure that you copy everything. There is no way in your code that you create an instance of Outlook so the the mail cannot be displayed in Outlook.
And you should make up your decision about which way for the code to use.
Ciao,
Holger
This seems to work for me.
Please Login or Register to view this content.
Hi Holger,
In my attached file, there are two macros A) Sending email based on selection in Excel and B) Sending an email that includes Outlook Signature.
I want to use the first macro which Sends the email based on my selection.
1)However, It goes without out a signature which is why i need to incorporate the Signature codes in my First Macro Code.
2) I'm not able to preview the email before sending it. I tried changing the macro but the display function is somehow not working.
Old Macro
NEW macroPlease Login or Register to view this content.
And my knowledge on VBA is very limited. Therefore your help is greatly appreciated.Please Login or Register to view this content.
I'm attaching my excel file for your convenience.
Hi, aaron.mendes,
I copied all the code (the procedure as well as the Functions) into a standard module. You would need to make sure that the name of your signature from Outlook is replaced in the constant otherwise no signature would be displayed (we could work around that and build one in HTML if wanted).
I selected the range of A8:A13 in Sheet1 and started the macro - my version of Excel2007 created and displayed the mail in Outlook.
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks