hi
i have an existing macro which sends email to different email address. template can be found in emailbody1. my problem is i need to put a logo on top of the email message and another picture before the signature.
can anybody help me modify the macro so that when the mails are generated, the logo and pictures can be seen in the email message itself? not as an attachment.
appreciate your help in advance
In an example I made, I use the following routines:
Please Login or Register to view this content.
rBody and rFooter are Named Ranges which contain cells used to build the body and footer respectively.
The first cell in rBody contains something like:
The second cell containsPHP Code:<img src='file://C:\Users\...\Documents\...\Images\...image name ....jpg'>
PHP Code:<html><body style='font-family:Calibri;font-size:15px;'>
Similarly for the first cell in rFooter:
PHP Code:<img src='file://C:\Users\...\Documents\...\Logos\Logo Combo Red 200 x 100.jpg'>
In other words, you will need to add HTML code to the body to add links to the images that you want to include.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
And bear in mind that whoever is reading the email will likely need access to where the pictures are stored
hmmmmm... can somebody explain to me where i will put the above codes in my existing macro? i am just a newbie in macros and i have no idea where to insert above codes...
also, is there a way that email recipient can see the pictures even if they do not have access to my pc? note that my emails are being sent in spain while i am in the philippines...
Yes, host them online
any other option for me? please
There isn't. If you want people to see images in your email, you either need to attach them to the email and embed them (which is painful) or put them online and link to them
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks