Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Solved
How do I send Access reports through Group Mailbox in Outlook?
Posted on 2015-01-20
Hello. My department is looking to send reports out through Outlook from Access. Several people will send it from their individual mail box, and I know that is possible, but some managers want their team to have access to all documents returned so they want the reports to be sent through a group mailbox that they have set up. Is this possible? Please advise. Thanks.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
- +1
6 Comments
Active today
Does the "group mailbox" have an actual account that's used to send? If so, then you could log your machine onto that account, and use that when sending the report.
Scott,
It's a shared email address that they all have permissions to read/send from in Outlook. Each report has a list of loans and that gets sent to the corresponding loan officer. The loan officers have to pull up the loan documentation and email it back for review. The managers are (understandably) nervous that if they send the request from an individual account that the loan officer will just hit reply and not send the information to the group address so that everyone can review it. Because of the volume, it's easy to miss some when one individual receives them in their individual mailbox with all of their other mail (or is out of the office, etc.)
It's a shared email address that they all have permissions to read/send from in Outlook. Each report has a list of loans and that gets sent to the corresponding loan officer. The loan officers have to pull up the loan documentation and email it back for review. The managers are (understandably) nervous that if they send the request from an individual account that the loan officer will just hit reply and not send the information to the group address so that everyone can review it. Because of the volume, it's easy to miss some when one individual receives them in their individual mailbox with all of their other mail (or is out of the office, etc.)
The sender (loan officer) HAS to use the FROM tab to select the shared-mailbox and send emails to anyone.
For this the loan officer needs to be provided Send-As priviliges (GOD, I hope you are using Exchange Servers in your messaging environment).
If you are using Exchange, then the above should suffice.
-Tushar Shah
For this the loan officer needs to be provided Send-As priviliges (GOD, I hope you are using Exchange Servers in your messaging environment).
If you are using Exchange, then the above should suffice.
-Tushar Shah
aanderzak,
Correct me if I'm wrong, but it sounds like the problem is NOT so much that they don't have access to a shared account as they just DONT remember to use it to send the email.
If your staff is pulling the access reports manually and then attaching them to an email to send, Then human nature is that they will always forget to Send From" another account.
You could automate that process by placing some VBA code in Access that will send the report to a predefined group from a shared mailbox account.
Create a button on your menu form that does the following:
The recipients list is coded into the method, but you could use a string variable to store different lists if you have different recipient groups for each report.
Thanks.
Correct me if I'm wrong, but it sounds like the problem is NOT so much that they don't have access to a shared account as they just DONT remember to use it to send the email.
If your staff is pulling the access reports manually and then attaching them to an email to send, Then human nature is that they will always forget to Send From" another account.
You could automate that process by placing some VBA code in Access that will send the report to a predefined group from a shared mailbox account.
Create a button on your menu form that does the following:
export the report to a folder. Use DoCmd.OutputTo acOutputReport
send mail with attachment using the file in the folder. Use DoCmd.SendObject acSendReport
The recipients list is coded into the method, but you could use a string variable to store different lists if you have different recipient groups for each report.
Thanks.
The recipients list is stored and the users want to have it automatically create and attach the reports from access to excel, populating the "to" field with the appropriate address, and then send it so that there is no user interaction except clicking the button to start the process. I have suggested that they may have to manually select the group mailbox on each email before sending, but I was instructed to look into whether there is an option to automate it. I am able to do this from their individual account but have not figured out how to select the group mailbox and fully automate it . It doesn't seem like it's possible, possibly due to Outlook security settings?
-Amy
-Amy
Apologies, if you use the DoCmd.SendObject method, it goes through outlook, and you can not select the FROM address. Syntax is: SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)
It is more complex to write, but you could use the method CDO.Message instead.
Something similar to:
It is more complex to write, but you could use the method CDO.Message instead.
Something similar to:
Dim cdomsg As CDO.Message
Set cdomsg = CreateObject("CDO.message")
With cdomsg
With .Configuration.Fields
schema = "http://schemas.microsoft.com/cdo/configuration/"
.Item(schema & "sendusing") = cdoSendUsingPort
.Item(schema & "smtpserver") = XXXXXXXXXXXX
.Item(schema & "smptserverport") = XXXXXXXXXXXX
.Item(schema & "smtpauthenticate") = cdoBasic
.Item(schema & "sendusername") = XXXXXXXXXXXX
.Item(schema & "sendpassword") = XXXXXXXXXXXX
.Item(schema & "smtpusessl") = False
.Update
End With
.To = XXXXXXXXXXXX
.From = XXXXXXXXXXXX
.CC = XXXXXXXXXXXX
.BCC = XXXXXXXXXXXX
.Subject = XXXXXXXXXXXX
.TextBody = XXXXXXXXXXXX
SendEmail = True
End With
Featured Post
Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
- Microsoft Office
- Office 365
- Outlook
- Office / Productivity
- Microsoft Word
- Microsoft PowerPoint, Microsoft Excel, *Office 2013, *office 2010, *Office 2016
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel.
This lets you automatically sync them with…
Suggested Courses
Course of the Month7 days, 3 hours left to enroll
704 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.