Change Output File Name During Send Object Routine

Apr 3, 2007

I have a query that runs based on a parameter a user selects on a form.

I want to dynamically create the sendobject file name based on the parameter the user selects.

Example:

My form has a parameter named medicine. When the user checks the checkbox next to medicine it runs a query for records labeled as medicine but sends the e-mail output as the query name. I want something like medicine.txt etcc...

thanks

:confused:

View Replies


ADVERTISEMENT

Modules & VBA :: How To Change Name Of File Output Report Is Being Saved As When In PDF

Jun 4, 2014

DoCmd.OutputTo acOutputReport, "Estimate", acFormatPDF, "c:TestMyReport.pdf"

the following code saves my report in a folder called test as a pdf file with the name MyReport. I have a string variable called RepName. How can I make the report get saved under that name.

I tried
DoCmd.OutputTo acOutputReport, "Estimate", acFormatPDF, "c:Test&MyReport&.pdf" but it dosent work.

View 1 Replies View Related

Modules & VBA :: Routine To Output Access Report To PDF Using Fields

Jul 3, 2013

I have a routine that outputs an MS Access report as a pdf file which works OK. It does not open the file which is what I want.

DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:UsersJEFF1Documents
ptTransactionInvoiceExc VAT.pdf", False

What I would like to do is output the pdf file with a Customer name and number from the field Me.txtAmazonBuyer. I have tried:

DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:UsersJEFF1Documents" + ([Me.txtAmazonBuyer]) + ".pdf", False

But no joy.

View 7 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

Faxing A Form With Send Object.

Nov 3, 2005

i have a form, every post on this form is connected to a deliverer in a table, every deliverer has a faxnr.
I want to be able to push a button on a form and it will fax the form to that deliverer, how woud this be done?
Ive checked that microsoft page about send object and stuff but i dont get much and it doesnt seem to be what i want to do.
Is this thing even possible in access?

When i try a sendobject command, i get "coudnt start the mail software, check that the software works" translated from swedish.@@1@@1

View 1 Replies View Related

Send Object Via Lotus Notes

Nov 14, 2005

Hi ,
In MS Access,

I used sendobject to send the object via Lotus Notes, but I want to skip to click the Send button from the Lotus Notes, everytime, when I sent, it goes to the Lotus Notes, then I need to click the send button again on the Lotus Notes for confirmation to send the mail. How can I skip it?

sendobject ........................, False

I used False or True, it still cannot be solved.

Please let me know, thanks.
Thanks.

View 1 Replies View Related

Send Object Macro Via Outlook

Dec 23, 2005

Hoping someone can help - need to know if there is a way to use a Outlook message other than the blank one that is used with the send object macro.

Maybe a normal message with a signature, template or something - when the macro is run, no formatting is included with the e-mail message, and the body of the message is limited to 255 charaacters.

Would like to use a customized message, and I need the send object macro to place the object in that message format.

If anyone can help, I would greatly appreciate it...thanks.

View 1 Replies View Related

General :: Emailing With Send Object

Nov 23, 2012

I am using a command button to email an invoice to a customer using the sendobject function, whilst this almost works correctly it is adding an additional mailto:address along with the correct email address.

Example: CorrectEmailAddress and then#mailto:CorrectEmailAddress

The code I am using is:

On Error Resume Next
Dim Cusemail As String
Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "")
If Cusemail = "" Then
MsgBox "No email Address"
Exit Sub

[code]....

View 6 Replies View Related

Very Basic DoCmd.Send Object Help Needed

Sep 18, 2006

ok, i have been searching on google and the forums for sending forms/reports as outlook atachments.

all the examples i have seen are more complicated than my one.. i have one form.. and i just want to email those details.. in the form are the fields, one textbox where you put the email address, and one send email form button..

i got it working using a long module, that i didnt understand..and then i was told about the DoCmd.SendObject method which looks a lot easier..

i have one request, in the simple database i have uploaded, will someone show me where to put the code.. the db is VERY simple, and quick (one form with a send email button).. and if anyone can spare a few minutes to get this one working i will be very grateful..

View 3 Replies View Related

Modules & VBA :: Send Object - Adding Option To Include CC

Aug 27, 2014

