Ennistymon
asked on
MS Access Macros (Send Email)
I want to send multiple reports from my database on one email by using a macro. I know I can attach one report to an email and send it by using a macro, but if I have five reports I don't want to send five different emails. Is this possible? If so, how?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to both of you, Patrick and Jeff.
@boag2000
You could put the code in a function and call it from a macro...but does that get around the 'No VBA' prohibition?
@Ennistymon
<This application will reside on a web server>
That does not necessarily mean no VBA.
I've help at least 2 posters lately who have automated Access from C# ASP.NET applications.
Or are you doing something benighted like SharePoint or web-published Access 2010 applications?
You could put the code in a function and call it from a macro...but does that get around the 'No VBA' prohibition?
@Ennistymon
<This application will reside on a web server>
That does not necessarily mean no VBA.
I've help at least 2 posters lately who have automated Access from C# ASP.NET applications.
Or are you doing something benighted like SharePoint or web-published Access 2010 applications?
Glad to help :)
Nick, not being sure of the scope of the "No VBA" restriction (I know nothing about web servers), I simply suggested creating the function then calling it form a macro...
who knew?
who knew?
If it worked, it's all good.
Having gone much more than the extra mile here
https://www.experts-exchange.com/questions/27217263/How-to-re-write-Office-Automation-Code.html?cid=1573&anchorAnswerId=36561425#a36561425
I am aware that, within limits, you can do much of the automation we are used to in VBA, from C# and VB.NET
<I know nothing about web servers>
Not that I know that much about them either!
Having gone much more than the extra mile here
https://www.experts-exchange.com/questions/27217263/How-to-re-write-Office-Automation-Code.html?cid=1573&anchorAnswerId=36561425#a36561425
I am aware that, within limits, you can do much of the automation we are used to in VBA, from C# and VB.NET
<I know nothing about web servers>
Not that I know that much about them either!
ASKER
This db will be uploaded to a Share Point service.
You may then still be in the weeds.
There is VBA code that your macro is calling.
That may not work
http://www.thorprojects.com/blog/archive/2010/01/10/sharepoint-2010-and-access-services-place.aspx
I haven't played extensively with the Access 2010 Macros, because, with a half million lines of VBA that I am not abandoning, they are a dead-end to me.
If you wind up posting another question, state explicitly that you are using Access 2010 and uploading to SharePoint, and therefore your solution must be strictly 2010 Macro based.
It may very well be doable, because the new macros have come a long way.
There is VBA code that your macro is calling.
That may not work
http://www.thorprojects.com/blog/archive/2010/01/10/sharepoint-2010-and-access-services-place.aspx
I haven't played extensively with the Access 2010 Macros, because, with a half million lines of VBA that I am not abandoning, they are a dead-end to me.
If you wind up posting another question, state explicitly that you are using Access 2010 and uploading to SharePoint, and therefore your solution must be strictly 2010 Macro based.
It may very well be doable, because the new macros have come a long way.
ASKER
I am using Access 2010 and uploading to SharePoint.
<I am using Access 2010 and uploading to SharePoint.>
You have accepted an answer.
Did you completely test it?
Does it work?
You have accepted an answer.
Did you completely test it?
Does it work?
ASKER
I'm working on it now.
ASKER