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
 
S

Sue Mosher [MVP]

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 6
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
T Outlook roaming signatures Using Outlook 2
S Adding a recipient's column to Sent folder in Outlook 2010 Outlook VBA and Custom Forms 1
J Outlook search bar in Office 2021 Professional Using Outlook 0
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
C How to fix outlook continuing to prompt fo an Exchange password Using Outlook 0
C Outlook doesn't feel reliable, anymore Using Outlook 5
J Outlook 2016 Trying to get Outlook 2016 to work with Office 365 Using Outlook 0
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
U Outlook not responding when trying to print Emails Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
S Sync Outlook (2021) tasks with Microsoft To Do Using Outlook 1
L Duplicate calendar entries in Outlook 365 Using Outlook 4
V Outlook 2021 Can anyone explain why my Outlook views keep changing?! Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 5
S Outlook 2021 How to customize colors Outlook 2021 & Office 2021 on PC Using Outlook 2
D Outlook 2007 Recovering E-Mails Using Outlook 0
G Stop Outlook 365 adding meetings to calendar Using Outlook 2
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
D Gmail mail is being delivered to a different email inbox in Outlook App 2021 Using Outlook 2
Albert McCann Outlook 2021 Outlook Display of HTML Email from two senders is glitchy Using Outlook 0
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
J Unable to delete folders in Outlook 2019 / Windows Using Outlook 1
K Outlook for Mac problems Using Outlook 0
D Outlook app 2021 & iCloud PST issues Using Outlook 2
M c# vsto Outlook.ApplicationEvents_11_NewMailEx Outlook VBA and Custom Forms 1
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Christopher M Is it me, or is Outlook 365 BUGGY? Using Outlook 3
U Outlook on the iPhone cannot approve filtered Emails Using Outlook 0
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 1
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
M Understanding Outlook Identities Using Outlook 1
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
P Outlook 2013 search no longer works Using Outlook 2
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 0
R MailTips and older Outlook versions Using Outlook 0
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10

Similar threads

Top