If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Email from Access
Hello All,
I'm using the following code to send email with Outlook, it works fine. wBody is, the user enters any text to put on the body of the email. wOutput is, the attached word document or a PDF file the user selects. Is there a way to put the document or the PDF onto the Body of the email so the recipient doesn't have to open the attachment and see it right away as they open the email. With objEmail .To = wEmailAdrs .Subject = wSubject .body = wBody .Attachments.Add wOutPut .Send End With Thank you very much in advance abe |
#2
|
|||
|
|||
Email from Access
No. An email is either text or html. PDF is a completely different format
which can comtain both text and images. You could put a link to the PDF file in the body if your email is html format. Use the standard html syntax for embedding a hyperlink. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Abe Katz" wrote: Hello All, I'm using the following code to send email with Outlook, it works fine. wBody is, the user enters any text to put on the body of the email. wOutput is, the attached word document or a PDF file the user selects. Is there a way to put the document or the PDF onto the Body of the email so the recipient doesn't have to open the attachment and see it right away as they open the email. With objEmail .To = wEmailAdrs .Subject = wSubject .body = wBody .Attachments.Add wOutPut .Send End With Thank you very much in advance abe . |
#3
|
|||
|
|||
Email from Access
You could create the body of the email in a creative way such as:
- using code (run through a recordset and produce results similar to the report) - exporting a report to txt or html format and then reading it back into the body of the email Note: Access HTML generation is sometimes pretty weird (so test a good deal before you try and use this in a repeatable process). If you want to see an example of the second approach: http://www.rptsoftware.com/products/email/ We use a DLL (instead of relying on Outlook, so it works for everyone) but the same concept applies. HTH, Mark Andrews RPT Software http://www.rptsoftware.com "Abe Katz" wrote in message ... Hello All, I'm using the following code to send email with Outlook, it works fine. wBody is, the user enters any text to put on the body of the email. wOutput is, the attached word document or a PDF file the user selects. Is there a way to put the document or the PDF onto the Body of the email so the recipient doesn't have to open the attachment and see it right away as they open the email. With objEmail .To = wEmailAdrs .Subject = wSubject .body = wBody .Attachments.Add wOutPut .Send End With Thank you very much in advance abe |
Thread Tools | |
Display Modes | |
|
|