VBA: Merge two macros

[boulala]

hey there,

i want to combine the following two macros. the goal must be to create one macro that generates one email containing the screenshot and the second range. My system is windows xp and office 2003.

Please Login or Register  to view this content.

both work perfect alone. but i need them in one macro. maybe someone can help me

thanks boulala

[patel45]

Please Login or Register  to view this content.

[boulala]

hi,

thanks for the fast answer. But your code still calls both macros, that means that 2 emails are generated and I only want to have ONE email there must be a way to merge them, so that only one mail is created.

info: every single macro is made that way, that it creates one seperate mail.

[boulala]

hi,

sorry i've edited it

[patel45]

you have 2 different subj, 2 different Empfänger and you want sen only one email ?

[boulala]

Sorry I think I wasn't clear enough. I've tried this two different macros, just to test them if they work seperately.
Now I want to merge them, to generate just one Email with only one Subject and one adress (Empfänger).

That means I need one macro that, pastes a Screenshot and a table in one email body. And it MUST be a Screenshot and a copy of the table and NOT a Screenshot of of the whole excel sheet.

I hope this was a bit clearer. If not feel free to ask me.

[patel45]

I don't use Outlook, then I can not test, but try

Please Login or Register  to view this content.

[aikz007]

Try this

Please Login or Register  to view this content.

[boulala]

Hi,

patel45 i used your Code. It works partially, that means the Screenshot isn't pasted into the mail.
But have a look I attached the file (someone who has outlook).

@aikz007: your code calls 2 macros that generate 2 emails. but I only need one email including the screenshot and the table.

example.xls