Inserting Images into Lotus Notes Email

H

headtoadie

Board Regular

Joined

Aug 1, 2003

Messages

219

• Feb 13, 2004

• #2

Are you looking for VBA code to do this from Excel or Lotus Script to do this from Notes?

HT

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 13, 2004

• #3

Excel Macro Code.

I have my main Macro code for emailing the files I need, but the Headache I have been handed is that I have to dump either jpgs or BMPs ( depends on what Notes prefers) into the last section of each email.

Ta

headtoadie said:

Are you looking for VBA code to do this from Excel or Lotus Script to do this from Notes?

HT

Click to expand...

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 13, 2004

• #4

Any takers ??
I'd love to be able to automate this by Monday...

Pulleeeesse...



Ta

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 16, 2004

• #5

Anyone know a link or anything that can help me insert the images please?

I would so appreciate some help on this.


Ta

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 17, 2004

• #6

I am really not sure what to put in so that the email will pick up two files in order.

I know that the Lotus Notes will import the files names, but I don't know how to code it.

Ta

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 24, 2004

• #7

Well, I sure would appreciate some code suggestions on this item.

If I could Pull the Images into the Email, it would so expedite things.


Ta

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Feb 24, 2004

• #8

See the following example for starters:

http://www.mrexcel.com/board2/viewtopic.php?t=60558&start=13

 

Upvote 0

santeria

Well-known Member

Joined

Oct 7, 2003

Messages

1,844

• Feb 24, 2004

• #9

Very Cool link.

But how do I add in an image ( not simply attach in Notes), but do a full import so that it will display... in this case, two images, for a report.


Ta Muchly.

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Feb 24, 2004

• #10

Hello again,

santeria said:

But how do I add in an image ( not simply attach in Notes), but do a full import so that it will display... in this case, two images, for a report.

Click to expand...

Well, sorry, you've lost me, this does add an image to the body, yes-no? There's no file attachment to be found in that thread. Just paste your pic right in there eh!

The key are these three lines (well, and a few more, like initializing the correct object, etc...):

Range([b5], [b65536].End(3)).CopyPicture
Call UIdoc.GotoField("Body")
'Blah blah blah
Call UIdoc.Paste

Otherwise explain a little more what you mean, e.g., where is this picture, etc...

 

Upvote 0