Solved

Sent Email TO:

Posted on 2011-03-14
6
187 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
[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
6 Comments
 
LVL 11

Expert Comment

by:donaldmaloney
ID: 35129590
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35129622
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
ID: 35129627
http://www.fmsinc.com/microsoftaccess/Email/SendObject.html

OutputFormat = acFormatPDF

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

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 3

Expert Comment

by:brd24gor
ID: 35129827
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
ID: 35130732
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
ID: 36436381
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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

623 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