Send email attachment using form data using automation

[Cymru]

I am currently using SendObj method to send an Outlook email and selected report as an attachment using the current form's data. This is triggered by a button click.
This is working well apart from having to use 'ClickYes' to outwit the Outlook 2012 security system.
However I now need to selectively send an extra pdf file with some of the emails based on a Yes/No field on the form. This is a fixed file on my local C drive.
I think I have to use automation to do that but I can't find a method of specifying the report I currently use in the SendObj method in the .Add.Attachment line.
Do I need to run the report and then save it so that I can specify the path and name in the .Add.attachment line followed by code which will delete the file? or is there a means of combining the code I currently use in SendObj to create the pdf object with automation option?
I have working code for both attachments at present but they send separate emails and I would prefer to combine them if possible.
As this is my first post I suspect I may not have documented this correctly but I will learn. Cymru

 

[pbaldy]

To the best of my knowledge, you do have to save the report then attach it when using automation. That's what I do anyway.

 

[Cymru]

Thanks Paul - I was afraid I would get that answer but hoping for a neater solution. But thanks for the confirmation. Cymru

 

[pbaldy]

No problem.