Macro to select all objects->group->copy->paste in email

[dgold82]

I have a daily repeating role at work where I have to take a report that is
filled with text boxes that need to be grouped together (since it messes up
the formatting if I just try and select all and paste) and then email to a
large distribution list. Can someone help me make a macro that will do this
automatically?

I use Office 2007 and would love to make a command on the quick access
toolbar in Word to do this (up to the point where you click send and specify
recipients). I know it seems small, but it would save me a couple minutes and
take less clicking. Thanks.

 

[Doug Robbins - Word MVP]

You would need to provide a lot more information.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[dgold82]

I'll do my best. The .rtf document that is generated is pretty much just a
bunch of text boxes that are placed all over the document (I don't know why
the report output is generated like that). There is our company logo at the
top left. Kinda reminds me of what an Access report would look like based off
of a query that show project titles and who submitted them and their status.
Here is an example of two lines output on the report:

Project Name Submitter Status Date:
Report #1 John 1/1/09
_________________________________________________
Report #2 David 2/2/09



So each one of those areas is actually outputted as a text box. In order to
copy the RTF and place in an email I need to select all the object by
dragging the mouse over all of them and then grouping them together. Once
they are grouped I can just copy/paste them into an email and it looks fine.

I am looking for a simple Macro that would automatically select all the
objects in the document and then grouping them together. A plus would be if
it automatically calls up an Outlook email and pastes it in, but I don't NEED
that.

Using: XP professional SP2, Office 2007 SP1.

 

[Doug Robbins - Word MVP]

So that I know exactly what you are starting with, can you send a sample
..rtf document to (e-mail address removed) plus a typical email message that you are
creating from it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[dgold82]

Thanks for going out of your way to help me! Works great.