Dear All,
this is my code to send email using outlook. I have a form that displays the addresses for a category and the button captures all of the email and opens up outlook to send email.
I want to the code to work for google mail.
Can anyone advise how I should edit my code to work with...
On Error GoTo Foutje
DoCmd.OpenReport "Sum Reasons", acPreview, , strFilter
DoCmd.SendObject acReport, stDocName
Exit Sub
Foutje:
If Err.Number = 2501 Then
MsgBox "Cancelled"
Else
MsgBox Err.Description
End If
End Sub
http://www.helpmij.nl/forum/showthread.php/530463-Sendobject-Action-Canceled
was browsing for solution and then i found this~
works like a charm! :o:o:o
i have posted a dummy database in the link which you can download.
Basically i have 2 tables, institution and people.
I have a query called institution query that displays the data from both tables.
i need them in 1 line using a query.. so that i can do a word merge...