PDA

View Full Version : Image display while generating email in outlook using excel



Richard Smit
09-01-2008, 06:09 AM
Hi All,

Good day to you!

I've been using ur site as a reference, I've been able to learn a lot from your website. Can you help me out here, I'm kinda stuck. I'm able to attach a file to an e-mail that I generate from excel based on the values in the cells. However I would the image to display on the mail like the below example.

Hi there,

< Some Text>

IMAGE


<Some Text>

Regards,
xyz.

Looking forward to your help with this,.

Thanks in advance and have a great day.!

Regards,
Richard Smith

lifeson
09-01-2008, 07:20 AM
Try this
With MItem
.To = "eMail address"
.Subject = "Message title"
.Attachments.Add (file Path & "\" & file name)
.Body = "message"
.display
'NOTE: To actually send the emails, use .Send instead of .Display
'.send
End With 'mail item

Richard Smit
09-01-2008, 07:42 PM
Thanks for posting. However, I've already tried that and it only helps me to attach the file. I would like the image to display within the text in the body of the e-mail.

Regards,
Richard