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
|
Private Sub Test_Click()
'Ouverture BDD via clic de bouton - phase test - mais normalement c'est sur Sub Document_Open()-
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"D:\Travail\ER_2014_2015\Base_eleves\BaseElevesRuru.accdb", _
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=D:\Travail\ER_2014_2015\Base_eleves\BaseElevesRuru.accdb;Mode=Read;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Lockin" _
, SQLStatement:="SELECT * FROM `Req_GevaSco`", SQLStatement1:="", SubType _
:=wdMergeSubTypeAccess
'Declaration des variables
Dim ChoixID, ChoixNom, ChoixPrenom As Object
Dim ReqtPublipostage As Object
Dim NbEnr, EnregistrementIndex, EnregistrementValeur As Integer
Set ReqtPublipostage = ActiveDocument.MailMerge.DataSource
NbEnr = ReqtPublipostage.RecordCount
'Remplissage Zone de liste déroulante
With ChoixEleve
For i = 1 To NbEnr
.AddItem i & " - " & ReqtPublipostage.DataFields("Prénom").Value & " " & ReqtPublipostage.DataFields("Nom").Value
ReqtPublipostage.ActiveRecord = wdNextRecord
Next i
End With
End Sub |
Partager