PC Review


Reply
Thread Tools Rate Thread

How to create memo form macro that pauses to fill in text?

 
 
=?Utf-8?B?TWFyeSBKYW5l?=
Guest
Posts: n/a
 
      8th Aug 2007
How do I create a macro for a memo that when you run the macro it pauses so
you can fill in text, such as after "TO:" and then after you enter text
there, it pauses after "FROM:", etc.?
--
Your two-legged relative
 
Reply With Quote
 
 
 
 
Robert M. Franz (RMF)
Guest
Posts: n/a
 
      8th Aug 2007
Hi Mary Jany

Mary Jane wrote:
> How do I create a macro for a memo that when you run the macro it pauses so
> you can fill in text, such as after "TO:" and then after you enter text
> there, it pauses after "FROM:", etc.?


you'd be better off in one of the vba related groups. Would the Macro
itself write the "TO" and "FROM"? Are you talking about an Outlook email
message? Maybe you need a form, not a macro?

2cents
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word
 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      8th Aug 2007
Sounds to me like you need a template rather than a macro. And, as a matter
of fact, Word ships with several memo templates.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Mary Jane" <(E-Mail Removed)> wrote in message
news:A8CC3C0B-06C9-4FDB-A5C5-(E-Mail Removed)...
> How do I create a macro for a memo that when you run the macro it pauses

so
> you can fill in text, such as after "TO:" and then after you enter text
> there, it pauses after "FROM:", etc.?
> --
> Your two-legged relative


 
Reply With Quote
 
=?Utf-8?B?TWFyeSBKYW5l?=
Guest
Posts: n/a
 
      9th Aug 2007
OK. What is VBA? Yes, the macro would itself would write the TO and FROM.
Not talking about an Outlook email. I'm working in Word's word processing
software. No, I don't want a form or template. Thanks for your assistance.
Any ideas, and how can I find out about VBA stuff?
--
Your two-legged relative


"Robert M. Franz (RMF)" wrote:

> Hi Mary Jany
>
> Mary Jane wrote:
> > How do I create a macro for a memo that when you run the macro it pauses so
> > you can fill in text, such as after "TO:" and then after you enter text
> > there, it pauses after "FROM:", etc.?

>
> you'd be better off in one of the vba related groups. Would the Macro
> itself write the "TO" and "FROM"? Are you talking about an Outlook email
> message? Maybe you need a form, not a macro?
>
> 2cents
> Robert
> --
> /"\ ASCII Ribbon Campaign | MS
> \ / | MVP
> X Against HTML | for
> / \ in e-mail & news | Word
>

 
Reply With Quote
 
=?Utf-8?B?TWFyeSBKYW5l?=
Guest
Posts: n/a
 
      9th Aug 2007
Does a template pause for entering text? If so, which one would you suggest
I use?
--
Your two-legged relative


"Suzanne S. Barnhill" wrote:

> Sounds to me like you need a template rather than a macro. And, as a matter
> of fact, Word ships with several memo templates.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
> Word MVP FAQ site: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> "Mary Jane" <(E-Mail Removed)> wrote in message
> news:A8CC3C0B-06C9-4FDB-A5C5-(E-Mail Removed)...
> > How do I create a macro for a memo that when you run the macro it pauses

> so
> > you can fill in text, such as after "TO:" and then after you enter text
> > there, it pauses after "FROM:", etc.?
> > --
> > Your two-legged relative

>
>

 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      9th Aug 2007
You can use macrobutton fields as place markers for your inserted text
http://www.gmayor.com/Macrobutton.htm , or you could create a userform to
prompt for the information to be inserted. The only time you would need a
macro to pause for user input would be if the macro was writing the whole
memo, which I don't see as viable unless it is always the *same* memo you
are creating?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Mary Jane wrote:
> Does a template pause for entering text? If so, which one would you
> suggest I use?
>
>> Sounds to me like you need a template rather than a macro. And, as a
>> matter of fact, Word ships with several memo templates.
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>> Word MVP FAQ site: http://word.mvps.org
>> Email cannot be acknowledged; please post all follow-ups to the
>> newsgroup so all may benefit.
>>
>> "Mary Jane" <(E-Mail Removed)> wrote in message
>> news:A8CC3C0B-06C9-4FDB-A5C5-(E-Mail Removed)...
>>> How do I create a macro for a memo that when you run the macro it
>>> pauses so you can fill in text, such as after "TO:" and then after
>>> you enter text there, it pauses after "FROM:", etc.?
>>> --
>>> Your two-legged relative



 
Reply With Quote
 
Robert M. Franz (RMF)
Guest
Posts: n/a
 
      9th Aug 2007
Hi MJ

Mary Jane wrote:
> Does a template pause for entering text? If so, which one would you suggest
> I use?


it's exactly the "pause" that made me think you need a macro. Because I
then assume you are having an automatism (a macro) running behind the
scenes.

[Hence my pointer to VBA = VisualBasic for Applications.]

But if you don't need that, then you may use a form or a normal
template. Put a 2x2 table in it, left side is the "TO"/"CC", right s for
the user to write into what he needs.

Sometimes, we're thinking too far, it seems ... :-)

Greetings
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use VBA in PowerPoint macro to create no fill in a text box rmccafferty General Software 0 22nd Nov 2009 12:57 AM
How do I create a macro to fill in an outlook form? FStuttgen Microsoft Outlook Discussion 1 27th Jan 2009 07:17 PM
How can I create a macro that pauses while I input information? Diane G Microsoft Word Document Management 1 8th Jan 2009 09:38 PM
How can I create an exit macro to validate a Text Form Field? Kamran Microsoft Word Document Management 1 25th Oct 2008 12:05 AM
create unbound memo in form =?Utf-8?B?c2VndXJhcmw=?= Microsoft Access Forms 3 1st May 2007 10:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:32 AM.