Export to PDF and Email Report

[AceBK]

Hello,
I have a report called [Banners Order Confirmation]. What I would like to do is with a click of a button, export the report as a pdf to a specified drive and folder and save it with a name by combining 2 fields from the report. Also, I would like to email this report to an email address which is also specified by a field on the report. I have tried different vb codes and have been very unsuccessful. Could you please help me or at least point me in some dirrection?

Thanks,
AceBK

 

[vbaInet]

Firstly, I would advise that you get rid of the spaces in Banners Order Confirmation and call it BannersOrderConfirmation instead. That way you won't even need the square brackets.

With regards your OP, what version of Access are you using?

 

[AceBK]

Thanks for the response, I have Access 2010. I found a way to make it work using a Macro, but through my digging, I have noticed that Macros is not the way to go.
AceBk

 

[vbaInet]

There's nothing wrong with macros. If you prefer it and it works for you use it. But my preference is code. Is it not working as expected?

 

[AceBK]

It is working with the macros. Would it be true to say that I could convert my macros to VB code would be the same as just using the VB code, or is converting not a wise idea.

 

[vbaInet]

Pretty much the same! Converting it to code is your own prerogative. I understand that Microsoft are trying to move away from code and get developers to start doing everything in macros.

 

[AceBK]

Thank you for your time.

 

[vbaInet]

You're welcome!