Hi everyone,
I wrote a macro that sends automated emails with specific information to each email contact (each row is a different contact)
What I can't seem to figure out is how to add the signature to the email without using the . Display tag(which can cause the procedure to be a lot more lengthy - as there can be about 20 emails sent in each batch)
Help would be much appreciated!
Before going into the With OutMail part of the code, the one that contains .To, .CC, .Send etc, there should be another .Display outside of that With part.
Even thought it displays the e-mail, it's only for a very short period of time and just to add the siggy. I remember I had problems adding the sig in the normal With OutMail part and the following Outlook signature part of the code solved that issue.
Here's the code I use (credits to Ron de Bruin I think):
Please Login or Register to view this content.
To show your appreciation
Click ★ Add reputation!
Hi Mrrrr,
Thank you very much for your reply.
Yeah, I actually wanted to know if there is an option to send the email without Mail. Display property and still show the signature.
Maybe there is an option to add a signature manually using image and text from a file , and keeping the same fast send format?
I remember trying to find a solution back then and settling with that code above.
I guess it all depends on the type of signature: simple image and text, just one or the other.
Mine has table with invisible borders, images, colored text, e-mail, website, so it's stored in a rtf file and getting all that somehow was kind of a pita.
But there could be a way of getting the signature from the rtf file stored in C:\Users\USERNAME\AppData\Roaming\Microsoft\Signatures or the htm+files stored in the same location.
Alright, so I found a solution:
works smoothly and shows the signature, without the preview.Please Login or Register to view this content.
All it requires is the path to the image (which is the signature).
Thanks for the help
Posted the HTML tags like that because I could not upload it as it is due to excelforum restrictions on HTML for some reason, but its the same code without the spaces between the tags,
either way its just adding an image tag
But the funny thing is although I am seeing that the image in outlook outgoing email is showing, in gmail and outlook mobile it does not show(shows broken image)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks