Send Multiples Files Individually

Oct 26, 2005

Hi:
In MS Access:

Can MS Access send multiple files?

eg.
file 1 => send to a@hotmail.com
file 2 => send to b@hotmail.com
file 3 => send to c@hotmail.com
file 4 => send to d@hotmail.com
file 5 => send to e@hotmail.com

send them at the same time, but different address. Can they do that?
I think that it cannot be done this way, right.
I think that it only send a file at a time, right.
Please let me know. Thanks.
Thanks.

View Replies


ADVERTISEMENT

Send Report (Job Information) Individually By Email Address

Sep 17, 2013

I have a template report (R_CurrentJobs) with fields from database.

Fields: FirstName, LastName, Email, JoB Number, TechID, TechName, JobLocation etc...

The query Q_CurrentJobs is a list of jobs to send to the tech for today. (These are open jobs queried).

I need to run this query on the report (R_CurrentJObs) and send the report to each tech based on their individual jobs. The jobs are connected to each tech by its TechID.

The report list the job information for each tech (JOb number, Location details etc.)

When I click the button to send the email. I want to email each tech individually based on the Q_CurrentJobs query using R_CurrentJobs. (DoCmd.SendObject)

View 11 Replies View Related

Send Report (PDF Format) Individually By Email Address

Sep 9, 2013

I need to send the report using DoCmd.SendObject. However, I need to send it based on each tech's job via email.

Currently all tech and jobs on the reports together. I need it to pull the email address and only send to that tech its jobs.

Currently I'm using the basic vba code

DoCmd.SendObject acSendReport, "R_DispatchInspectors", acFormatPDF, "email@me.com", , , "Job number", "Please see attached", False

