Name attachment during report export to email (1 Viewer)

tmyers

Active member
Local time
Today, 07:14
Joined
Sep 8, 2020
Messages
679
I just discovered this was a thing a little bit ago, and am curious if you can apply code to when you export a report to email as an attachment you can rename the attachment.

It seems currently it just exports it and names it the name of the report (makes sense). Would be a nice thing to rename it based off two field within the report (Quote number and quote name)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:14
Joined
Oct 29, 2018
Messages
14,098
Are you using VBA or macro? Can you show us the code?
 

tmyers

Active member
Local time
Today, 07:14
Joined
Sep 8, 2020
Messages
679
I currently don't have anything. I just discovered this was even a feature of a report roughly 15 minutes ago lol. I just happened to right click and notice the email as attachment option.

I would assume easiest would be to use VBA to do it.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:14
Joined
Oct 29, 2018
Messages
14,098
I currently don't have anything. I just discovered this was even a feature of a report roughly 15 minutes ago lol. I just happened to right click and notice the email as attachment option.

I would assume easiest would be to use VBA to do it.
I usually use VBA, yes. Will you be using an Outlook client to send out the email?
 

Users who are viewing this thread

Top Bottom