Hi
I haved a spreadsheet with names, addresses, postcode etc that I
usually print onto labels using Word & then stick on envelopes.
Is it possible to print directly onto envelopes?
If so how would I go about that?
Thank you
--
Martin
©¿©¬

"Martin ©¿©¬" wrote in message
...
Hi
I haved a spreadsheet with names, addresses, postcode etc that I
usually print onto labels using Word & then stick on envelopes.
Is it possible to print directly onto envelopes?
If so how would I go about that?
Thank you
--
Martin
©¿©¬

Mail Merge in Word has the option to generate envelopes

Chris

On Thursday, April 5, 2012 6:30:08 AM UTC-5, Martin ©¿©¬ wrote:
Hi
I haved a spreadsheet with names, addresses, postcode etc that I
usually print onto labels using Word & then stick on envelopes.
Is it possible to print directly onto envelopes?
If so how would I go about that?
Thank you
--
Martin
©¿©¬
I have an xl file where I do this using only excel. First you must set up an envelope sheet that prints your envelope on your printer. Then, a looping macro or a double click event (for one) to put the lines of the envelope.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 Then
If ActiveCell.Offset(0, 2) < "" Then
Title = ActiveCell.Offset(0, 2)
Else
Title = ""
End If
If ActiveCell.Offset(0, 1) < "" Then
FirstName = ActiveCell.Offset(0, 1) & " "
Else
FirstName = ""
End If
LastName = ActiveCell
ADDRESSEE = Application.Proper(Title + FirstName + LastName)
[envelope!c6] = ADDRESSEE
[envelope!c7] = ActiveCell.Offset(0, 3)
[envelope!c8] = ActiveCell.Offset(0, 4)
[envelope!c9] = ActiveCell.Offset(0, 5)
Sheets("envelope").Select
End If
End Sub

On Thu, 5 Apr 2012 13:11:45 +0100, "Chris" wrote:


"Martin ©¿©¬" wrote in message
.. .
Hi
I haved a spreadsheet with names, addresses, postcode etc that I
usually print onto labels using Word & then stick on envelopes.
Is it possible to print directly onto envelopes?
If so how would I go about that?
Thank you
--
Martin
©¿©¬

Mail Merge in Word has the option to generate envelopes

Hi Chris
I have tried that, however, after I have chosen my recipients from my
existing list and then went to merge field, the details were all
gobble-de-gook
That was yesterday, today following your reply I tried again with a
different recepients list & it worked fine hiphip!!
So my original receipients list must be faulty
--
Regards
Martin
©¿©¬

YEAH sometimes the printer settings are not adjusted to length or size of print.
Designer,
http://www.trademeters.com/ Point Of Sale Software