Access Access - SendObject, Renaming table that's being attached.

J

JWSchlecta

Joined
May 2, 2012
Messages
1
Reaction score
0
I'm using a SendObject command to send a table as an attachment. I know when sending a report you can code to change the caption before sending the object. Is there a similar trick for tables since they don't have a caption in their properties.

I want to rename the attachment using one of the form fields I use for the subject (Forms!f_24_200_0100!ABNumber).

Below is my code:

Dim stSubject As String
stSubject = Forms!f_24_200_0100!ABNumber & " - PreOnboarding - " & Forms!f_24_200_0100!NDX & " - " & Forms!f_24_200_0100!Field_SubmittedBy
DoCmd.SendObject acTable, "t_24_000_2000", "Excel97-Excel2003Workbook(*.xls)", "(e-mail address removed)", "", "", stSubject, "", False, ""

Any help is appreciated!!! JWS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Attach an Excel File to an Email 4
Emailing an Attachment - Code 1
Late binding error - running Ms Access Report in VB.Net 1
Get contents of field in a subform 1
Send Email with Access 2007 1
SendObject - Attachment 2
more sendobject-problem info 5
email using sendobject in access 2

Top