Sending multiple charts in in an email body with a macro

Faroth26

New Member
Joined
Feb 1, 2018
Messages
1
Hi there!

First post in here, so please bare with me :biggrin::biggrin:

I am looking for some help to make a macro that sends multiple charts within the email body.

Alternativly, convert a specific range into a PDF (that contains my charts), and send that as an attachment in an email.

Any help would be much appreciated.

Kind regards
Rasmus
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,972
Welcome to the Board


Code:
Sub Faroth()
Dim olapp As Object, olit As Object, p$
p = "c:\pub\charts.pdf"
Set olapp = CreateObject("Outlook.Application")
Set olit = olapp.CreateItem(0)
[a35:h60].ExportAsFixedFormat xlTypePDF, p
With olit
    .To = "wozzy@tennis.dn"
    .Attachments.Add p
    .Display
End With
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,099,788
Messages
5,470,786
Members
406,721
Latest member
Laiceyshae

This Week's Hot Topics

Top