I have a data base in access 2007, and I'm trying to add into my code one option that includes in the CC: field contacts that I already have in my DB.

This is my code:

Dim rs As Recordset
Dim vRecipientList As String
Dim vMsg As String
Dim vSubject As String

[Code] ......

View 7 Replies View Related

Forms :: Send Object (Encrypt And Digitally Signed)

Apr 25, 2014

When using SendObject to send an e-mail, is there code to turn on the following?

- encrypt,
- digital signature and
- read receipt

Or must the user activate these when the e-mail is generated?

View 2 Replies View Related

Forms :: Using HTML To Format Body In Send Object Method?

Jun 26, 2014

Can I use html to format the message body in send object method ? If I can, how to do that.

View 5 Replies View Related

Queries :: Change Output From Check Box To Y / N

Jan 30, 2015

I have created a query and one of the columns of the output displays a check box because this is the data type of the underlying table.

I would like the query to output either Y or N rather than displaying the checkbox.

How would I do this?

View 3 Replies View Related

Output To An Excel File

Nov 24, 2005

I am having a problem getting Access to output to an excel file.

I want to take a form that I have that has 20 or so records with 6 or 7 fields for each and put it into an excel file that is formated the way I need everythign to look.

I also need it to make the file name such as CCCAAAMMDDYYYY (3 letter company abbreviation,3 letter initials and then todays date) I am thinking that the company abbreviation will be pulled from a query, then initials will be a form that opens, and the date can be pulled from access' date function.

I tried using vb code and doing an output to comand but that did not work.
I am confused someone please help if possible.

View 3 Replies View Related

Output An OLE Image To A File

Mar 31, 2008

Hello, all.

I haven't worked with access in about 2 years, so I'm a bit rusty. I was wondering, what is the easiest way, if any, to output an image stored in an OLE object field to a file, like a bmp to be edited say in paint or something via VB code?

View 3 Replies View Related

Output To A Text File

May 26, 2005

Hi all! I'm not sure if this is the correct area to post this in, but hopefully it is!

I have a Microsoft Access database, and I need to output the content of one of the tables in a specific format-the table contains a Name field, a Description field, a URL field and an Alt Text field, and I need it to end up in a text file in this format:

NAME|DESCRIPTION|URL|ALT|

Where each line of the text field is a different product, and the content of each field is separated by the | symbol (whose name escapes me right now).

Anyone that can help?

Kevin

View 2 Replies View Related

Output To File Where Condition

Aug 2, 2005

I am using a where condition on printing records from a form to restrict output to the current record. I would also like to write the current record only to a file (rtf). Have set up an output to file button which works but writes all records and there is no code option for a where condition.

I can live with this as it is only for backup but a report per record would be a neater solution.

Is this possible anyone know?

Andy

View 4 Replies View Related

Query To Output A CSV Or Excel Like File

Feb 13, 2007

Hi Guys,

I have 2 tables

tblXRFResults

ResultID
SampleName
Date
SampleDate
a few others not necessary in this

and tblXRFResultsConcentration

ResultID (many records linked to 1 record in tblXRFResults)
Concentration
CompoundName

What I need to set up is a query that will allow me to generate a report that will give an excel like format, with the column headings being the SampleName, followed by the CompoundName(s) from the other table and the "rows" will be corresponding sample name and concentrations.
I am sure this is pretty easy, but I am stumped!

Any help would be greatly appreciated.

View 6 Replies View Related

Output Data To Text File

Dec 13, 2004

Could anyone help with a simple answer please ?

I have an Access db that schedules the sending of emails with attachments.
I run a query on the table that returns all active users
I then need to create a separate file for each active user - in the format as shown below.
Each file is called "ddmmXX.epe"
- where dd=day,mm=month,XX=sequential number starting 01.
The file needs to be formatted ascii text file.
The file extension must be .epe

FORMAT:text
TO:{email}
FROM:{from}
CC:{cc}
SUBJECT:{subject}
ATTACHMENT:{attachment}
BODY:{Message}

All the fields within the {} are fields in the Access table
Each file must then be saved to a directory c:mailout
(eg C:mailout141201.epe)

Sample file would look like this:

