Prompts in Outlook Form

  • Thread starter Thread starter LDMueller
  • Start date Start date
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
kburrows Outlook Classic - JPG files are corrupted when opened or saved Using Outlook 3
F Sync Outlook Calendar Using Outlook 0
G Change default font size in sticky notes - Outlook Desktop 2021 Using Outlook 2
C VBA in "New Outlook?" Using Outlook 0
D New Outlook with Business Basic Plans Using Outlook 0
D Outlook 2021 not working with Outlook 2003 installed Using Outlook 5
D Outlook 2003 stopped working - get they dialog box asking for username & Password Using Outlook 2
T Outlook 2021 hangs in close on taskbar occasionally Using Outlook 1
M Duplicate removal feature in Outlook 2021 is faulty Using Outlook 2
D.Moore Outlook COM addins source folder Using Outlook 11
P Removing Outlook 365 Account from Send/Receive Using Outlook 3
kburrows Outlook Automatically Merging Contacts Using Outlook 2
A Outlook 2016 Outlook 2016 vs. New Outlook Using Outlook 4
D Outlook Desktop App Email Software Using Outlook 0
efire9207 VBA Outlook Contacts Outlook VBA and Custom Forms 6
M Outlook not logging in to server Using Outlook 0
J Outlook macro to run before email is being send Outlook VBA and Custom Forms 0
R Outlook 2021 change view Using Outlook 2
K Outlook font corrupted in some point sizes, resets on close/open Using Outlook 2
J Is the Windows Outlook Tasks module really going to be gone? Using Outlook 6
F Outlook 2010 and Hotmail Using Outlook 1
A Outlook 2021 needs 'enter' for people search Using Outlook 2
HarvMan Outlook 365 Inbox Font Using Outlook 8
Retired Geek Outlook on MAC delete duplicate Sent emails Using Outlook 0
S New Outlook - IMAP ISSUES and support for addins? Using Outlook 1
C outlook.com fonts Using Outlook 2
mickymakz Common challenges organizations face when integrating SharePoint and Outlook? Exchange Server Administration 0
R Outlook with several IMAP accounts generating folders with 1111 suffix Using Outlook 0
D Send email from Outlook Alias using Mac? Using Outlook 0
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 2
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0
kburrows "New" Outlook Desktop App Mailbox Size Using Outlook 4
N Best way to sync calendar and contacts between Outlook 365 and Outlook on iPhone Using Outlook 4
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
Y The New Outlook - Q's & Thoughts Using Outlook 28
M Start Outlook 365 at unified inbox Using Outlook 2
B Requesting VBA code to make Outlook prompt for confirmation when deleting a task? Outlook VBA and Custom Forms 4
T In-line reply style in Outlook II Outlook VBA and Custom Forms 1
G Outlook Contact Item.Restrict where FullName is NULL Outlook VBA and Custom Forms 3
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
W Outlook 2021 Hanging on "Sending Emails" Using Outlook 3

Similar threads

Back
Top