I have a the following macro that looks through a range of cells and generates emails based on the date. The macro generates the email but does not insert my signature line. Any help that yall can provide is greatly appreciated
Please Login or Register to view this content.
You don't appear to add the signature you get here to the email.
I would have expected to see something like this in the code.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I did not notice that I had not added that and I added that portion however the signature still does not load
Is Signature definitely being populated?
It won't be if the file colelabhart.htm isn't found.
If it is being populated are you sure it's not being added?
It could be added but not displayed because a problem with the HTML.
The name that is shows in the signatures folder has a space which I added the signature now loads. However the signature has an image in it that does not load and displays the image cannot be loaded image any ideas on this problem.
If you want to display an image in the body of an email you need to attach the image and add appropriate HTML code for it.
Since you are adding the signature to the body I think you'll need to do that.
PS This code looks familiar, is it from the Ron DeBruin site?
Yes it is. Could you point me in the right direction for attaching the image part of the signature?
Do you have the filename of the image?
If you do the first thing you need to do is attach it to the email.
Then you'll need to alter the HTML of the signature to include this, for the image.Please Login or Register to view this content.
That's how you embed an image in the body of an email so since the signature is part of the body I think it should work.HTML Code:
I think we have a misunderstanding the image is part of the signature its a company logo that is apart of every employee's email signature rather than a image that I want to attach. I have attached a picture that may explain the problem more accurately.signature.png
I['m not sure I have misunderstood, you want to display an image in the signature of the email, the signature of the email is part of the body of the email, to display an image in the body of an email you need to attach the image to the email and add the HTML code I suggested.
Then the misunderstanding is on my part. I have input the code as you suggested however I believe I did not properly insert your HTML coding as I am unfamiliar with that and I am hesitant to edit anything in the image because this macro is operating as part of a larger project used by multiple people and I would like to avoid having to edit the images code on every computer. If there is not an easy work around for this I think I will just remove the signature generating portion and have the people manually add their signature to avoid this problem.
You wouldn't need to change the actual file that contains the HTML code for the signature.
All you would need to do is replace the code for the image in the string Signature with the code I suggested.
Ok I am glad I don't need to edit the image file. I have resolved this issue and the image now loads however a new issue has popped up image loads below the notification which is not the end of the world but it still has a place where it tried to load the image and did not like in the bottom picture I posted. I have posted the code as I have edited it perhaps I have miss placed something? Thank you again for all of your help.Please Login or Register to view this content.
Not quite sure I follow where you want the signature/image but you could try switching things around.
If that doesn't work then you might need to play about with the HTML in the code.Please Login or Register to view this content.
I think the problem is that the signature has the image embedded in it so it fails to load the embedded image but can load one that is attach via your method. For the most part I believe the problem is solved and I just need to play around with it some. Thank you again for your help.
Try attaching the image and saving the email before adding the body.
I tried the method you described and unfortunately it did not solve the problem.However I was looking back through Ron's websire in his first example he uses the following code to load a signature with an image I copied his example and it does not even load my signature.Please Login or Register to view this content.This method seems to be what I am looking for perhaps editing this would be easier?Please Login or Register to view this content.
I have solved my own problem regarding the method I mentioned. I my attempt to use Ron's code I removed one of the displays which allows the signature to load so my signature now loads and I have successfully modified my macro to load the signature. Thank you again for the assist.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks