I have recently started working for a company who have contact addresses in
Outlook. I need to type individual labels for the letters I type. I have
created a template for the size of label they use. Up to now, I have been
creating autotext entries for the labels as I don't ever need a full mail
merge. This will obviously not be a satisfactory method as the number of
contacts I need increases.

I am wondering whether it would be better to set up an Access database
although this seems a bit much to bring up just one label.

The other problem is to leave whatever I create easy for the guys in the
office to use when I am on holiday! The last person in my job made dozens of
sheets of labels - definitely OTT when only a couple of labels may be needed
for a client over several months!

Any advice would be greatly appreciated.

Many thanks

ab

If you have Outlook as your default e-mail application, you can insert
addresses from Outlook contacts into documents, including labels from the
label wizard. See also http://www.gmayor.com/Macrobutton.htm

--

Graham Mayor - Word MVP

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


oe wrote:
I have recently started working for a company who have contact
addresses in Outlook. I need to type individual labels for the
letters I type. I have created a template for the size of label they
use. Up to now, I have been creating autotext entries for the labels
as I don't ever need a full mail merge. This will obviously not be a
satisfactory method as the number of contacts I need increases.

I am wondering whether it would be better to set up an Access database
although this seems a bit much to bring up just one label.

The other problem is to leave whatever I create easy for the guys in
the office to use when I am on holiday! The last person in my job
made dozens of sheets of labels - definitely OTT when only a couple
of labels may be needed for a client over several months!

Any advice would be greatly appreciated.

Many thanks

ab

Thanks, Graham

I have used the macro code to insert the address from Outlook which seems to
work OK.

I still have the problem outlined in the recent topic "Labels" - when I
insert an address using my label template (each label has a left indentation
of 1 cm and the cell is centre-aligned in Table Properties, only end of cell
mark on label) - an extra blank line is inserted after the address.

I am wondering now if the problem is in Outlook itself or in Word.

It's not really a problem for me to delete the extra line but I would love
to know what is causing it!

ab



"Graham Mayor" wrote in message
...
If you have Outlook as your default e-mail application, you can insert
addresses from Outlook contacts into documents, including labels from the
label wizard. See also http://www.gmayor.com/Macrobutton.htm

--

Graham Mayor - Word MVP

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


oe wrote:
I have recently started working for a company who have contact
addresses in Outlook. I need to type individual labels for the
letters I type. I have created a template for the size of label they
use. Up to now, I have been creating autotext entries for the labels
as I don't ever need a full mail merge. This will obviously not be a
satisfactory method as the number of contacts I need increases.

I am wondering whether it would be better to set up an Access database
although this seems a bit much to bring up just one label.

The other problem is to leave whatever I create easy for the guys in
the office to use when I am on holiday! The last person in my job
made dozens of sheets of labels - definitely OTT when only a couple
of labels may be needed for a client over several months!

Any advice would be greatly appreciated.

Many thanks

ab

It seems likely that the extra line has been saved in the Outlook data.

--

Graham Mayor - Word MVP

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


ab wrote:
Thanks, Graham

I have used the macro code to insert the address from Outlook which
seems to work OK.

I still have the problem outlined in the recent topic "Labels" - when
I insert an address using my label template (each label has a left
indentation of 1 cm and the cell is centre-aligned in Table
Properties, only end of cell mark on label) - an extra blank line is
inserted after the address.
I am wondering now if the problem is in Outlook itself or in Word.

It's not really a problem for me to delete the extra line but I would
love to know what is causing it!

ab



"Graham Mayor" wrote in message
...
If you have Outlook as your default e-mail application, you can
insert addresses from Outlook contacts into documents, including
labels from the label wizard. See also
http://www.gmayor.com/Macrobutton.htm --

Graham Mayor - Word MVP

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


oe wrote:
I have recently started working for a company who have contact
addresses in Outlook. I need to type individual labels for the
letters I type. I have created a template for the size of label they
use. Up to now, I have been creating autotext entries for the labels
as I don't ever need a full mail merge. This will obviously not be a
satisfactory method as the number of contacts I need increases.

I am wondering whether it would be better to set up an Access
database although this seems a bit much to bring up just one label.

The other problem is to leave whatever I create easy for the guys in
the office to use when I am on holiday! The last person in my job
made dozens of sheets of labels - definitely OTT when only a couple
of labels may be needed for a client over several months!

Any advice would be greatly appreciated.

Many thanks

ab

I think I see what is happening now. When I open a document based on my
label template, there is just the end of cell mark (¤) in the centre of the
cell. I then insert address, which is placed above the ¤, which is then
moved down one row - which makes it appear as if it were another paragraph.
The address, therefore, is one row higher than it should be and I have to
press Delete to move the ¤ up to the end of the last line of the address.

"Graham Mayor" wrote in message
...
It seems likely that the extra line has been saved in the Outlook data.

--

Graham Mayor - Word MVP

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


ab wrote:
Thanks, Graham

I have used the macro code to insert the address from Outlook which
seems to work OK.

I still have the problem outlined in the recent topic "Labels" - when
I insert an address using my label template (each label has a left
indentation of 1 cm and the cell is centre-aligned in Table
Properties, only end of cell mark on label) - an extra blank line is
inserted after the address.
I am wondering now if the problem is in Outlook itself or in Word.

It's not really a problem for me to delete the extra line but I would
love to know what is causing it!

ab



"Graham Mayor" wrote in message
...
If you have Outlook as your default e-mail application, you can
insert addresses from Outlook contacts into documents, including
labels from the label wizard. See also
http://www.gmayor.com/Macrobutton.htm --

Graham Mayor - Word MVP

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


oe wrote:
I have recently started working for a company who have contact
addresses in Outlook. I need to type individual labels for the
letters I type. I have created a template for the size of label they
use. Up to now, I have been creating autotext entries for the labels
as I don't ever need a full mail merge. This will obviously not be a
satisfactory method as the number of contacts I need increases.

I am wondering whether it would be better to set up an Access
database although this seems a bit much to bring up just one label.

The other problem is to leave whatever I create easy for the guys in
the office to use when I am on holiday! The last person in my job
made dozens of sheets of labels - definitely OTT when only a couple
of labels may be needed for a client over several months!

Any advice would be greatly appreciated.

Many thanks

ab