1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Sub Google_maps()
Dim messagerie As Object
Dim Email As Object
Dim Message As String
Dim Lien As String
Dim NomComplet As String
Dim Mobile As String
Dim AdresseDepart As String
Dim adressearrivee As String
Set messagerie = CreateObject("Outlook.Application")
Set Email = messagerie.CreateItem(0)
AdresseDepart = "Rue des Petits Champs 13,+1400+Yverdon-les-Bains"
adressearrivee = "Route de Pomy 10,+1462+Yvonand"
NomComplet = USF_Intervention.ComboBox_Interv_Nom & " " & USF_Intervention.ComboBox_Interv_Prenom
Mobile = "USF_Intervention.TextBox_Interv_Mobile"
Lien = "<A href=""https://www.google.fr/maps/dir/{depart}/{arrivee}"">Cliquez ici pour la navigation.</A>"
Lien = ReplaceStrings(Lien, Array("{depart}", AdresseDepart, "{arrivee}", adressearrivee))
Message = "Bonjour<br><br>En pièce jointe...<br><br>{lien}<br><br><b><font color=""blue"">{nom}</font></b><br><br><font color=""green"">{gsm}</font>"
Message = ReplaceStrings(Message, Array("{lien}", Lien, "{nom}", NomComplet, "{gsm}", Mobile))
With Email
.To = "toto@gmail.com"
.CC = ""
.Subject = "Test google maps"
.htmlbody = Message
.Display
End With
Set Email = Nothing
Set messagerie = Nothing
End Sub
Public Function ReplaceStrings(Source As String, Parameters) As String
Dim I As Long
ReplaceStrings = Source
For I = LBound(Parameters) To UBound(Parameters) Step 2
ReplaceStrings = Replace(ReplaceStrings, Parameters(I), Parameters(I + 1), 1, -1, vbTextCompare)
Next I
End Function |
Partager