Prompts in Outlook Form

Status
Not open for further replies.
L

LDMueller

In Outlook 2003 I have a published form which is a basic letter with the

following in the message box as follows:

Re: Our File Number: XXX

Entitled "XXX"

Issued XXX

Dear XXX:

The 7½ year maintenance fee was duly paid for the above-referenced

patent, as indicated on the attached communication from the U.S. Patent and

Trademark Office. The patent will now remain in force for an additional four

years.

No further action on this patent is required until XXX, at which time

the 11½ year maintenance fee becomes due. We have docketed that date and

recommend that you calendar it as well.

If you have any questions in connection with this matter, please call

XXX.

Sincerely,

Currently I have my user pressing F4 to search for the "XXX" which then they

type the information, then press F4 to go to the next "XXX".

Is there a way to run the form and then be prompted for the information

which goes in the "XXX" fields? I'm thinking I should put some code in the

form, like the following, but I'm not sure how to get it working. I don't

really have Form Fields in this form.

'Prompt user for Our File Number

strFileNo = InputBox("Please enter Our File Number", _

"File Number")

Any assistance would be greatly appreciated.

Thanks,

LDMueller
 
Are you planning to send these to external recipients? I would not use a

published form for that, certainly not without a lot of testing, because in

many environments it will create attachment problems for external recipients

who are not using Outlook. I would handle this either with a Word document

and mail merge or as a saved .oft file with a VBA macro to create a new item

from the file and then prompt the user -- preferably with a VBA user form,

but multiple InputBox() calls would also work. Instead of XXX, you'd want a

unique token string in the message body for each "field."

If you don't want to write code, you might want to look at the Email

Templates tool at http://www.emailtemplates.com.

Sue Mosher

"LDMueller" <LDMueller> wrote in message

news:78C26487-BB8E-4DF7-96E7-57B4AE05FD7E@microsoft.com...
> In Outlook 2003 I have a published form which is a basic letter with the
> following in the message box as follows:

> Re: Our File Number: XXX
> Entitled "XXX"
> Issued XXX

> Dear XXX:

> The 7½ year maintenance fee was duly paid for the above-referenced
> patent, as indicated on the attached communication from the U.S. Patent
> and
> Trademark Office. The patent will now remain in force for an additional
> four
> years.

> No further action on this patent is required until XXX, at which time
> the 11½ year maintenance fee becomes due. We have docketed that date and
> recommend that you calendar it as well.

> If you have any questions in connection with this matter, please call
> XXX.

> Sincerely,

> Currently I have my user pressing F4 to search for the "XXX" which then
> they
> type the information, then press F4 to go to the next "XXX".

> Is there a way to run the form and then be prompted for the information
> which goes in the "XXX" fields? I'm thinking I should put some code in
> the
> form, like the following, but I'm not sure how to get it working. I don't
> really have Form Fields in this form.

> 'Prompt user for Our File Number
> strFileNo = InputBox("Please enter Our File Number", _
> "File Number")

> Any assistance would be greatly appreciated.

> Thanks,

> LDMueller
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 11
E Outlook 2016 and Numerous Prompts to Save Emails Using Outlook 3
Mark Foley Outlook prompts for IMAP user/PW when domain PW changes Using Outlook 0
D Constant Dropbox Outlook Addin Authentication Prompts Using Outlook 5
E Outlook prompts to save attachments when no changes have been made. Using Outlook 0
O closing outlook prompts to save all opened attachments Using Outlook 2
M Repeated password prompts Using Outlook 1
M Forwarding vCard prompts Send As (From field) on Contacts that were moved Using Outlook 6
T How to determine if email address resides in Exchange w/o OutlookSecurity prompts? Outlook VBA and Custom Forms 1
Z Hotmail account deleted from outlook and issue with account not exist Using Outlook 0
J 'Name on the security certificate is invalid or...' - Outlook on desktop talking to hotmail.com account Using Outlook.com accounts in Outlook 4
J Outlook, Word, Access crash unless run in Admin mode - time dependent it seems Using Outlook 10
T Why do Outlook Desktop 2021 tasks from my wife's email show up in my task pane? Using Outlook 2
B Delete Read Receipts in Your Outlook Outlook VBA and Custom Forms 0
M Outlook changes the "Modified" field when moving/copying a Contact. Using Outlook 0
macdotcom Outlook 365 Outlook folder export to PST archival tool - close, but need a nudge Outlook VBA and Custom Forms 2
M Outlook 2016 still feature updating Using Outlook 0
e_a_g_l_e_p_i Question about Outlook 2021 and Gmail Using Outlook 9
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 3
P Limited Support for 3rd Party Mail in new Outlook? Using Outlook 1
O Any 3rd party tool that sync (mirror) from Outlook Calendar to Google Calendar? Using Outlook 5
T Outlook is categorizing emails incorrectly Using Outlook 1
R Legacy Outlook on Mac Email Cache Using Outlook 0
A Outlook can't remember outlook.com, Exchange password. Using Outlook 6
S Related messages show in main Outlook window vice new Advanced Find windows Using Outlook 1
H Force Outlook 2019 with GMail 2-Step to Require Login? Using Outlook 0
G Retaining Tabs in outlook body Using Outlook 2
V Setting up Outlook 2021 on new computer Using Outlook 2
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
Victor_50 Problem - Google Workspace will stop "unsafe" access to Outlook end 2024 Using Outlook 3
C New pc, new outlook, is it possible to import auto-complete emailaddress Using Outlook 4
T Outlook 365 won't take new working password Using Outlook 0
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
B Sync Outlook Public Folders to Contacts Using Outlook 2
D Delete Outlook emails from MS server Using Outlook 12
B Outlook tasks and PDF Using Outlook 4
D Outlook 2019 is no longer asking for password ... Using Outlook 5
Kika Melo How to mark as Junk any message not from Contacts (in Outlook.com) Using Outlook 3
L Outlook attachments from OneDrive as links Using Outlook 0
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
M Synchronization and backup of Outlook from local to server. Using Outlook 12
T How to get an EVENT COLOR option in Outlook 2021 ? Using Outlook 0
K How can I delete an e-mail from Outlook Using Outlook 1
V Outlook Error The Attempted operation Failed. An Object Could Not be found Outlook VBA and Custom Forms 0
P Yahoo/IMAP folder rename by Outlook desktop 365 Using Outlook 0
A Outlook 2019 folder counter Using Outlook 0
A Relocate Search Bar in Outlook Using Outlook 2

Similar threads

Back
Top