Solved

Sent Email TO:

Posted on 2011-03-14
6
182 Views
Last Modified: 2012-06-21
Good morning,


I currently have an access based PO system that we send purchase confirmations to vendors. I build purchase conformation. Inside the form I have a field for email address. With that field, I place the email address of who the vendor is. When I send my Vendor conformation, I use a report to pull up all the purchases I have made using that PO. Within the Report Confirmation I have a macro set up that will automatically convert the PO into a PDF and attach it to an email. What I would like to do- if it’s not too difficult, is take the email address that I already have put in my form (and shows up on the Purchase Conformation Report) show up on my email. So when I click the button “Send to Vendor”

My outlook opens, with a PDF attachment of the Purchase Conformation, with the email of the Vendor already put in.


Is this doable?
Thanks for all the help!
0
Comment
Question by:hcp27
6 Comments
 
LVL 11

Expert Comment

by:donaldmaloney
Comment Utility
0
 
LVL 15

Expert Comment

by:Simon Ball
Comment Utility
sendobject is the command i think.

docmd.SendObject acSendReport, "report name",

type that in the code behind the button and then press F1 to get the help.

you can pick up values from the fields in your report, and elect wether to enter default text and autosend, or edit the message manually once created.
0
 
LVL 15

Expert Comment

by:Simon Ball
Comment Utility
http://www.fmsinc.com/microsoftaccess/Email/SendObject.html

OutputFormat = acFormatPDF

expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)

0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 3

Expert Comment

by:brd24gor
Comment Utility
You would use SendObject as outlined above. The parameter you'll be interested in is EditMessage. Set to -1 for the message to be editable so you can look at it before sending. If you don't set it, the default is -1.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
So is your ultimate question here:

How do I put the Email address on the Report?

If so then you will have to store the email address first.
Then when the report is created, insert this value into a control.

But your design is difficult to envision without a sample DB...
Can you post a sample of this DB.
Then outline the exact steps a user will follow and detail exactly what they should be doing/seeing in each step.

Then I am sure any expert here can assist

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Delete any objects that do not relate directly to the issue.
5. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
6. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
7. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
8. Compile the code. (From the database window, click: Debug-->Compile)
9. Run the compact/Repair utility.
10. Remove any Passwords and/or security.
11. Post explicit steps to replicate the issue.
12. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue.

JeffCoachman

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
I see that you selected my post as the solution.

For the record, can you state what the ultimate fix was, and how my post helped?

my post was just a suggestion that seemed just as valid as the other Experts posts...

;-)

Jeff
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now