I want to be able to send an infopath form that I have created using data from either Excel or Access.
I can manually populate the form and send it from InfoPath but how do I do create the form as an object in VBA and then edit the contents and email it?
I want to be able to send the same form to multiple users with different data.
MsAccess has the Email feature that does this from the toolbar but it creates its own Infopath form.