problem with copy/paste macro

M

Mike

I want my macro to take me to
Tools>Letters and Mailings>Envolopes and Labels...>Labels
Paste the selected text in Address section
continue to Options>Details and select the Number Down field.

so far i have this:
Sub Macro1()
Selection.Copy
SendKeys "%L%A"
Selection.Paste
SendKeys "%O%D%D"
Dialogs(wdDialogToolsEnvelopesAndLabels).Show
End Sub

If you do it with mouse, it pastes the selected test in Addres section
automatically. When running
SendKeys "%L%O%D"
Dialogs(wdDialogToolsEnvelopesAndLabels).Show
it doesn't put the selected text in there.

Thank you,

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste with formatting 1
Macro launch - Button vs Manual launch , has different results. 4
"Missing Paste Command" instruction 3
Excel Autofilter Copy and Paste with Changing Values 0
Macro to copy a whole table and then paste it in a new doc 5
Copy/Paste Macro; Loop is Misbehaving 2
copy paste methods..... 7
Copy footnote text in new document 0

Top