ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File Sent To (https://www.excelbanter.com/excel-discussion-misc-queries/113366-file-sent.html)

WCM

File Sent To
 
When I click on the File Send To option for a particular workbook, I want
the "Recipient" to automatically populate. Is there a way to force this
behavior (without using VBA)?

Thanks for your help ...

bill

Tom Ogilvy

File Sent To
 
Doesn't appear to be.

--
Regards,
Tom Ogilvy


"WCM" wrote in message
...
When I click on the File Send To option for a particular workbook, I
want
the "Recipient" to automatically populate. Is there a way to force this
behavior (without using VBA)?

Thanks for your help ...

bill




WCM

File Sent To
 
Thank you Tom - saves me the time trying to go that route.

"Tom Ogilvy" wrote:

Doesn't appear to be.

--
Regards,
Tom Ogilvy


"WCM" wrote in message
...
When I click on the File Send To option for a particular workbook, I
want
the "Recipient" to automatically populate. Is there a way to force this
behavior (without using VBA)?

Thanks for your help ...

bill





Scott L Grimes

File Sent To
 
One of my end users was having a similar problem: she's been using
spreadsheets that remembered addy's, but for some reason they no longer
were so that when she opened the sheet and went to File, Send to, Mail
Recipient that addresses it USED to remember weren't there. What I
found works is: File, Send To, Mail Recipient. Enter the address you
want. Save the file. Send the document. Close the file, reopen it.
File, Send To, Mail Recipient - the last address(es) sent to should be
there.

Not perfect, but if it's a file you'd be sending to the same
person/people over & over, it'll remember that much of it (will
remember multiple addys, CC & BCC included). You'd have to set it up
the first time, but from that point on it remembers.

Not perfect, but may suit your needs. I hope this helps - please let
me know. Thanks!

Scott L Grimes


WCM wrote:
Thank you Tom - saves me the time trying to go that route.

"Tom Ogilvy" wrote:

Doesn't appear to be.

--
Regards,
Tom Ogilvy


"WCM" wrote in message
...
When I click on the File Send To option for a particular workbook, I
want
the "Recipient" to automatically populate. Is there a way to force this
behavior (without using VBA)?

Thanks for your help ...

bill







All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com