Sanjay has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Link with Outlook
Hi,
I have to create a excel based tool which can be link with the outlook, so once we have any update or want to send the updates to the recipients ,so whatever change we made in this tool then the update will got to all reciepient.
please update can we do it.
Thanks
Sanjay
RE: link with Outlook
Hi Sanjay,
Thank you for the forum question.
Yes you can, but you need to know how to trigger the event (execute the code when file is updated).
You will need to know Outlook VBA and how to reference the Outlook library from Excel.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: link with Outlook
Thanks Jens for your input
RE: link with Outlook
Hi Sanjay,
See basic Outlook VBA below.
It can only work if you activate the Outlook object library.
Sub sendemail()
Dim OutApp As Outlook.Application
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = “xxx@xxx.co.uk”
.CC = ""
.BCC =””
.Subject = “New Update”
.Body = "Hello Guys” & VbNewLine” & “Please find attached update” & VbNewLine & “Kind Regards” & VbNewLine & “Jack Jones”
.Attachments.Add “C:\Users\Name\Desktop\Excel Files\MyAttachment.docx”
.Send
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