FORMAT:text
TO:{harry@aol.com}
FROM:{Mat@abcde.com}
CC:{peter@aol.com}
SUBJECT:{Daily Newsletter}
ATTACHMENT:{c:mailews.zip}
BODY:{Please find attached today's newsletter}


Can anyone help - it would be much appreciated, as I am still learning the slightly more advanced methods of VBA.

Thanks

View 9 Replies View Related

Reports :: Where Condition And Output To PDF File

Nov 30, 2013

I would like to print a report file from a database into PDF format.Currently I am using a macro with a "where condition" to select the particular file which currently outputs to the default printer. Converting the macro to VBA reads as follows:

DoCmd.OpenReport "Receipt - full pay new", acViewNormal, "", "[ConsultID]=[Forms]![Payment Record Type]![ConsultID]"

However, if I do an output to PDF file as below, I can't insert a "where condition" to pick the specific file. Instead, it outputs the whole unfiltered report which is 12,000 pages and 29 MB!

DoCmd.OutputTo acOutputReport,"Receipt - full pay new",acFormatPDF,"C:AccessReceiptPDF.pdf"

How to combine the 2, i.e. have the "where condition" to select the particular report page, but output to a PDF file in a selected directory.

View 3 Replies View Related

Modules & VBA :: Report Output To PDF File Name?

Oct 10, 2014

I currently have an invoice report that runs through my database which is e-mailed to clients (automatically through vba), and then saved to a specific file path.

I'm currently having an issue with the saving part of the process with certain clients who have illegal characters in their names - for example, "Client / Other Information" where the '/' is causing the save to fail.

I'm trying to find a way to change the file name of the save file for clients with these illegal characters in their names. I would prefer not to take only part of the name (as some clients are listed as "Town/Village of...") but if there is no other way then there is no other way.

The code I'm currently using is as follows:

Code:
Dim strFilePath as String
strFilePath="C:Users" & Environ("UserName") & "DesktopNew Invoices" & Me.Client.Value & ".pdf"
docmd.OutputTo acOutputReport, , "PDFFormat(*.pdf)", strFilePath, False, "", 0, acExportQualityPrint

View 3 Replies View Related

A Head Scratcher: Output Into A Current File

Sep 8, 2005

Hi
At the moment I am trying to send data ( a query) to a CURRENT Excel file, I do not want it to replace the current file but instead just update the cells of that file to the new values calculated in Access.
Is it possible to do this?

Cheers all
Bikeboardsurf
:confused: :eek: :( :mad: :confused:

View 2 Replies View Related

Form Data Output To Text File

Jul 25, 2005

:confused: I've created a form within our company database which will track hardware/software requests. I'd like to create a macro, or add code to output the data entered into a notepad file. Nothing extraordinary. I'd like for it to be like this:

Ticket: XXXXX
Employee: xxxxx
Reason for Request: xxxxx
Quantity:xxxxx
Part Number:xxxxx
Price:xxxxx
Shipping:xxxxx
Total:xxxxx

Those are the headings of the fields and x's denote entered data. I'd like to keep the headers and have the entered data as well. Is it possible?

Thanks to all for your help

View 1 Replies View Related

Reports :: Output / Print Results Of A Query To Text File

Dec 13, 2013

I have researched on here how to print the results of a query to a text file. I put the code in and I get an error on the openrecordset line. The error says "too few parameters, expected 4"

I tried the query in another report I export to excel and the query works.

I tried printing the whole table using "Select * from tbl_Customers" and it works????

Here is the code:

Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("qryBell1", dbOpenSnapshot)
Dim fs, TextFile
Set fs = CreateObject("Scripting.FileSystemObject")
Set TextFile = fs.CreateTextFile(pathname, True)

[Code] ....

the query returns 6 fields for printing and can filter based on whether 3 fields are filled or not on the form - Date, Campaign, Status

View 6 Replies View Related

Unable To Change Owner For The Database Object

Jun 16, 2005

I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.

What can owner do that admin cannot do?

Please help..

Thanks a bunch.

View 3 Replies View Related

Unable To Change Owner For The Database Object

Jun 16, 2005

I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.

What can owner do that admin cannot do?

Please help..

Thanks a bunch. :confused:

View 4 Replies View Related







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