However do I allows this to send individual report connected to email address. (Which will have each tech's specific jobs sent to them only).

table name: Inspectors (this one have their email address)
Table name: JObs
Report name: R_DispatchInspectors

View 3 Replies View Related

Modules & VBA :: 3 Separate Folders To Send PDF Files

Aug 12, 2015

the code below sends 3 reports to a folder that the vba creates if needed. I would like to change it so the 3 reports go to different folders and creates a folder with the customer name in each of the below folders if needed at present it looks table with one folder address is as I dont know how to make it look up the 3 different records in that table so I would like to just put the 3 folder address in the code

1. ' varFolder = "C:UsersUserDocuments invoice"
2. ' varFolder = "C:UsersUserDocumentscofc"
3. ' varFolder = "C:UsersUserDocumentsdespatch

Code:
Private Sub cmdPDF_Click()
On Error GoTo Err_Handler
Const FOLDER_EXISTS = 75

[Code].....

View 2 Replies View Related

Modules & VBA :: Open Files With Hyperlinks And Send As Attachments?

May 15, 2014

I have a database which has several records with at least 5 documents needing to be attached to each record. Using attachments or OLE would cause considerable bloat, so I opted for hyperlink fields for all the document types necessary to save with each record. However, now I am faced with an issue. It is easy enough to write code to open the files by following the hyperlinks, as well as write code to send an email, but how would I go about combining the two? I need to write a code that will attach these documents to an email, as attachments and not as hyperlinks. I know with excel documents, I could follow the hyperlink and send the document by email through excel, but I also have images converted to pdf's that need to be sent as attachments.

View 4 Replies View Related

Any Way To Individually Reference A Tag?

Aug 13, 2013

I can see how to iterate over all the controls to find the Tag collection, then do something with it.

Problem is that since I know the name of the tag, I just want to do something with it (height, visibility, etc). But I can't figure out how to reference a tag directly without iterating over all the controls.

Something like me.tag("tagname").height=0

View 8 Replies View Related

Queries :: Query From Multiples Into One Record?

Jun 18, 2013

We have a query that pulls information from four tables. What we need to do is do a query or something else to pull the data from the existing query into a table/excel file. The problem we are having is that we want just one record for each person with all of their class selections in one field. Is this doable?

View 4 Replies View Related

DCount Multiples - Replacement Check

Jan 30, 2012

Is there a way to DCount Multiples?

=DCount("*","[Personnel Information]","[prp-requires replacement] = -1"&"[PRP Position Status]='Certified' or 'postured to PRP position'")

is what I got and obviously having issues with. I basically want to count who has prp requires replacement check that are currently certified or postured.

View 2 Replies View Related

Count By Weeks Not Individually :(

Nov 27, 2007

Hello all!, I am new to the form

I have one problem I can't seem to get to the bottom of. I have a database that counts the attendance of my basketball team. Everything works great but I have one problem. Our basketball program is 12 weeks for each student. Now students can join any time but all of them are required to stay 12 weeks to complete the training. How do I get Access to tell me how many weeks a student has left in the program? As i was saying it is easy for me to add together the days of the week that the student attended, but I can't seem to figure out how to get the amount of weeks a student been attending. One more thing, I know this is asking alot but is there a way to have an extra column that allow me to add additional weeks to certain individuals (for the students that like to skip a week or to)?

Any help would be appreciated

View 4 Replies View Related

Reports :: Printing Multiples Of Specific Pages

Mar 28, 2013

How would I go about printing multiple pages of a certain page in a report. My goal is to get them to collate together. Please see example below:

I have 7 operation codes (A-G), but I need multiple copies of each within a set:

Below is how I would like to print it out:

A, A, B, C, D, D, A, E F, G

Also, not sure if it matters, but the report has a subreport to print the appropriate rework code on the back of every sheet (2 sided printing)

This will be the same every time, and I have made a tbl in the db with the order I require.

View 1 Replies View Related

Multiples Of Same Record Show Up When Paging Through Records

Mar 5, 2013

I have an Inventory database with 2 tables. Here is a simplified version of both tables:

First Table is Inventory:
Fields are
ID
Description
PackSize
PackCost

Second table is PriceHistory:
Fields are
ID
InventoryID
Date
PackCost

Fields are joined, one to many (one inventory record can have many prices in its history). ID in the inventory table is joined to InventoryID in the PriceHistory table.

The problem comes when I am browsing records in FORM VIEW of the inventory table:

As I page through the inventory records, I often see the same record multiple times (once for each entry in the pricehistory table).

For example, if the item POTATOES in the Inventory table has had it's price updated 3 times (3 entries in the PriceHistory) table, then I see the Potatoes record 3 times as I am browsing.

I only want to see this record once (with the latest price) when I am browsing the Inventory table in form view.

View 1 Replies View Related

Selecting Multiples Values From Listbox To Generate Report.

Aug 5, 2004

I have searched all the forms but could'nt find any answer which would help me , I have created a listbox , it works fine till the moment i set its 'Multi select' property to SIMPLE or EXTENDED , the minute i do that i get no results in my query , could someone please help me with this , i really really need to get this workin!! I have also uploaded my database so u could try it yourself...

View 11 Replies View Related

Forms :: How To Individually Adjust Width Of Controls

Jan 17, 2015

I have created a form using Create|Form.

I have now opened it in Design view and wish to adjust the width of the controls - text boxes etc but when I try to adjust one, all of the text boxes in that column are adjusted.

How do I individually adjust the widths?

View 8 Replies View Related

Forms :: How To Filter Combo Boxes Individually Based On Value In Another Field On Same Row

Jul 1, 2013

I have a subform with the following fields:

Client name, Country, Country ID

I want to add to every row a combobox with a list of towns depending on the value in the field Country ID.how do I filter the comboboxes individually based on a value in another field on the same row?

View 1 Replies View Related

Modules & VBA :: Loop Through Files And Then Compare With Files In Database Table

Nov 11, 2013

I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .

Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files

[code]...

View 7 Replies View Related

Using MDB Files Which Are Backed Up Hourly Into Zip Files

May 2, 2012

Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.

What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?

View 3 Replies View Related

Send Object

Oct 4, 2006

Is there a way to tie a send object to a combo box on a form? I know I can write a query to pull information from a selection in a combo box using the [form][formname]thing. What I'm trying to do is I've created a database that allows many users to enter a request in a form. then when the form is complete they need to E-mail the form to their respective manager. I want them to choose from a combo box, then click on a button and the form is e-mailed to their manager for approval. I've gotten everything else to work accept for being able to choose the manager. I know I could also leave that blank and it will ask for them to enter the recipients name. If that's my only option I'm ok with that.

Thanks

PS If this issue has already been addressed I couldn't find it.

View 1 Replies View Related

Send Email

Jul 16, 2006

I have a field containing a email address, I would like on double clicking on it to open OUTLOOK for sending a email

Thanx

Marco

View 1 Replies View Related

How Send The Letter

Dec 31, 2004

Hello all:



In order to set up an multi-receiver email program with ASP/AccessDB,

I downloaded “Beginners ASP mailing list program” “newsletter.zip”



After unzipped it, it contains 11 files. I put them all in the wwwroot of IIS.

I have made the address database “newsletter.mdb” successfully. The next

step is to send letter.



First using “newslettercreat.htm” to write a letter and then press “submit”.

After submitting, it prompt a IE page with address “newlettercreat.asp”, but

says: “The page cannot be displayed” and with following

information:

---------------------------------------------------

Technical Information (for support personnel)
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/newslettercreate.asp, line 22So, the letter can not be sent.

What is the ERROR of “Server object, ASP 0177 (0x800401F3) Invalid class string” ?

My OS is winXP pro, email program is Outlook Express. Who could help l me solve
this problem? Thanks!

View 1 Replies View Related

Net Send Via Access/VB?

Feb 16, 2005

Hello!
I am currently trying to devellop a DB for stock management. I would like to allow the DB to send me a message (like a 'net send') to warn me if an item of stock is runing low i.e. if part n. 123 is less than 10 in stock the DB sends the message. For this to work I must also have the users decrease the stock items as they take them out.
Would any of have any suggestions?
Thanx

View 4 Replies View Related

Send Email Via Contact DB

Sep 25, 2005

I have a contact database which store email address and other info for customers. I have searched and searched. How can I use these email links to open and email to the contact? Such as how to email you@there.com from DAP or Form? So the user can click on the email address and auto open Outlook to send that contact an email? This is so much easier in webpage building :o Any direction would be greatly appreciated. Thanks guys :)

View 2 Replies View Related

Send Mail Automateclly

Feb 19, 2006

I send mail massage with the code
DoCmd.SendObject , , , strToField, , , strSubject, strMessage, False


and the access ask me the file attach

how can I send automateclly with no msgbox

View 3 Replies View Related

Send Another User A Message?

Apr 26, 2006

Is there a way to send another user a message within Access? (Like "Instant Messenger" or Lotus Notes "SameTime") If you have any experience or info I would appreciate some info.
Thanks in advance!

View 8 Replies View Related

Send Multiple Emails

Jun 23, 2006

Hi

I am creating a recruitment db for 6 members of staff, I have created a form (add new vacancy). Within the form is a various drop down boxes where you can select each employee and drop down box to pick which company want a vacancy filling. What I wanted to do is when a new vacancy is put on the system, and the administration team select save record is it possible to email the employee to let them know a new vacancy has been added, and also email another administration department to send the employee a suitable candidate list with the information provided on the form.
Or am I asking far to much from access.
The two fields that are most important is who the vacancy belongs and which company want the vacancy.
The db is available if you require a look to have a better insight.
Thanks for all your help.

View 5 Replies View Related

HOW NOT To Send 2 Envelopes To The Same Place

Jun 14, 2006

Hey everyone,

I'm playing with my DB a bit and I need help in determing which way to go. When I print out labels for Envelopes or directly on envelopes, sometimes I have people living on the same address (a family), so I would like to save some on printing and actually sending several envelopes to the same address.
Now, I was thinking of doing this through the code in VBA but now I'm thinking if there is maybe more simple and faster way in building a qry.

All the data for the labels and envelops comes to a temp table from where I'm printing out reports...so what I'm not sure, is there a way to make a querry which would go through my temp table sorted by address, pick address1 then address2, if they are the same, check if lastname1 and lastname2 ise the same and then name1=name1 & Name2, delete record2 and go on...

tnx a lot

View 2 Replies View Related

Send One Record Between Two Databases...

Apr 10, 2005

Hi everybody,

I have a situation where two clients will be using the same database design - one of them will be sending information from his database for the other client to add to their database.

This will be on a record by record basis. The form that has the info entered into it also has a subform.

How do I export a single record between databases that have the same fields? I know how to export a table, but not a single record. The fact that the record that needs to be sent is from two tables (ie the main form and the subform that collects the data for those tables) further complicates things for me. Any ideas? :eek:

View 3 Replies View Related







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