E-mail Attachment?

Aug 22, 2005

Is it possible to attach an email in a field of a form?

We have a database that keeps track of technical orders. We get e-mails on what we are supposed to implement on a particular tech. order. Is there anyway I can attach or make a copy of this email or something to have it in a field of my form?

Thanks.

View Replies


ADVERTISEMENT

Send Mail Merge With Attachment

Sep 20, 2006

I have been searching the forums about how to send an email using a mail merge Word document with attachments and have not found a way to accomplish this. There are numerous posts on haw to send email using the SendObject function with attachments but I really need to use a Word mail merge to satisfy the requirements set forth by my superiors.

The database uses a query to pull the list of recipients. The query contains the name, email address and a few other informational items that need to be put in mail merge. I also need to attach a second 5 page Word document. At this point, I don’t care if I have to deal with the Outlook security or not, I only have about 20 a day to send but if there is a way to get around it, that would be cool.

Would it be possible to create a Report that looks the same as the mail merge document and send it to each of the recipients from the query and attach the document to that email?

I am running up against a deadline that is fast approaching and any help would be greatly appreciated.:(

View 1 Replies View Related

Modules & VBA :: Mail Merge With Attachment?

Jun 19, 2014

I'm wondering if it's possible to set up an automatic Outlook mail merge with attachments from Access. We have several account managers, and each one receives a different version of the same report - filtered to his/her accounts. For now, I have set it up for the user to select the account managers and hit "Print Reports" to save each individual report into a destination folder. The user then uses an email template, attaches the report, and sends the email to an account manager. She has to send this email separately to each account manager.

View 3 Replies View Related

Mail Once Again - Opening 'new' Mail-window And Export Mail Adress

Jun 23, 2006

Hi, this is probably a very easy question for you “Access-gods” out there.

I’ve made a database (MS Access 2000) with all my clients. I collect a lot of contact info, including e-mail.

I want to make a function which opens a new mail window (Outlook 2003) and automatically puts in the e-mail from my form (In the send-to field of outlook).

Is this possible? And how?

(BTW: I’m a newbie with VBA)

View 2 Replies View Related

General :: Bulk Mail Send With Different Mail Body Contents

Apr 26, 2013

I have a ms access table with two fields...tablename is ..."Addresses"..

Field1:= Employee_mail_id
Field2:= Leave_balance

What I need to do is that,I need to send individual mail (in Bulk) two each employee intimating their leave balances.
Is it possible to do it in vb .I want it to assign the codes in a button.

Below iss the code.

Dim r As Recordset
Dim email As String
Set r = CurrentDb.OpenRecordset("select * from Addresses")
Do While Not r.EOF
email = email & r(2) & ";"
r.MoveNext
Loop
r.Close
DoCmd.SendObject acSendNoObject, Null, Null, email, Null, Null, "Test subject", "Message body of the test letter", False, Null

View 2 Replies View Related

Email Attachment

Feb 17, 2007

Hi,
I was wondering if it's at all possible to add an attachment which is a pdf file to an email? I've searched this site and can't seem to find anything on this.
Thanks
Geno

View 1 Replies View Related

See Attachment File

Dec 13, 2006

How can I select Current Record of Subform by Double Clicking to another Subform.

See The file...

Intead of Subforms if anyone do it with ListBoxes will apprecited...

View 4 Replies View Related

Attachment In Database

Oct 24, 2004

Hi all,

Is it possible to attach/store files (Word, Excel, etc) in a database table?

Appreciate your feedback.
Thanks.

View 1 Replies View Related

Attachment Through A Form

Sep 18, 2006

Hi,
i need to attach files through a form.One could be able to browse for the file and attached it with the mail.
thanxx.

View 1 Replies View Related

Email Attachment

Mar 15, 2007

Hi all,

For my db, which has send object command to send a *.snp report in email object, I want to include some more attachments. On click event should get the files from a local drive and attach to email message along with report.

Could some body help me towards this point?

View 6 Replies View Related

Attachment Data Type

Jan 16, 2008

I am using Access 2007 and I am trying to create an attachemnt type field in a table. Yet when I select the types of Data Types, attachement is not an option. Can you possibly tell me why?

Thank you

View 4 Replies View Related

Desperate - With Correct Attachment

Nov 14, 2006

Sorry...attached the wrong file. Here it is again.

View 4 Replies View Related

Send Email Attachment

Dec 8, 2006

I have the following code to send a email with outlook, what I need is to automatically collect a attachment named commissions located in C:document and settings/Documents/...
Private Sub cmdSendEmail_Click()
DoCmd.SendObject acSendNoObject, , , cboEmail.Value, , , "Commission Request", "A new commission request has been submitted."
End Sub

How can I do it??
Thanks

View 5 Replies View Related

Email Table With No Attachment?

Aug 21, 2006

Hello Everyone,


My Situation: I have a form which merges with a table of 123 Names & Addresses. The only thing these records have in common is an ID #. And the name of the company the ID Number belong to.


Now what I need to do is send in an Email the ID# and Company that the ID# belong to.


Here is an example: Toys R US #45

In the records there is "Gi Joy"
"XBOX"


But they all are connected to the #45






When I try to send from the form I get a table as an attachment with all of the records in excel format when using the following code:


DoCmd.SendObject acSendForm, "frmPeople", acFormatHTML, "sample@aol.com", , , "ID# Information"

I need to send just the ID# in a table but not as an attachment in Outlook. I have looked for examples and I seen none anywhere.

If I could just send a table with one row and nothing but the ID# Information, I would be so happy...

View 2 Replies View Related

Attachment In DoCmd Function

Sep 1, 2006

I have this code for email function from form of DB

Private Sub Email_Click()
On Error GoTo Err_mail_Click

Dim stDocName As String

stDocName = "TRANSMITTALGEN"
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, Me.ClientEmailID, Me.UMLEmailID, , Me.Subject, Me.Message

Exit_mail_Click:
Exit Sub

Err_mail_Click:
MsgBox Err.Description
Resume Exit_mail_Click
End Sub

As can be seen there is one report which gets attached to email message. But here I want to have one condition, means if
[Forms]![frmLogon]![Project]="P-159" then this attachment is ok else [Forms]![frmLogon]![Project]="P-172" then it should change stDocName to another report.

Any help plz.

View 1 Replies View Related

Email From Access With Attachment.

Aug 16, 2006

Hi all
We have been using
Docmd.Sendobject, "name", acformatrtf, to, cc etc

Is there any way to have a form within access just like a compose format wherein we have option to attach files?

View 8 Replies View Related

Forms :: Cannot Add Attachment Without Committing Row First

Jun 14, 2015

i have a form that i want to add the new document but when i want to add the new document i will get this error message: attachments cannot be added to new rows until the rows have been commited to the server, commit the row first and then try to attach the document again.

View 14 Replies View Related

Photo Name As Attachment To A Record

Apr 3, 2012

When you query Photo.name, you get a line for each photo name attached to a record

1 aunt sally a.jpg
1 aunt sally b.jpg
1 aunt sally c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob l.jpg

What I would like is to have it appear like this

1 aunt sally a.jpg; b.jpg; c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob L.jpg

View 8 Replies View Related

How To Get Filename To Show Up Next To Attachment Box

Mar 13, 2012

Is there a code to get a filename to show up next to an attachment box?

View 2 Replies View Related

Search For Attachment Before Emailing

Jul 17, 2012

I have a field "spName" and command button "cmdEmailReport", when I click "cmdEmailReport" i would like to attach 2 files to my email

First file would be the report from access, next thing i would like to search my folder "C:SP" for file thats like "spName" (field) and attach that file as well something like "c:SP" like "'*" & me.spName &"*'"

I can attach report to email just fine, but my problem is searching for a file in folder with name and attaching that file as well to same email.

View 10 Replies View Related

Multiple Attachment Printing At Once

Feb 11, 2012

The main problem is related with the attachment printing. Each data entry has attachment (word file). It's ok when I'm about to print one attachment per entry, but often I need to print most of attachments at once, doing it separately looks overwhelming. Mainly - I want to have ability to print all attachments at once or select multiple attachments.

View 1 Replies View Related

Mailmerge Email With Attachment

May 21, 2012

In my database which is used by a charity I have a button which opens a mailmerge email document in MS Word using the following Visual Basic code -

FollowHyperlink "C:Our FoldersBWMCJuly Donors Email.docx", , True, True

This mailmerge document draws its personal information from a query in my database. And sends off personal emails to a number of donors.

I want to attach a personal document called 'Allocations.docx' which is also a mailmerge document drawing its personal information from the same query. How can I automate the attachment of this document to the email so that each donor gets their own email plus their own attachment?

Can something be added to the existing line of VB which will do what I want? If so, what do I need to add?

View 8 Replies View Related

Search For Attachment In A Mailbox?

Jan 24, 2012

Search for an attachment in a mailbox.

Is there sample VBA code I can use to resolve the following:

Access a mail server and loop through the mailbox and search for a specific attachment name, if found download it to a folder.

View 1 Replies View Related

Can Someone Open My Attachment Using Access 2003?

Feb 6, 2008

Hi,


I posted a question the other day http://www.access-programmers.co.uk/forums/showthread.php?t=143027 about not being able to open an Access 2003 database in Access 2007. It was asking for a password when I hadn't set one.

I gave up on that, started from scratch at home on Access 2007 last night and then saved the database in Access 2003 format. Took it to work on my USB drive today - where we use Access 2003 SP3 - tried to open it and had a message pop up saying that the database was an unrecognised format, or words to that effect. This is bugging the heck outta me!

I'm really beginning to suspect there is a problem with Access at work. Our IT guy downloaded the hotfix suggested by Moniker, but I can't see if it made any difference.

I've taken a fresh copy of my A2007 database, saved it in A2003 format again and attached it as zipped file below. Can someone just please see if it opens properly on their PC? It's very rough and ready as I only spent about an hour on it last night, but I just need someone to tell me if they can see the tables, forms etc.

- If you CAN open it, then I've got some evidence that there's a problem at work and can maybe talk our IT dept into a reinstall (or a new PC)

- If you CAN'T open it, then I must be doing somethnig wrong here and I'd really appreciate further advice.

Thank you very much for your help.

View 6 Replies View Related

Modules & VBA :: Send Attachment From Access

Feb 4, 2015

I have a button when pressed that it sends an email from lotus notes and inputs relevant text etc, however I seem to be struggling on how to have an attachment sent with the email. So everytime the button is pressed it will attach a word document.

View 1 Replies View Related

Tables :: Attachment Field With No Subfields

Feb 11, 2015

I wanted to add a field of " Attachment" to an existing table an as usual, I entered field name " Attach" and the Data Type , I chose "Attachment". Then saved.

Checked with the Datasheet view, there it is, tried to click on the field , the dialog box appeared. cool

The strange part is when I want to put an attachment field in a form , there were no sub fields only one word "Attachment", there is no + or - .

I tried to add the field to the form so I can add attachments, but it stayed there like a normal field.

why my attachment field do not carry the sub fields of attachment like attachment-FileData, attachment-FileType and attachment -File Name.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved