email attachment (Excel 2000)

Topic

New Reply

Is it possible to create a hypelink in a worksheet that not only creates a new email but also automaticaly attaches the worksheet to the outgoing email?

Thanks

Reply | Quote

Replies

Are you saying that File|Send To|Mail recipient (as Attachment) doesn’t meet your needs? If you are looking to automate a recurring process, can you be more specific? Is is always the same recipients? Will it always be the “same” file?

Reply | Quote

This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their information.

Reply | Quote

It sounds as if the RoutingSlip property is one that you may wish to use. There are a number of references to it in VBA Online Help – including the following code snippet:

Workbooks("BOOK1.XLS").HasRoutingSlip = True
With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Adam Bendel", _
        "Jean Selva", "Bernard Gabor")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
End With
Workbooks("BOOK1.XLS").Route

HTH

Reply | Quote

It sounds as if the RoutingSlip property is one that you may wish to use. There are a number of references to it in VBA Online Help – including the following code snippet:

Workbooks("BOOK1.XLS").HasRoutingSlip = True
With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Adam Bendel", _
        "Jean Selva", "Bernard Gabor")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
End With
Workbooks("BOOK1.XLS").Route

HTH

Reply | Quote

This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their information.

Reply | Quote

Are you saying that File|Send To|Mail recipient (as Attachment) doesn’t meet your needs? If you are looking to automate a recurring process, can you be more specific? Is is always the same recipients? Will it always be the “same” file?

Reply | Quote

Check out the code in Ron de Bruin’s site

Steve

Reply | Quote

Check out the code in Ron de Bruin’s site

Steve

Reply | Quote