Mail Merge without using Word

[Garry]

I want todo a mail merge using a excell template as the document tobe
sent out.
1 Excell spreadsheet contains the address and the other the template
letter, Is this possable.

Thanks
Garry

 

[Garry]

If you are talking about putting the address and salutation in the body of a letter that is easy enough to do with a looping macro

for each n in range("a2:a22")
line1=n
line2=n.offset(,1)
line3=n.offset(,2)
line5="Dear "& & n
activesheet.printout
next n

Thanks for the answer, I dont think I have explained this correctly.

I have template (1) spreadsheet which has the below as Headings.

NAme Description Price Serial Number


There is also a field where i can sign and date and a few other
things.




On another (2) spreadsheet I have the same headings with the details
of items below, So Like this.

NAme Description Price Serial Number

Pin Pointed thing 1.7 02345
Pin Pointed thing 1.9 02349

etc etc etc etc.


Get the idea.

So by mergeing (2) into (1) I should have multiple templates filled in
that I can print.

Thanks

 

[Garry]

Thanks for the answer, I dont think I have explained this correctly.

I have template (1) spreadsheet which has the below as Headings.

NAme Description Price Serial Number

There is also a field where i can sign and date and a few other
things.

On another (2) spreadsheet I have the same headings with the details
of items below, So Like this.

NAme    Description     Price   Serial Number

Pin     Pointed thing   1.7     02345
Pin     Pointed thing   1.9     02349

etc     etc             etc     etc.

Get the idea.

So by mergeing (2) into (1) I should have multiple templates filled in
that I can print.

Thanks- Hide quoted text -

- Show quoted text -

Bump..

 

[Don Guillett]

I want todo a mail merge using a excell template as the document tobe
sent out.
1 Excell spreadsheet contains the address and the other the template
letter, Is this possable.

Thanks
Garry

Send file and complete explanation dguillett1 @gmail.com