Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a ticket in Publisher. I want to mail merge tracking numbers
into it from a list of numbers in Excel. I have never used excel before. I did my list of numbers need to know, with simple directions, how to identify the list as a field in publisher and have publisher recognise that field. Thanks so much for any help on this. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Just put your numbers into a column - with a header. Save the file. Open Publisher and go to Mailmerge/Open Data Source. Select 'Merge information from another type of file' and browse to your file. It will ask if you want to use the first row as field names - that's a Yes. It will then probably ask for a sheet name of the book. It'll probably be Sheet1 - unless you have renamed it. It will then display a list of field names - well, there should only one! Position your cursor where you want to insert your field and put it in there! You can then click on Mailmerge/Merge to show the results. Hope this helps. Andy. "mmcdowell" wrote in message ... I have created a ticket in Publisher. I want to mail merge tracking numbers into it from a list of numbers in Excel. I have never used excel before. I did my list of numbers need to know, with simple directions, how to identify the list as a field in publisher and have publisher recognise that field. Thanks so much for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table not showing field list | Excel Worksheet Functions | |||
find sum in list of of numbers | New Users to Excel | |||
Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
Identify missing record numbers | Excel Worksheet Functions | |||
Create a new list that singles out duplicate numbers | Excel Discussion (Misc queries) |