Recent content by lesg01stn

I am new to this forum and look forward to participating. I am an intermediate access / VBA user from Johannesburg, South Africa and am not a "natural" logic / programmer but I slog until I get there! :D

Hi All, After serching the web and modifying code I am now able to create an email and attach various objects converted to PDF / Excel for users that use either outlook or lotus notes BUT... in outlook vba you can either send directly or display the outlook mail object by using the function...

Thanks Gizmo... finally managed to solve the Lotus Notes code

Thanks Uncle Gizmo.... However I have 2 issues as a result of my being on a work laptop... Our firewall does not allow us to access your url and more often than not we are blocked from using "internet mail" servers. At this stage it may be that I will have to build in code for the Lotus Notes...

The docmd.SendObject functionality is great in that it crosses all email clients but you can only "attach" one document to the email. I have 2 reports and a table that get converted to PDF & excel formats and the resultant three documents need to be attached to an email to be sent out. As...